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.
