将excel电子表格中的单元格范围保存为python中的图像

pip install openpyxl
pip install pillow

from openpyxl import load_workbook

# 打开Excel文件
workbook = load_workbook('example.xlsx')

# 选择要保存为图像的单元格范围
worksheet = workbook['Sheet1']
cell_range = worksheet['A1:B10']

from openpyxl.drawing.image import Image
from openpyxl.utils import get_column_letter
from PIL import Image as PILImage, ImageDraw

# 获取单元格范围的宽度和高度
width = sum(worksheet.column_dimensions[get_column_letter(col)].width for col in range(cell_range.min_column, cell_range.max_column + 1))
height = sum(worksheet.row_dimensions[row].height for row in range(cell_range.min_row, cell_range.max_row + 1))

# 创建图像对象
image = PILImage.new('RGB', (width, height), 'white')
draw = ImageDraw.Draw(image)

# 将单元格范围绘制到图像上
for row in range(cell_range.min_row, cell_range.max_row + 1):
    for col in range(cell_range.min_column, cell_range.max_column + 1):
        cell = worksheet.cell(row=row, column=col)
        draw.text(((col - cell_range.min_column) * cell.width, (row - cell_range.min_row) * cell.height), str(cell.value))

# 保存图像
image.save('output.png')