openpyxl版本3.0.9
import openpyxlwb=openpyxl.load_workbook('C:\Users\Administrator\Desktop\1.xlsx')file_name='2.xlsx'df1=wb['1']df1.delete_cols(0)wb.save(file_name)
降低版本没有用,不删除列就不会报错