Excel 多个 sheet 读取和保存，交换excel多行数据顺序

import numpy as np
import pandas as pd
import xlrd

# 分别读取 Excel 文件中每个 sheet 中数据
excel_name1 = r"E:\测试文件.xlsx"
excel_name2 = r"E:\测试文件1.xlsx"
wb = xlrd.open_workbook(excel_name1)
writer=pd.ExcelWriter(excel_name2)

# 获取workbook中所有的表格
sheets = wb.sheet_names()
for sname in sheets:
    print(sname)
    cd = pd.read_excel(excel_name1,sheet_name=sname)  # 读取每个 sheet 数据
    # 交换最后4行顺序
    df = cd.iloc[np.r_[0:len(cd) - 4, 64, 65, 63, 66]]
    df.to_excel(writer, sheet_name=sname, index=0)  # 向每个 sheet 中写入数据
writer.save()