用workbook.copy_worksheet方法
test_file = "D:/TT_Test/零低流量评估表0205.xlsx"
wb = load_workbook(test_file)
ws1 = wb['Sheet1']
ws2 = wb.copy_worksheet(ws1)#拷贝后的工作表名称为:Sheet1 Copy
ws2.title = 'Result' #修改工作表名称
wb.save(target_file)
用workbook.copy_worksheet方法
test_file = "D:/TT_Test/零低流量评估表0205.xlsx"
wb = load_workbook(test_file)
ws1 = wb['Sheet1']
ws2 = wb.copy_worksheet(ws1)#拷贝后的工作表名称为:Sheet1 Copy
ws2.title = 'Result' #修改工作表名称
wb.save(target_file)