`annex_write_stats()` allow to append and update existing XLSX

IEA-EBC-Annex86 / annex

R package to process and store data for the IEA EBC - Annex 86 - Energy Efficient Indoor Air Quality Management in Residential Buildings project. For details visit https://annex86.iea-ebc.org/. Documentation and examples available on https://iea-ebc-annex86.github.io/annex/

2 stars 0 forks source link

`annex_write_stats()` allow to append and update existing XLSX #9

Closed retostauffer closed 1 year ago

retostauffer commented 1 year ago

Was working on implementing an update and append mode for annex_write_stats() (so far it only allows to replace the entire sheet).

During the development I faced an issue with openxlsx::saveWorkbook which seems to break the XLSX file when updated more than once. Wrote an issue and a possible fix in a pull pull request (https://github.com/ycphs/openxlsx/pull/404). Whilst this seems to resolve the problem we now have the issue that it is not yet in the release of openxlsx.

TBD

retostauffer commented 1 year ago

New open pull request: https://github.com/ycphs/openxlsx/pull/409

retostauffer commented 1 year ago

The maintainer of the openxlsx package merged the pull request to the master branch (see https://github.com/ycphs/openxlsx/pull/409#issuecomment-1517929221) on Feb 11, 2023.

When using openxlsx >= 4.2.5.9001 (the problem encountered above should be fixed. Until the fix is included in the latest release on CRAN please install the latest version of the master branch:

library("remotes")
install_github("ycphs/openxlsx")

Tagging: @gabroko (FYI)