设置列宽 

    #设置列宽
        cell_width_list = [12, 8.5, 29, 12.5, 13, 10.5]
        # 列名
        column_names = ['A', 'B', 'C', 'D', 'E', 'F']

        count = 0
        for column_name in column_names:
            worksheet.column_dimensions[column_name].width = cell_width_list[count]
            count += 1

 

posted @ 2020-10-26 09:59  胸怀丶若谷  阅读(102)  评论(0)  编辑  收藏  举报