Dear Jim,
alot of love for you. i only converted .xlsx to .xls and it worked.
thankyouhappy new year....keep rocking.happy new year to all. this will be my
last post of this year.thanks once again..
elisa
> Date: Mon, 31 Dec 2012 15:44:31 -0500
> Subject: Re: [R] (no subject) low memory in rjava
> From: jholt...@gmail.com
> To: eliza_bo...@hotmail.com
> CC: mailinglist.honey...@gmail.com; r-help@r-project.org
>
> 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.
[[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.
