One other thing to try is to convert this to an ".xls" type file. I
use XLConnect a lot and have noticed that the execution times (and
probably the memory usage) is greater for ".xlsx" workbooks since
these are actually '.zip' files internally and therefore have all the
decompression to go through and probably some other things. You might
also put
print(memory.size())
at the end of you 'for' loop to see if memory usage is growing. You
might not see it as part of the R memory depending on how the JVM is
handled, but it worth an attempt. If you have Windows, you can also
use the task manager to monitor memory usage.
On Mon, Dec 31, 2012 at 3:23 PM, eliza botto <eliza_bo...@hotmail.com> wrote:
>
> dear steve,
> thanks for replying. actually i am trying to open an excel file containing 16
> sheets by the following command
>>library(XLConnect)>sheets <- list()>for(i in 1:6) {>sheets[[i]] <-
>>readWorksheetFromFile("DPI.xlsx", sheet=i,region="A1:N1160")>}
> and all i m getting is the error i described earlier. my system has a RAM of
> 4gb. yes, i have increased the value of Xmx to 1gb. the output of my session
> info isR version 2.15.2 (2012-10-26)
> Platform: i386-w64-mingw32/i386 (32-bit)regardselisa
>
>> Date: Mon, 31 Dec 2012 12:52:44 -0500
>> Subject: Re: [R] (no subject)
>> From: mailinglist.honey...@gmail.com
>> To: eliza_bo...@hotmail.com
>> CC: r-help@r-project.org
>>
>> Hi,
>>
>> Firstly -- please use an informative (non-empty!) subject line in your
>> emails.
>>
>> On Mon, Dec 31, 2012 at 11:54 AM, eliza botto <eliza_bo...@hotmail.com>
>> wrote:
>> >
>> > Dear useRs,
>> > I am getting following error while using my R java machine.
>> >>Error: OutOfMemoryError (Java): Java heap space
>> > to get rid of it i used
>> >>options( java.parameters = "-Xmx1200m")
>> > but unfortunatly its not working....
>> > Does anyone ever encountered this error??
>>
>> Have you tried increasing your value for Xmx?
>> Do you have enough RAM for the value of Xmx you are setting?
>> What is the output of your `sessionInfo()`?
>> Can you give a brief explanation (code would be helpful) of what you
>> are trying to do?
>>
>> -steve
>>
>> --
>> Steve Lianoglou
>> Graduate Student: Computational Systems Biology
>> | Memorial Sloan-Kettering Cancer Center
>> | Weill Medical College of Cornell University
>> Contact Info: http://cbio.mskcc.org/~lianos/contact
>
> [[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.
--
Jim Holtman
Data Munger Guru
What is the problem that you are trying to solve?
Tell me what you want to do, not how you want to do it.
______________________________________________
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.
