try the openxlsx package
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. On Sun, Aug 21, 2016 at 1:30 PM, Kevin Kowitski <k.kowit...@icloud.com> wrote: > Hey everyone, > > I have used read.xlsx in the past rather than XLConnect for importing > Excel data to R. However, I have been finding now that the read.xlsx > function has been causing my R studio to Time out. I thought it might be > because the R studio I had was out of date so I installed R studio X64 > 3.3.1 and reinstalled the xlsx package but it is still failing. I have > been trying to use XLConnect in it's place which has been working, excpet > that I am running into memory error: > Error: OutOfMemoryError (Java): GC overhead limit exceeded > > I did some online searching and found an option to increase memory: > "options(java.parameters = "-Xmx4g" ) > > but it resulted in this new memory Error: > > Error: OutOfMemoryError (Java): Java heap space > > Can anyone provide me with some help on getting the read.xlsx function > working? > > -Kevin > > ______________________________________________ > R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posti > ng-guide.html > and provide commented, minimal, self-contained, reproducible code. [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see 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.
