Saving Workbook results in "Error in fill$fillFg"
BalzH opened this issue · 0 comments
BalzH commented
I have a workbook I have to create a connection to, write some data to it and save it. If I do this however, I get the error message:
Error in fill$fillFg : $ operator is invalid for atomic vectors
with the traceback:
5: .self$createFillNode(style)
4: .self$updateStyles(this.sty)
3: .self$preSaveCleanUp()
2: wb$saveWorkbook()
1: openxlsx::saveWorkbook(wb, file = "SST Template2.xlsx", overwrite = FALSE)
This happens even when I just read the excel file with openxlsx::loadWorkbook
and save it with openxlsx::saveWorkbook
.
The Excel workbook this happened with is available online: Here under Tools > SST Template.
The problem seems to be with the styling options of the workbook, which I do not need. If there is a quick fix I would appreciate it.
I use Version 4.2.5.2 of the openxlsx package.
Thank you