How would you guys delete multiple sheets in an excel file? The only example I could find was something close to this:
removeWorksheet(wb,(2))
How would you guys delete multiple sheets in an excel file? The only example I could find was something close to this:
removeWorksheet(wb,(2))
Im find other solution like this: for delete the second worksheet in excel.
Remmber put the path
and save.
wb = loadWorkbook(path)
removeSheet(wb, sheetName = names(sheets[2]))
saveWorkbook(wb, path)
Thanks, but how would I select multiple sheets without having to hit the same command like 3xs.
Not sure if that makes sense?
I was thinking a loop initially, but then it wouldn't know when to stop right? Best next thing I though would be
putting a list but it didn't work.
This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.
If you have a query related to it or one of the replies, start a new topic and refer back with a link.