CODEWITHSUNDEEP
rexcelopenxlsx2
nergul18
nergul18

Reputation: 1

Cannot export or save workbook with openxlsx2 in R

I'm trying to export my workbook object with openxlsx2 package, but I got an error message as following.

dat2 = wb_load("data.xlsx" ,data_only = F, calc_chain = T)
num =  c(600000,12340)
dat2 = dat2 %>% wb_add_data(sheet = 1, x = num, dims = "E17")
wb_save(dat2, file = 'QQQ.xlsx', overwrite = F)

Error in `$<-.data.frame`(`*tmp*`, tmpDirPartName, value = "C:\\Users\\nergul18\\AppData\\Local\\Temp\\RtmpCKmbVx\\workbookTemp_b0cc4801ed2/xl/worksheets/") : 
  replacement has 1 row, data has 0

What does this error mean and How do I handle this one?

Upvotes: 0

Views: 328

Answers (0)

Related Questions