Good point, indeed it should have been read.xlsx.
Mit freundlichen Gruessen / Cordialement / Best regards Thomas Subia Lean Six Sigma Senior Practitioner DRÄXLMAIER Group DAA Draexlmaier Automotive of America LLC 801 Challenger Street Livermore CA 94551 Ph: 925-978-8111 mailto:thomas.su...@draexlmaier.com http://www.draexlmaier.com “Nous croyons en Dieu. Tous les autres doivent apporter des données. Edward Deming Public -----Original Message----- From: gernop...@gmx.net <gernop...@gmx.net> Sent: Friday, March 15, 2024 1:07 AM To: Subia Thomas OI-US-LIV5 <thomas.su...@draexlmaier.com>; r-help@r-project.org Subject: Aw: Re: [R] write.xlsx error message [You don't often get email from gernop...@gmx.net. Learn why this is important at https://aka.ms/LearnAboutSenderIdentification ] Caution: This email originated from outside the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe. I think remember this error from trying to write an Excel file that already existed. If this file already exists, try to delete it and see, if this solves the issue. Besides that you're writing that you are "Using write.xlsx to extract data from an Excel file", write.xlsx() is to write an Excel file, not to read from it. Should be read.xlsx() then iirc. Gesendet: Freitag, 15. März 2024 um 08:38 Uhr Von: "Ivan Krylov via R-help" <r-help@r-project.org> An: "Subia Thomas OI-US-LIV5" <thomas.su...@draexlmaier.com> Cc: "r-help@r-project.org" <r-help@r-project.org> Betreff: Re: [R] write.xlsx error message В Thu, 14 Mar 2024 14:12:12 +0000 Subia Thomas OI-US-LIV5 <thomas.su...@draexlmaier.com> пишет: > Using write.xlsx to extract data from an Excel file, I get this error > message. > > > Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", > cl, : java.lang.OutOfMemoryError: GC overhead limit exceeded There seems to be a default limit of 512 megabytes for the Java heap size: library(rJava) getOption('java.parameters') # [1] "-Xmx512m" Does if help if you set options(java.parameters = '-Xmx2048m') (or as much as you feel comfortable with) before loading XLConnect? -- Best regards, Ivan ______________________________________________ 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[http://www.R-project.org/posting-guide.html][http://www.R-project.org/posting-guide.html[http://www.R-project.org/posting-guide.html]] and provide commented, minimal, self-contained, reproducible code. ______________________________________________ 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.
