poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From karthikeyan S <karthiikeyanse...@gmail.com>
Subject Re: How to read 1 million rows in excel (.xlsx) format using Apache poi??
Date Thu, 02 Jul 2015 09:00:32 GMT
i tried that Iterating but it only reading 5.5Lks rows only then it produce 

Exception in thread "main" java.lang.OutOfMemoryError: GC overhead limit
exceeded
	at java.util.Arrays.copyOfRange(Unknown Source)
	at java.lang.String.<init>(Unknown Source)
	at java.lang.StringBuffer.toString(Unknown Source)
	at
org.apache.poi.xssf.usermodel.XSSFRichTextString.utfDecode(XSSFRichTextString.java:489)
	at
org.apache.poi.xssf.usermodel.XSSFRichTextString.getString(XSSFRichTextString.java:294)
	at
org.apache.poi.xssf.usermodel.XSSFCell.getStringCellValue(XSSFCell.java:247)
	at utils.newexcelreader.readData(newexcelreader.java:82)
	at utils.newexcelreader.main(newexcelreader.java:39)




--
View this message in context: http://apache-poi.1045710.n5.nabble.com/How-to-read-1-million-rows-in-excel-xlsx-format-using-Apache-poi-tp5719275p5719278.html
Sent from the POI - User mailing list archive at Nabble.com.

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


Mime
View raw message