自动化办公篇之python批量改名
#批量命名
import xlwings as xw
app = xw.App(visible=False,add_book=False)
workbook = app.books.open("测试表.xlsx")
for sheet in workbook.sheets:sheet.name=sheet.name.replace("彩印之","银河")
workbook.save()
app.quit()
#批量命名
import xlwings as xw
app = xw.App(visible=False,add_book=False)
workbook = app.books.open("测试表.xlsx")
for sheet in workbook.sheets:sheet.name=sheet.name.replace("彩印之","银河")
workbook.save()
app.quit()