filePath = os.path.dirname(__file__) #获取当前文件路径
namelist = os.listdir(filePath) #当前路径下所有文件名
for name in namelist:
if name.endswith(".xlsx"): #获取EXCEl的文件名
print(name)
fileName = os.path.dirname(__file__)+'\\'+name #excel文件路径
print(fileName)
wb = openpyxl.load_workbook(fileName)
print(wb.sheetnames)
for sheet in wb:
print(sheet.title,end=' ')
mysheet = wb.create_sheet('mySheet')
print(wb.sheetnames,end=' ')
sheet3 = wb['mySheet']
print(sheet3.title)
ws = wb.active
print(ws)
模板.xlsx
E:\PycharmProjects\exceltext\模板.xlsx
['模板', '成本中心', '查询期间']
模板 成本中心 查询期间 ['模板', '成本中心', '查询期间', 'mySheet'] mySheet
<Worksheet "查询期间">
wb = openpyxl.load_workbook('财务安全生产费计提登记台账-202206.xlsx')
print(wb.sheetnames)
ws= wb.active
print(w