thanks Jim, I have tried it but still the same error :/


On Mon, Nov 4, 2013 at 7:34 AM, Jim Holtman <jholtman@gmail.com> wrote:

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

