Mirai Solutions GmbH (http://www.mirai-solutions.com) is pleased to announce the availability of XLConnect on github. Whether you want to browse the code or simply want access to the latest development version of XLConnect, visit us on github.
XLConnect can be directly installed from github using the excellent devtools package:
require(devtools)
# Installs the master branch of XLConnect
# (= current development version)
install_github("xlconnect", username = "miraisolutions",
ref = "master")
# Installs XLConnect 0.2-5
install_github("xlconnect", username = "miraisolutions",
ref = "0.2-5")
XLConnect is a comprehensive and cross-platform R package for manipulating Microsoft Excel files from within R. XLConnect differs from other related R packages in that it is completely cross-platform and as such runs under Windows, Unix/Linux and Mac (32- and 64-bit). Moreover, it does not require any installation of Microsoft Excel or any other special drivers to be able to read & write Excel files. The only requirement is a recent version of a Java Runtime Environment (JRE).
This is very interesting, but I have tried to install from Fedora and Mac boxes and I’m getting a compile error with the vignette, which kills the installation. On the Mac the error is:
Error: processing vignette ‘XLConnect.Rnw’ failed with diagnostics:
‘x’ must be an atomic vector
Execution halted
I run Sweave/knitr all the time, so I know I have the necessary TeX goodies.
I’ve tried master, 0.2-4, 0.2-5
Hi Matthew,
oh, interesting. The package built and installed fine on Windows and Linux (Ubuntu) in my case – and it also builds fine on the CRAN side. Could you install the package from CRAN using install.packages(“XLConnect”, type = “source”) and then run the example from section 4 of the XLConnect vignette? Note, rather than copy-pasting from the PDF, you can get to the code using edit(file = system.file(“XLConnect.R”, package = “XLConnect”)). If you can send the traceback together with the output of sessionInfo() to xlconnect-bugs@mirai-solutions.com that would be great.
Thanks,
Martin
Hi Martin,
vignette stuff runs perfectly when installed from source from CRAN. The github stuff seems to be the only problem for me. But the CRAN stuff is great, good enough for me. Seems like a great product.