import openpyxl
# 新建周报表
file_path1 = 'G:\法国兰斐\报表\报表数据\每周报表\\weekReport.xlsx'
xlsx_obj = openpyxl.load_workbook(file_path1)
sheet_names = xlsx_obj.sheetnames
data = []
for sheet_name in sheet_names:
sheet_obj = xlsx_obj.active
min_raw = sheet_obj.min_row
max_raw = sheet_obj.max_row
min_clo = sheet_obj.min_column
max_clo = sheet_obj.max_column
for raw in range(min_raw, max_raw + 1):
tem = []
for clo in range(min_clo, max_clo + 1):
cell_data = sheet_obj.cell(raw, clo).value
if cell_data:
tem.append(cell_data)
else:
tem.append(0)
data.append(tem)
new_workbook = openpyxl.Workbook()
new_worksheet = new_workbook.active
new_worksheet.title = 'workReport'
for index, value in enumerate(data):
for clo, clo_value in enumerate(value):
new_worksheet.cell(index + 1, clo + 1, clo_value)
new_workbook.save('G:\法国兰斐\报表\报表数据\每周报表\整周报表\\2021年周报表\\WorkReport.xlsx')
找找for循环的,我猜测是你这有三个for