search

awalker89 / openxlsx

R package for .xlsx file reading and writing.
Other
363 stars 79 forks source link

After updating my excel file and saving it SaveWorkbook, I can't open it #547

Open Rmalcom opened 1 year ago

Rmalcom commented 1 year ago

Expected Behavior

The file is updated and saved.

Actual Behavior

Can't open the file after saving it with saveworkbook image

Steps to Reproduce the Problem

(please attach an example xlsx file if possible)

  1. wb<-loadWorkbook("Jan 2023 Premium.xlsx")

  1. writeData(wb,sheet="Data",df)

  2. saveWorkbook(wb,"Jan 2023 Premium.xlsx",overwrite=T)

sessionInfo()