On Aug 21, 2012, at 4:27 AM, Yogesh Dhiman <[email protected]> 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
> [email protected]
> https://stat.ethz.ch/mailman/listinfo/r-sig-mac
>
>
_______________________________________________
R-SIG-Mac mailing list
[email protected]
https://stat.ethz.ch/mailman/listinfo/r-sig-mac
