import pandas as pd
from openpyxl import load_workbook
from openpyxl.utils import get_column_letter
from openpyxl.styles import Font, Alignment
# 自动设置excel列宽
def auto_width(filename='合并.xlsx'):
# 打开xlsx文件
wb = load_workbook(filename)
# 遍历sheet
for sheet in wb.sheetnames:
ws =<
python openpyxl 自动设置excel列宽及行高,单元格对对齐方式
最新推荐文章于 2024-07-20 17:12:48 发布