[R] read.xlsx function crashing R Studio
h.wickham at gmail.com
Mon Aug 22 16:44:56 CEST 2016
On Mon, Aug 22, 2016 at 5:54 AM, jim holtman <jholtman at gmail.com> wrote:
> 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.kowitski at icloud.com>
>> 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
>> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
>> PLEASE do read the posting guide http://www.R-project.org/posti
>> and provide commented, minimal, self-contained, reproducible code.
> [[alternative HTML version deleted]]
> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
More information about the R-help