以下是我的代码:
import openpyxl
path = 'D:\测试文件\work\应收账款账龄表--测试.xlsx'
wb =openpyxl.Workbook(path)
ws = wb.active
for row in ws.iter_rows(min_row=2, max_row=7,values_only=True):
wb = openpyxl.Workbook()
new_ws = wb.active
for head in ws.iter_rows(min_row=1, max_row=1,values_only=True):
new_ws.append(head)
new_ws.append(row)
wb.save('D:\测试文件\work\应收账款账龄表-拆分后\\'+row[1]+'.xlsx')