'''
import xlwingsas xw
app=xw.App(visible=False,add_book=False)
app.display_alerts=False
app.screen_updating=False
filepath=r'c:\test.xlsx'
wb=app.books.open(filepath)
x = []# 创建空列表
num =len(wb.sheets)#获取sheet个数
for iin range(0,num):
if i>=0:
sht = wb.sheets[i]
x.append(sht.name)
i +=1 # 计数数量自加1
else:
pass
print(num)
print(x)
'''