excel 自动行宽

def adaptive_cell(ws):
    col_width = []
    for i in range(len(next(ws.iter_rows()))):
        col_letter = get_column_letter(i + 1)
        minimum_width = 0
        current_width = ws.column_dimensions[col_letter].width
        if not current_width or current_width < minimum_width:
            ws.column_dimensions[col_letter].width = minimum_width
        col_width.append(ws.column_dimensions[col_letter].width)
posted @ 2022-05-23 18:24  青样儿  阅读(38)  评论(0)    收藏  举报