导入所需要的模块

import os import sys import time import win32com.client from PIL import ImageGrab

def excel_to_image(file_path, sheet_name, image_path): """ 将Excel表格转换为图片 :param file_path: Excel文件路径 :param sheet_name: Excel表格名称 :param image_path: 图片保存路径 :return: """ # 打开Excel应用程序，创建一个工作簿对象 excel = win32com.client.Dispatch("Excel.Application") excel.Visible = False excel.DisplayAlerts = False workbook = excel.Workbooks.Open(file_path)

# 获取要操作的工作表对象
worksheet = workbook.Sheets(sheet_name)

try:
    # 获取工作表的可见范围
    left = worksheet.Cells(1, 1).Left
    top = worksheet.Cells(1, 1).Top
    right = worksheet.Cells(1, 1).Width * worksheet.Columns.Count
    bottom = worksheet.Cells(1, 1).Height * worksheet.Rows.Count

    # 使用PIL的ImageGrab模块截取工作表的图片
    image = ImageGrab.grab((left, top, right, bottom))

    # 将图片保存到指定路径
    image.save(image_path)

except Exception as e:
    print("Error:", e)

finally:
    # 关闭工作簿和Excel应用程序
    workbook.Close(SaveChanges=False)
    excel.Quit()

if name == 'main': # 获取要转换的Excel文件路径、表格名称和图片保存路径 file_path = "/path/to/excel_file.xlsx" sheet_name = "Sheet1" image_path = "/path/to/image.png"

# 调用函数进行转换
excel_to_image(file_path, sheet_name, image_path)

print("Excel转换为图片成功！")