Error message in trying to read a few rows from a large file

[GoogleCodeExporter]

I have an xlsx file with 6 sheets, 3 of which are about 9000x11 and another 3 
of which are 9000x7. Half of the sheets are data, and the other half are 
formulas

Using this type of call (to read in one of the formula sheets)

read.xlsx2(file="xxx.xlsx",sheetName="yyy",startRow=2,endRow=10)

results in this error message:

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

Note that I was only asking to read in a small number of rows.

BTW, I also just made the post from a few minutes ago, but under another 
address ... The file in question here has the same data structure as the one I 
just posted, but this was the real example, not the toy example I just sent. 
Because this error call may be connected to the previous issue, I didn't 
generate a file here as a test case.

Should xlsx2 be able to handle this size problem?

R 1.14.1, Windows 7, xlsx just loaded today (1/20/12) from CRAN

Original issue reported on code.google.com by Joseph.V...@gmail.com on 20 Jan 2012 at 6:34

[GoogleCodeExporter]

see the FAQ on how to increase your java heap space

Original comment by adrian.d...@gmail.com on 27 Jul 2012 at 7:37

• Changed state: Done