Hi,

Current implementation reads the whole document into memory.
There is no way to read excel files line by line.

Regards,
Yegor

LS> Using HSSF, what is the correct method to read large excel files line by
LS> line?  
 
LS> In my real world situation the excel file will be very large, over 100
LS> megs.  I need to be able to read the file line by line so that the large
LS> file size does not cause memory issues.
 
LS> I have tried to use a BufferedInputStream to read in the file but that
LS> results in invalid header exceptions when I try to do a read().  I can
LS> use the BufferedInputStream as is if I give the whole thing to the
LS> workbook to process.However this pretty much forces me to read in the
LS> entire file at once does it not?
 
LS> If anyone has any examples, or can round about hint at what I need to do
LS> I would be most appreciative.
 
LS> Thank you,
LS> Levi


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/

Reply via email to