python如何实现excel新表全部行高列宽设置，非常感谢

python如何实现excel新表全部行高列宽设置

在openpyxl中使用 row_dimensions 和 column_dimensions来控制行高和列宽。

import openpyxl
wb = openpyxl.Workbook()
sheet = wb.active
sheet.cell(row = 1, column = 1).value = 'hi'  
sheet.cell(row = 2, column = 2).value = 'python'
# 设置行高
sheet.row_dimensions[1].height = 70
# 设置列宽
sheet.column_dimensions['B'].width = 20
wb.save('dimension.xlsx')

参考下述链接文章：
https://blog.csdn.net/weixin_35757704/article/details/116297749?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522164179152716780271939925%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fall.%2522%257D&request_id=164179152716780271939925&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v1~rank_v31_ecpm-2-116297749.first_rank_v2_pc_rank_v29&utm_term=python%E8%AE%BE%E7%BD%AEexcel%E7%9A%84%E8%A1%8C%E9%AB%98%E5%88%97%E5%AE%BD&spm=1018.2226.3001.4187

我一般的做法是。。
设计表格靠excel，填充数据靠python