Disclaimer: I yet have to figure out how to make a reproducible example (because as of now I can't, well, reproduce with a small toy example the issue in one of my files).
But here's the problem:
- I create a workbook in R with
createWorkbook => addWorksheet => writeData => saveWorkbook.
- The data passed via writeData has missings. Saving the workbook just doesn't print them, i.e. leaves the missings as empty cells (good).
- I re-import the Excel file with
loadWorkbook.
- Saving the file again with
saveWorkbook now has replaced the blanks with NA.
Not sure if that is intended or a feature or if there's a setting how I can prevent it.
What is weird is that the only place where I can do something about missings is in writeData. But the problem occurs already when simply loading and saving a workbook (without doing any changes).
Disclaimer: I yet have to figure out how to make a reproducible example (because as of now I can't, well, reproduce with a small toy example the issue in one of my files).
But here's the problem:
createWorkbook=>addWorksheet=>writeData=>saveWorkbook.loadWorkbook.saveWorkbooknow has replaced the blanks with NA.Not sure if that is intended or a feature or if there's a setting how I can prevent it.
What is weird is that the only place where I can do something about missings is in writeData. But the problem occurs already when simply loading and saving a workbook (without doing any changes).