Re: How to use POI-XSSF to read the Excel 2007 file which is toolarge

[Harry Yu <50...@qq.com>]

In docs, the Streaming API SXSSF is only for writing very large files, and can't support to read files. Do you know
how to implment this by SXSSF?</:includetail>
  Now I tried to use the streaming API eventmodel. But the same error will also appear, and the problem is that the SharedStringsTable object can't load so large file. So anybody have idea about how to make SharedStringsTable load data by chunks.</:includetail>
 </:includetail> 
  thanks</:includetail>
 Harry Yu
  

 ------------------ Original ------------------
  From:  "Bodo Wippermann"<bo...@bodow.de>;
 Date:  Wed, Nov 14, 2012 01:36 AM
 To:  "user"<us...@poi.apache.org>; 
 
 Subject:  Re: How to use POI-XSSF to read the Excel 2007 file which is toolarge

 

Am 13.11.2012 09:55, schrieb Harry Yu:
> hello,     I met a trouble when I used XSSF to read the 07 file which has 75W records. And its size is about 30M. When I use XSSFWork to load the file. The error would appear : java.lang.OutOfMemory : Java heap space.  I think that the problem is the size of file too large. And JVM can't support enough space.
>      I don't want to simply increase the memory allocation for JVM. Because it's not always useful , if the file which I operate is too much large to over the size of RAM.
>      I would like to know the solution how to load a large amount of records by chunks for downstream processing. Those which api can solve this.  Or anyone have better solutions.
>
>     Thanks
>    Harry Yu
>

perhaps you can use the Streaming API SXSSF ?

regards
Bodo


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

 
</:includetail>