poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nick Burch <apa...@gagravarr.org>
Subject Re: To process more than 65536 rows in XSLX file using XSSF reader
Date Tue, 21 Oct 2014 17:12:30 GMT
On Tue, 21 Oct 2014, ms_guruvai wrote:
> I need to upload xslx file having more than 65536 lines with 25 columns 
> in a single sheet and write in to DB table. I use XSSF Reader event 
> handler API and OPCpacakage classes for both upload and read. When a 
> file contains exactly 65536 rows or less it works fine, but when it 
> exceeds 65536 rows, it's getting corrupted without any exception and 
> table gets loaded with many rows missing.

It should work fine, and we've quite a few unit tests that cover it. Make 
sure you're not using a short as the row counter

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message