Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Package for connecting R and Excel without the Java Virtual Machine

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.

like image 796
Stefano Lombardi Avatar asked Mar 25 '15 11:03

Stefano Lombardi


1 Answers

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.

like image 199
lukeA Avatar answered Nov 14 '22 22:11

lukeA