poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From MSB <markbrd...@tiscali.co.uk>
Subject Re: Java heap space with files >30MB
Date Mon, 07 Dec 2009 07:58:47 GMT

Take a look at the event api;

http://poi.apache.org/spreadsheet/how-to.html#event_api

I have not used it myself but I do understand from reading messages on this
list that many users have processed large files using these techniques
successfully.

Yours

Mark B


Leandro Carvalho wrote:
> 
> Hi all,
> 
> Sorry if this is already an old subject, i really tried to search
> solutions
> about it, but always saying to increase my JVM memory allocation, convert
> my
> XLS files to CSV or even limit the size of my documents. None of them are
> doable in my current project.
> 
> Really simple code:
> HSSFWorkbook wb = new HSSFWorkbook(new POIFSFileSystem(new
> FileInputStream("c:/plan1.xls")));
> 
> Where this "plan1.xls" has more then 30MB (actually my goal is something
> like 200MB).
> And i want to import the content to some database.
> 
> Can it be done?
> 
> I also tried the XLS2CSVmra.class, but got another Java heap space
> excpetion.
> 
> Thank you in advance.
> 
> -- 
> Leandro Carvalho
> 
> 

-- 
View this message in context: http://old.nabble.com/Java-heap-space-with-files-%3E30MB-tp26643190p26673816.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