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.
path
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.