Re: To process more than 65536 rows in XSLX file using XSSF reader

2014-10-22 Thread Aram Mirzadeh
ue. In table huge rows are missing. we not use any short type variable > to track rownum. we are not getting any out of memory exception also. > > > > -- > View this message in context: > http://apache-poi.1045710.n5.nabble.com/To-process-more-than-65536-rows-in-XSLX-file-using-X

Re: To process more than 65536 rows in XSLX file using XSSF reader

2014-10-22 Thread ms_guruvai
. -- View this message in context: http://apache-poi.1045710.n5.nabble.com/To-process-more-than-65536-rows-in-XSLX-file-using-XSSF-reader-tp5716872p5716882.html Sent from the POI - User mailing list archive at Nabble.com. - To

Re: To process more than 65536 rows in XSLX file using XSSF reader

2014-10-21 Thread Aram Mirzadeh
8 rows > good. > > > > -- > View this message in context: > http://apache-poi.1045710.n5.nabble.com/To-process-more-than-65536-rows-in-XSLX-file-using-XSSF-reader-tp5716872p5716874.html > Sent from the POI - Us

Re: To process more than 65536 rows in XSLX file using XSSF reader

2014-10-21 Thread ms_guruvai
yes!. we are not using any short type. still only prcoessiong 65538 rows good. -- View this message in context: http://apache-poi.1045710.n5.nabble.com/To-process-more-than-65536-rows-in-XSLX-file-using-XSSF-reader-tp5716872p5716874.html Sent from the POI - User mailing list archive at

Re: To process more than 65536 rows in XSLX file using XSSF reader

2014-10-21 Thread Nick Burch
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 wor

To process more than 65536 rows in XSLX file using XSSF reader

2014-10-21 Thread ms_guruvai
parser.parse(sheetSource); sheet.close(); } where event handler startElement and endElement methods will read each cell and process. -- View this message in context: http://apache-poi.1045710.n5.nabble.com/To-process-more-than-6553