Python使用OpenPyXl设置Excel表格中的单元格大小（行高和列宽）

小鱼儿 2022-12-01 05:25 2676阅读 0赞

### 文章目录 ###

*  1. 按
 *  2. 设置单行和一列的长和宽
 *  3. 设置所有行和全部列的长和宽

# 1. 按 #

本文主要讨论 openpyxl如何设置（调整）单元格大小（行高和列宽），其他功能可参考：[Python3 进行读取、修改和写Excel表格(.xlsx文件)的常用功能示例][Python3 _Excel_.xlsx]

# 2. 设置单行和一列的长和宽 #

from openpyxl import load_workbook
     
    wb = load_workbook('test.xlsx')
    print(wb.sheetnames)
    ws = wb[wb.sheetnames[0]]
     
    # 调整列宽
    ws.column_dimensions['A'].width = 20.0
     
    # 调整行高
    ws.row_dimensions[1].height = 40
     
    wb.save('test.xlsx')

结果：  
运行前：  
![20181128191813403.png][]  
运行后：  
![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NPQ081Ng_size_16_color_FFFFFF_t_70][]

# 3. 设置所有行和全部列的长和宽 #

from openpyxl import load_workbook
    from openpyxl.utils import get_column_letter
    
    
    wb = load_workbook('test.xlsx')
    print(wb.sheetnames)
    ws = wb[wb.sheetnames[0]]
    
    width = 2.0
    height = width * (2.2862 / 0.3612)
    
    print("row:", ws.max_row, "column:", ws.max_column)
    for i in range(1, ws.max_row+1):
        ws.row_dimensions[i].height = height
    for i in range(1, ws.max_column+1):
        ws.column_dimensions[get_column_letter(i)].width = width
    
    wb.save('test.xlsx')

[Python3 _Excel_.xlsx]: https://blog.csdn.net/COCO56/article/details/100041476
[20181128191813403.png]: /images/20221123/f10a93f54c7c4868a8c538155b3c0d3a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NPQ081Ng_size_16_color_FFFFFF_t_70]: /images/20221123/08351161fb4c421a96723ce272109d2a.png