search

trevordixon / excel.js

Native node.js Excel file parser. Only supports xlsx for now.
MIT License
267 stars 85 forks source link

Parsing HUGE Excel workbooks #28

Open damanpradhan opened 10 years ago

damanpradhan commented 10 years ago

I have an Excel workbook that has almost 914090 rows. The activity of parsing this Workbook does not end even after a day and almost 3 GB of memory is consumed and held during the process.

I have tried 60000 rows and it takes almost 5 hrs to get the data in memory and mem use peaks at 2.6 GB.

Is there any workaround for this scenario ?

shrimpwagon commented 7 years ago

Problem was each cell iteration was doing an xpath query on the XML strings.

My merge has all the values going into one array up front then the iteration uses the array index:

52