You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by karthikeyan S <ka...@gmail.com> on 2015/07/02 11:00:32 UTC
Re: How to read 1 million rows in excel (.xlsx) format using Apache
poi??
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
Re: How to read 1 million rows in excel (.xlsx) format using Apache poi??
Posted by Dominik Stadler <do...@gmx.at>.
No, not related to eclipse.ini in your case. These are commandline
parameters for Java to control how much memory it may consume. You
specify it when you start your application, take a look at
https://docs.oracle.com/cd/E13150_01/jrockit_jvm/jrockit/jrdocs/refman/optionX.html
for details.
Dominik.
On Thu, Jul 2, 2015 at 11:13 AM, karthikeyan S
<ka...@gmail.com> wrote:
> what is Xmx16G ?
>
> what is Xms8G ?
>
> what is Xss256k?
>
> it is in from eclipse.ini file ??
>
>
>
>
>
> --
> 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-tp5719275p5719280.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
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: How to read 1 million rows in excel (.xlsx) format using Apache
poi??
Posted by karthikeyan S <ka...@gmail.com>.
what is Xmx16G ?
what is Xms8G ?
what is Xss256k?
it is in from eclipse.ini file ??
--
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-tp5719275p5719280.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
Re: How to read 1 million rows in excel (.xlsx) format using Apache
poi??
Posted by Andreas Reichel <an...@manticore-projects.com>.
-Xmx16G -Xms8G -Xss256k are your friends.
Cheers.
On Thu, 2015-07-02 at 02:00 -0700, karthikeyan S wrote:
> 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
>