Hello Team,

 

We found this API useful but it is putting us in out of memory problem using
for excel files. Below are some statistics of memory consumed. Can any of
you guide us how to use this API in streaming i.e. a way that instead of
loading complete file, it load first n records and on accessing (n+1)th
record, it unload n loaded records from the memory and load n+1 to 2n
records and so on.

 


File Type

Records

API Used for Excel Manipulation

Operation

File Size (MB)

Memory Consumed (MB)


Excel

25,000

Apache POI

Load Only

2.35 MB

Approx 60 MB

 

I will appreciate if I some sample code or useful links in the reply.

 

Regards,

Faisal Maqsood

 

Reply via email to