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

