python的openpyxl的sheet.column_dimensions[i].width的bug，不能超过Z，26个长度

for field in range(1, len(fields)+1):# 写入表头内容sheet.cell(row=1, column=field, value=fields[field-1])sheet.cell(row=1, column=field).font=ftdatas=[]for row_data in rs: # add table rowsdatas.append(row_d

回到未来望过去

1378人浏览 · 2021-09-24 23:11:45

回到未来望过去 · 2021-09-24 23:11:45 发布

for field in range(1, len(fields)+1):  # 写入表头内容
        sheet.cell(row=1, column=field, value=fields[field-1])
        sheet.cell(row=1, column=field).font=ft


datas=[]
for row_data in rs: # add table rows
        datas.append(row_data)

for row_data in range(2, len(datas)+2):  # 写入表数据，注意index变化
    for col_data in range(1, min(150,len(datas[row_data-2])+1)):
        sheet.cell(row=row_data, column=col_data, value=datas[row_data-2][col_data-1])
        sheet.cell(row=row_data, column=col_data).font=ft

# sheet.column_dimensions['E'].width = 100.0
#此处有bug不能超过26
for i in [chr(i) for i in range(65, 65+min(25,len(fields)+1))]:
    sheet.column_dimensions[i].width = 15.0

否则提示 Openpyxl [ is not a valid column name