Re: [R] Reading data from Excel file in r

[Jim Holtman]

Is this an .xlsx file format?  If so convert to .xls and try again.   .xlsx 
is compressed and takes a lot more resources in XLConnect


Sent from my Verizon Wireless 4G LTE Smartphone

-------- Original message --------
From: Baro <babak...@gmail.com> 
Date: 11/04/2013  09:26  (GMT-05:00) 
To: "Adams, Jean" <jvad...@usgs.gov> 
Cc: R help <r-help@r-project.org> 
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?


On Mon, Nov 4, 2013 at 6:13 AM, Adams, Jean <jvad...@usgs.gov> wrote:

> 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 <- readWorksheet(wb, sheet=getSheets(wb)[1], startRow=1, endRow=79,
> startCol=5, endCol=5)
> odds <- function(x) x[seq(1, length(x), 2)]
> odds(unlist(dat))
>
> Jean
>
>
>
> On Mon, Nov 4, 2013 at 7:47 AM, Baro <babak...@gmail.com> wrote:
>
>> Hi experts,
>>
>> I want to read data from an excel data  like this:
>>
>>  for the fifth column, from first row until 140 but only 1,3,5,7,.....139
>> (only 70 values),
>>
>> How can I do it in R?
>>
>> thanks
>>
>>         [[alternative HTML version deleted]]
>>
>> ______________________________________________
>> R-help@r-project.org mailing list
>> https://stat.ethz.ch/mailman/listinfo/r-help
>> PLEASE do read the posting guide
>> http://www.R-project.org/posting-guide.html
>> and provide commented, minimal, self-contained, reproducible code.
>>
>
>

[[alternative HTML version deleted]]

______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

        [[alternative HTML version deleted]]


______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.