"Error in addWorksheet(wb, "sheet1") : First argument must be a Workbook"

user_4856969 0
Viewed 7141

I am using ‘openxlsx’ package in R. ٰI want to add some data in xlsx file. I have used following code to create the workbook and add worksheet in it. 

 wb=createWorkbook()
 addWorksheet(wb,"sheet 1")
 writeData(wb,sheet = 1,"From",startCol = 1,startRow = 1)
 writeData(wb,sheet = 1,"To",startCol = 2,startRow = 1)
 writeData(wb,sheet = 1,"From",startCol = 1,startRow = 2)
 writeData(wb,sheet = 1,"From",startCol = 1,startRow = 2)
 saveWorkbook(wb,"file.xlsx",overwrite = TRUE)

This code was working well for a long time, But recently, I am facing this error

Error in addWorksheet(wb, "sheet 1") : First argument must be a Workbook.

How this error will be resolved?

r-xlsx openxlsx xlsx r
6 Answers

I had the same issue with this. I did the followings and it fixed the issue. Maybe it can solve yours.

  • Close R or RStudio.
  • Make sure that your current working directory does not have any other file or folder. In other words, the path in which you would like to save the xlsx is empty prior to running createWorkbook(). If you have already saved any file in there, just copy and paste it somewhere else.
  • Run your code again from the beginning.
user_96210900

I had the same problem and I just unloaded the package, reinstalled it and reloaded it, and it worked (without having to close R studio) :

detach("package:openxlsx", unload=TRUE)

install.packages("openxlsx")

library(openxlsx)
user_122636980

Works for me unload it and re-install (or uninstall) library rio

detach("package:rio", unload=TRUE)
detach("package:openxlsx", unload=TRUE)

install.packages("openxlsx", "rio")

library(openxlsx)
user_23197470

Encountered the same issue, removed library(xlsx) & library(readxl) from script and now runs without issue. Using the below libraries now in script for context:

library(openxlsx)
library(rio)
library(rJava)
user_150346250

I was able to fix this error by disabling XLSX package

detach("package:xlsx", unload = TRUE)
user_91962400

I experienced a similar issue when I tried to re-run code to export an XLSX file. To have my code working well, I just made sure the workbook (wb) was removed from my global environment. I think inserting the following line right before your code may help.

  rm(list=deparse(substitute(wb)),envir=.GlobalEnv)
user_36538400
Related