R help - Nov 2013 - Reading data from Excel file in r

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]]

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 <babakbsn at 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 at 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.

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 <babakbsn@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]]

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 <babakbsn@gmail.com> 
Date: 11/04/2013  09:26  (GMT-05:00) 
To: "Adams, Jean" <jvadams@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 <jvadams@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 <babakbsn@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]]