python openpyxl列宽自适应

发表于 | 分类于 | | 阅读次数: | 字数统计: 84

使用此命令可以设置列宽：

1
worksheet.column_dimensions['A'].width = 25

则A列的宽度为25

1
2
3
4
5
6
7
8
9
10
11
column_widths = []
for row in data:
    for i, cell in enumerate(row):
        if len(column_widths) > i:
            if len(cell) > column_widths[i]:
                column_widths[i] = len(cell)
        else:
            column_widths += [len(cell)]

for i, column_width in enumerate(column_widths):
    worksheet.column_dimensions[get_column_letter(i+1)].width = column_width

来源： Python openpyxl column width size adjust