excessive memory consumption when running read.xlsx

[marcin.ko...@gmail.com]

hi, any idea why read.xlsx consumes so much memory? with large files the data import crashes because the process runs out of memory. any suggestions how to get rid of the problem?

[Adrian Dragulescu]

What is large files? How much memory you have on your computer? Show
your code, OS, R session info, etc.

In general, read.xlsx2 uses memory better for large spreadsheets, see also
https://code.google.com/p/rexcel/wiki/FAQ

But yes, the underlying POI java library uses a lot of memory. There
are ways to avoid it, see the project http://poi.apache.org/

Adrian

> --
> You received this message because you are subscribed to the Google Groups
> "R-package-xlsx" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to r-package-xls...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.