无需Java虚拟机即可连接R和Excel的软件包 [英] Package for connecting R and Excel without the Java Virtual Machine

问题描述

几个月前，我在Internet上发现了有关将R与Excel连接的R软件包的信息，以及相反的方法(基本上是xlsx和XLConnect的操作).

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).

但是，上述两种解决方案的主要区别在于该软件包并非设计用于使用JVM(这总是给我带来麻烦).

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.

推荐答案

您可能想查看 openxlsx :

openxlsx:读取，写入和编辑XLSX文件

openxlsx: Read, Write and Edit XLSX Files

简化了 .xlsx文件，通过提供用于编写​​，样式设置的高级界面 和编辑工作表.通过使用Rcpp，读/写时间为 可与xlsx和XLConnect软件包相媲美，并具有额外的优势 消除对Java的依赖.

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.

这篇关于无需Java虚拟机即可连接R和Excel的软件包的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！