search

ycphs / openxlsx

openxlsx - a fast way to read and write complex xslx files
https://ycphs.github.io/openxlsx/
Other
220 stars 73 forks source link

Saving Workbook results in "Error in fill$fillFg" #453

Open BalzH opened 8 months ago

BalzH commented 8 months ago

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