excel截图

代码

import openpyxl
import win32com.client as win32
from PIL import ImageGrab


def exccel(excelname,pngname):
    excel = win32.Dispatch('Excel.Application')
    wb = excel.Workbooks.Open(excelname)
    ws = wb.WorkSheets('Sheet1')
    ws.Range("A1:D5").CopyPicture()
    ws.Paste(ws.Range('K1'))  # 变成图片
    ws.Shapes(ws.Shapes.Count).Copy()  # 图片至剪贴板
    img = ImageGrab.grabclipboard()
    img.save(pngname)
    wb.Save()
    wb.Close()
    wb = openpyxl.load_workbook(excelname)
    ws = wb.active
    ws['K1'].value = ''
    print(wb['Sheet1']._images)
    wb.save(excelname)


if __name__ == "__main__":
    excelname=r"D:\2.xlsx"
    pngname=r"D:\2.png"
    exccel(excelname, pngname)

运行结果：

excel:

转换后图片：