poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Faisal Maqsood" <fmaqs...@i2cinc.com>
Subject Does POI Support Streaming?
Date Tue, 06 May 2008 08:05:42 GMT
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

 


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message