We are pleased to announce the release of XLConnect 0.2‑12, now available from CRAN and from our GitHub repository.
This release is comprised of the following:
- Moved to Apache POI 3.15-beta1
- Upgraded to Apache Commons Codec 1.10
- Upgraded XLConnectJars dependency to version 0.2-12
- Fixed an issue with formula cell evaluation
- New feature: ability to read password protected files
- Add additional imports to NAMESPACE as future versions of R will only have the base package attached when performing ‘R CMD check’
- Fixed github issue #52: useCachedValues=TRUE shows formulas instead of values
- Fixed github issue #49: if region has only 2 columns then can’t set first column as rownames (thanks to EldarAgalarov and Deleetdk)
- Fixed github issue #53: 1904 date system in mixed columns (thanks to waternova)
- Added ability to skip end rows and columns on import from worksheet (#29; thanks to psychemedia for the feature request)
- Fixed an issue with writeNamedRegion where named regions for 0-row data.frames have been defined with an extended empty row
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).
Please log any enhancement requests or bug reports with a simple and self-contained reproducible example on our GitHub repository.