XLConnect 1.0.6
[This article was first published on Mirai Solutions, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here)
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.
XLConnect 1.0.6 now available from CRAN and from our GitHub repository.
We are pleased to announce the release of XLConnect 1.0.6. This release is mainly a maintenance release and comes with the following changes:
- Add
overwriteFormulaCells
parameter towriteNamedRegion
,appendNamedRegion
,writeWorkSheet
(#173) - Fix setForceFormulaRecalculation / getForceFormulaRecalculation for R >= 4.2.0 (#170)
- Fix building of vignettes (#154)
- Fix java version parsing (#156)
- Remove java version compatibility upper limit (#165)
- Upgrade to Apache POI 5.2.3
While the addition of the overwriteFormulaCells
parameter seems like a new implementation, it is actually an adjustment due to updates in the underlying Apache POI:
- Since XLConnect 1.0.0, formula cells in excel are not overwritten anymore automatically when populating them.
- With the new XLConnect 1.0.6, the default behaviour for
appendNamedRegion
,writeNamedRegion
andwriteWorksheet
will once again overwrite formula cells. - If you don’t want to overwrite such formula cells, specify
overwriteFormulaCells
asFALSE
when calling said functions.
To leave a comment for the author, please follow the link and comment on their blog: Mirai Solutions.
R-bloggers.com offers daily e-mail updates about R news and tutorials about learning R and many other topics. Click here if you're looking to post or find an R/data-science job.
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.