thanks, I changed my code, but still have the same problem :/
On Mon, Nov 4, 2013 at 6:49 AM, Adams, Jean <jvad...@usgs.gov> wrote: > Perhaps the discussion at this link will help ... (see especially the > second answer). > > > http://stackoverflow.com/questions/7963393/out-of-memory-error-java-when-using-r-and-xlconnect-package > > Jean > > > On Mon, Nov 4, 2013 at 8:26 AM, Baro <babak...@gmail.com> wrote: > >> >> 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.
