Wireless 4G LTE Smartphone
>
>
>
> Original message
> From: Baro
> Date: 11/04/2013 09:26 (GMT-05:00)
> To: "Adams, Jean"
> Cc: R help
> Subject: Re: [R] Reading data from Excel file in r
>
>
> thanks alot, but now I have another problem:
quot;
Cc: R help
Subject: Re: [R] Reading data from Excel file in r
thanks alot, but now I have another problem: my Excel file is very big and
I get this error, which says:
Error: OutOfMemoryError (Java): Java heap space
Is there any way to read each value one by one and save them in an array
thanks, I changed my code, but still have the same problem :/
On Mon, Nov 4, 2013 at 6:49 AM, Adams, Jean wrote:
> Perhaps the discussion at this link will help ... (see especially the
> second answer).
>
>
> http://stackoverflow.com/questions/7963393/out-of-memory-error-java-when-using-r-and-x
Perhaps the discussion at this link will help ... (see especially the
second answer).
http://stackoverflow.com/questions/7963393/out-of-memory-error-java-when-using-r-and-xlconnect-package
Jean
On Mon, Nov 4, 2013 at 8:26 AM, Baro wrote:
>
> thanks alot, but now I have another problem: my Exc
thanks alot, but now I have another problem: my Excel file is very big and
I get this error, which says:
Error: OutOfMemoryError (Java): Java heap space
Is there any way to read each value one by one and save them in an array?
On Mon, Nov 4, 2013 at 6:13 AM, Adams, Jean wrote:
> You can use t
You can use the XLConnect package to read in a range of rows and columns,
then define a function to subset the odd rows. For example,
library(XLConnect)
wb <- loadWorkbook("C:/temp/MyData.xls")
dat <- readWorksheet(wb, sheet=getSheets(wb)[1], startRow=1, endRow=139,
startCol=5, endCol=5)
dat <- r
Take a look at the "XLConnect" package. I use it for all the
reading/writing for Excel files.
Jim Holtman
Data Munger Guru
What is the problem that you are trying to solve?
Tell me what you want to do, not how you want to do it.
On Mon, Nov 4, 2013 at 8:47 AM, Baro wrote:
> Hi experts,
>
> I
7 matches
Mail list logo
