[R-SIG-Mac] Problem in importing xlsx files

[Simon Urbanek]

On Aug 21, 2012, at 4:27 AM, Yogesh Dhiman <ydhiman at gmail.com> wrote:

> Hello Admin:
> 
> *I am trying hard to get rid of this error during importing xlsx files in r
> *.
> Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl,  :
>  java.lang.OutOfMemoryError: Java heap space
> 

You can increase the Java heap by setting java.parameters. For example if you have enough memory, you can increase the heap to 2Gb by setting

options(java.parameters="-Xmx2g")

*before* you load any packages.

Cheers,
Simon



> Please suggest what should I do. I have used alternative method of
> importing then i got error like
> 
> 
> Error in xls2sep(xls, sheet, verbose = verbose, ..., method = method,  :
>  Intermediate file
> 'C:\.................................................\file15c45663419f.csv'
> missing!
> In addition: Warning message:
> running command '"C:\STRAWB~1\perl\bin\perl.exe"
> "C:/.............................../2.15/gdata/perl/xls2csv.pl"  "Sales
> 2011_12.xlsx"
> "C:\Users\....................................file15c45663419f.csv"
> "AMJ2011"' had status 1
> Error in file.exists(tfn) : invalid 'file' argument
> 
> 
> Please help ASAP
> -- 
> Regards
> Yogesh Dhiman
> *Contact No. *9780620785
> 
> "Even a stopped clock is right twice a day."
> 
> 	[[alternative HTML version deleted]]
> 
> _______________________________________________
> R-SIG-Mac mailing list
> R-SIG-Mac at r-project.org
> https://stat.ethz.ch/mailman/listinfo/r-sig-mac
> 
>