北极星

bilibil视频链接import openpyxlwb = openpyxl.load_workbook('example.xlsx')# 获取表单sheet# 方法1：print(wb.sheetnames) # ['Sheet1']# 方法2：for sheet in wb: print(sheet.title) # Sheet1# 创建表单,但并未存入文件中mySheet = wb.create_sheet('mySheet')print(wb.sheetnames