thanks Jim, I have tried it but still the same error :/
On Mon, Nov 4, 2013 at 7:34 AM, Jim Holtman <jholt...@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 <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.