win32com: excel移动sheet位置

excel = Dispatch("ket.Application")  # 启动wps excel 应用。Microsoft excel用Excel.Application
excel.Visible = False
file = r'C:\Users\meiya\PycharmProjects\excelFiles\test file.xlsx'


wb = excel.Workbooks.Open(file)
s = wb.Worksheets.Add()
s.Name ='test sheet1'
n = wb.Worksheets.Count
s.Move(None, wb.Worksheets(n))  # 把添加的sheet页的顺序调成最后一个

sheetNames = []
for s in wb.WorkSheets:  # 把sheet名称都放到集合里
    sheetNames.append(s.name)

if "Sheet1" in sheetNames:  # 把默认的Sheet1 删除
    wb.Worksheets("Sheet1").Delete()
    print('删除成功')

for index,i in enumerate(wb.Worksheets):
    print(index, i.Name)

wb.Save()
wb.Close()
excel.Quit()

 

 

 Worksheets.Move 方法 (Excel) | Microsoft Docs