python将excel行列转换(转置).rar

import xlwings as xw app = xw.App(visible=False, add_book=False) workbook = app.books.open(r'C:\Users\Administrator\Desktop\aaa\aaa.xlsx') #修改此路径，excel所在路径 worksheet = workbook.sheets[0] data = worksheet.range('A1').expand('table').options(transpose=True).value worksheet.clear() worksheet.range('A1').expand().value = data workbook.save(r'C:\Users\Administrator\Desktop\aaa\bbb.xlsx') #修改此路径，要将转换后的excel存到哪里 workbook.close() app.quit()