Parsing HUGE Excel workbooks

[damanpradhan]

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]

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