Package for connecting R and Excel without the Java Virtual Machine

r excel xlsx xlconnect
Stefano Lombardi picture Stefano Lombardi · Mar 25, 2015 · Viewed 9.5k times · Source

A couple of months ago I found on the Internet information about an R package to connect R with Excel and the other way around (doing basically what xlsx and XLConnect do).

However, the main difference with respect to the two above mentioned solutions was that the package wasn't designed to use the JVM (which keeps giving me some trouble).

I've been spending quite some time trying to find the reference for that package, without success.

Can you help me? Many thanks.

Answer

lukeA picture lukeA · Mar 25, 2015

You may want to check out openxlsx:

openxlsx: Read, Write and Edit XLSX Files

Simplifies the creation of .xlsx files by providing a high level interface to writing, styling and editing worksheets. Through the use of Rcpp, read/write times are comparable to the xlsx and XLConnect packages with the added benefit of removing the dependency on Java.

Related questions

How to fix OutOfMemoryError (Java): GC overhead limit exceeded in r?

I have to read a file in a list of folders and save data in R. I use following code for my test data and it works. When I use the code for the actual data then I get this …

Read More
Easy way to export multiple data.frame to multiple Excel worksheets

I am surprised to find that there is no easy way to export multiple data.frame to multiple worksheets of an Excel file? I tried xlsx package, seems it can only write to one sheet (override old sheet); I also …

Read More
Importing a big xlsx file into R?

I'm wondering if anyone knows of a way to import data from a "big" xlsx file (~20Mb). I tried to use xlsx and XLConnect libraries. Unfortunately, both use rJava and I always obtain the same error: > library(XLConnect) > …

Read More