'How can I load an xlsx workbook into R?

I have an xlsx workbook on my desktop with existing sheets. I have a dataframe in R that I would like to add to this workbook as a new sheet.

Using library(openxlsx) I want to do:

wb <- loadWorkbook("workbook.xlsx", isUnzipped=TRUE)
addWorksheet(wb, "New_Sheet")
writeData(wb, "New_Sheet", df)
saveWorkbook(wb, "workbook.xlsx", overwrite=TRUE)

however the program fails at the first line:

wb <- loadWorkbook("workbook.xlsx", isUnzipped=TRUE)

I get the error message:

Error in match(sheetrID, file_rIds): object sheetrId not found

I also created a dummy file (excel workbook with just two existing sheets and some dummy strings in each sheet) and I get the same error message.

I also tried uninstalling openxlsx and re-installing. No change.

r excel openxlsx

Solution 1:^[1]

As mentioned in the comments by @MrFlick (thank you!), Excel files are actually zipped files that contain XML files. So the workbook must be unzipped before it can be opened in R.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	Brenda Thompson

'How can I load an xlsx workbook into R?

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]