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.
