Hi,

I have to upload data from more than 200 separated excel pages and I am using the read.xlsx function in the xlsx package. Each sheet is an articulated page (made of more than one table plus extra data) and I need to load into a R data frame the different elements I find in each page. This procedure needs to be repeated several times - i.e. on more than one excel file.

Initially I did not have problems and the script run just fine providing the desired data frame. After running a few hundreds sheets now I get this error after I upload each page:

Errore in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl,  : 
  java.lang.OutOfMemoryError: Java heap space

Has this to do with some sort of cache that is being filled up? Can anyone suggest a solution to this error?

Thanks,
Luca


Mr. Luca Meyer
www.lucameyer.com
R version 2.13.2 (2011-09-30)
Mac OS X 10.6.8







	[[alternative HTML version deleted]]

