python复制excel图片,从Excel复制图像并使用python保存

I am trying to copy an image from an excel named Inputs_v3 and sheet named Inputs and save. The code is as follows`

import win32com.client as win32

from PIL import ImageGrab

from xlrd import open_workbook

import os

excel = win32.gencache.EnsureDispatch("Excel.Application")

wb = open_workbook('Inputs_v3.xlsm')

r = wb.sheet_by_name('Inputs')

r.CopyPicture()

im = ImageGrab.grabclipboard()

im.save('somefile.png','PNG')

` The error is as follows

'Attribute error: 'Sheet' object has no attribute 'CopyPicture''

Please suggest where I am doing wrong.Thanks in advance

解决方案

Use a python library called excel2img. In one line you can take a screenshot from any excel file

import excel2img

excel2img.export_img("Excel File Full Path", "Target Image full Path", "Excel SheetName", None)

and you can identify a specific cells range as well.

import excel2img

excel2img.export_img("test.xlsx", "test.bmp", "", "Sheet2!B2:C15")

I hope this will help.