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.