Mac代码,windows未知
import openpyxl
wb = openpyxl.load_workbook('要翻转的表格')
sheet = wb.active
nwb = openpyxl.Workbook()
sheet2 = nwb.active
for i in range(1, sheet.max_row + 1):
for j in range(1, sheet.max_column + 1):
sheet2.cell(row=j, column=i).value = sheet.cell(row=i, column=j).value
nwb.save('新表格名称')
执行后在文件目录下多一个表格,前面的项目里有过类似的项目