今天学会了转置EXCEK数据并粘贴

#!/usr/bin/python3
import os
import xlwings as xw
import pandas as pd
file = 'C:\\Users\\Administrator\\Desktop\\测试\\统计表.xlsx'
app = xw.App(visible = False, add_book = False)
wb = app.books.open(file)
ws = wb.sheets[0]
values = ws.range('E7').options(pd.DataFrame, header = 1, index = False, expand = 'table').value
values= values.T
values.columns = values.iloc[0]
values.index.name = values.iloc[0].index.name
values.drop(values.iloc[0].index.name, inplace = True)
# print(values.iloc[0].index.name)
ws.range('a15').options(index = False).value = values
# ws['A15'].value = values
wb.save()
wb.close()
app.quit()