from openpyxl import load_workbook
from openpyxl.styles import Color,Font,Alignment,PatternFill,Border,Side,Protection
#将列数转成列名对应单元格
def num2column(num):
interval = ord('Z') - ord('A')
tmp = ''
multiple = num // interval
remainder = num % interval
while multiple > 0:
if multiple > 25:
tmp += 'A'
else:
tmp += chr(64 + multiple)
multiple = multiple // interval
tmp += chr(64 + remainder)
return tmp
# 对Excel格式进行设置
def func_openpyxl_modify_excel(out_file, df_list, No_list):
wb = load_workbook(out_file)
ws_list = wb.sheetnames
border = Border(left=Side(style='thin', color='FF000000'),
right=Side(style='thin', color='FF000000'),
top=Side(style='thin', color='
python + openpyxl 输出Excel单元格大小自适应和填充
最新推荐文章于 2024-07-14 10:01:30 发布
本文介绍了如何使用Python的openpyxl库来创建Excel文件,并自动调整单元格的大小以适应内容,确保数据完整展示。
摘要由CSDN通过智能技术生成