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;


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


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

View raw message