Re: [R] Problem with xlsx package

2013-02-07 Thread da_el
easiest workaround, save the .xlsx to a .xls -- View this message in context: http://r.789695.n4.nabble.com/Problem-with-xlsx-package-tp3298470p4657787.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list

Re: [R] Problem with xlsx package

2011-12-07 Thread jim holtman
I have had better luck with the XLConnect package. On Wed, Dec 7, 2011 at 3:45 PM, R. Michael Weylandt wrote: > And did you try giving more memory to the JVM as suggested above? I'd > imagine that if you have the same problem and the same error, you > would expect to get the same advice directed

Re: [R] Problem with xlsx package

2011-12-07 Thread R. Michael Weylandt
And did you try giving more memory to the JVM as suggested above? I'd imagine that if you have the same problem and the same error, you would expect to get the same advice directed at the same solution. Otherwise, I'd personally plug the XLConnect package over xlsx. I switched to it recently and h

Re: [R] Problem with xlsx package

2011-12-07 Thread sakaton
I have the same problem and same Java error. > sessionInfo() R version 2.13.1 (2011-07-08) Platform: x86_64-pc-mingw32/x64 (64-bit) locale: [1] LC_COLLATE=English_United States.1252 LC_CTYPE=English_United States.1252LC_MONETARY=English_United States.1252 [4] LC_NUMERIC=C

Re: [R] Problem with xlsx package

2011-12-07 Thread B77S
If all else fails, open it in Excel... save as .csv read.csv() Nikhil Joshi wrote > > I am trying to read an xlsx spreadsheet (1506 rows, 501columns) all > populated but getting the following error: > Please advise as to how to get around this issue. > >> res <- read.xlsx("c:\\BSE_v2.xlsx",1

Re: [R] Problem with xlsx package

2011-02-10 Thread Tobias Verbeke
On 02/10/2011 05:30 PM, Gabor Grothendieck wrote: On Thu, Feb 10, 2011 at 10:49 AM, Nikhil Joshi wrote: Gabor, thanks for the suggestion. I did as you have suggested- Started a clean session of R and set the java option. Then I sourced the library and tried to read the xlsx file but got the sa

Re: [R] Problem with xlsx package

2011-02-10 Thread Nikhil Joshi
Gabor, thanks for the suggestion. I did as you have suggested- Started a clean session of R and set the java option. Then I sourced the library and tried to read the xlsx file but got the same error. I am assuming that Java machine is loaded when the package xlsx is sourced and not when the base

Re: [R] Problem with xlsx package

2011-02-10 Thread Gabor Grothendieck
On Thu, Feb 10, 2011 at 10:49 AM, Nikhil Joshi wrote: > Gabor, > thanks for the suggestion. > I did as you have suggested- Started a clean session of R and set the java > option.  Then I sourced the library and tried to read the xlsx file but got > the same error.  I am assuming that Java machine

Re: [R] Problem with xlsx package

2011-02-09 Thread Gabor Grothendieck
On Wed, Feb 9, 2011 at 6:12 PM, Nikhil Joshi wrote: > I am trying to read an xlsx spreadsheet (1506 rows, 501columns) all > populated but getting the following error: > Please advise as to how to get around this issue. > >> res <- read.xlsx("c:\\BSE_v2.xlsx",1) > Error in .jcall("RJavaTools", "Lja

[R] Problem with xlsx package

2011-02-09 Thread Nikhil Joshi
I am trying to read an xlsx spreadsheet (1506 rows, 501columns) all populated but getting the following error: Please advise as to how to get around this issue. > res <- read.xlsx("c:\\BSE_v2.xlsx",1) Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl, : java.lang.OutOfMemor