python openpyxl删除excel中 sheet后另存为新excel的极简操作
import openpyxl
wb=openpyxl.load_workbook('old.xlsx')
print(wb.sheetnames)
std=wb.sheetnames[0]
del wb[std]
print(wb.sheetnames)
wb.save('new.xlsx')
python openpyxl删除excel中 sheet后另存为新excel的极简操作
import openpyxl
wb=openpyxl.load_workbook('old.xlsx')
print(wb.sheetnames)
std=wb.sheetnames[0]
del wb[std]
print(wb.sheetnames)
wb.save('new.xlsx')