Openpyxl 修改单元格长宽

已知单元格所在行列

from openpyxl.worksheet.dimensions import ColumnDimension, DimensionHolder
from openpyxl.utils import get_column_letter
from openpyxl import Workbook
from openpyxl import load_workbook

file_name = "file_path" #file_path为读取execl文件数据
source_workbook = load_workbook(file_name)
sheet = source_workbook.active # 默认取第一个sheet
# 其中x,y为具体行列数
cell = sheet.cell(x,y)
# cell.column获取当前单元格的列
# get_column_letter(cell.column)根据列索引转换成列标题，example 3->C
sheet.column_dimensions[get_column_letter(cell.column)].width = 30.0
sheet.row_dimensions[cell.row].height = 40
sheet.save(file_name)

根据单元格内容确定坐标后，修改行宽

from openpyxl.worksheet.dimensions import ColumnDimension, DimensionHolder
from openpyxl.utils import get_column_letter

file_name = "file_path" #file_path为读取execl文件数据
source_workbook = load_workbook(file_name)
sheet = source_workbook.active # 默认取第一个sheet


def get_cell_by_value(value):
    """遍历所有单元格，根据单元格的值找到其位置"""
    for row in range(1, sheet.max_row):
    	for col in range(1, sheet.max_column):
	        if sheet.cell(row = row, column = col).value == value:
	            return row, column
	            
# 找到单元格内容为aaaa的坐标
row, column = get_cell_by_value("aaaa")
sheet.column_dimensions[get_column_letter(column)].width = 30.0
sheet.row_dimensions[row].height = 40
sheet.save(file_name)