Copy Image from Excel and Save it using python

Question

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

You're mixing up win32com calls with the xlrd package, which have nothing to do with each other. You've set excel to be a reference to the Excel app but then you don't do anything with it. I'm not fully familiar with either xlrd or the Excel COM model but it looks as if CopyPicture is a method you need to call on the Excel worksheet object, not the xlrd sheet_by_name object. If you can get the picture using xlrd do that and don't use COM, otherwise use COM and you don't need xlrd. — nekomatic
– nekomatic, Commented May 12, 2016 at 7:54
Hi..I have tried to open the work book using win32.com by excel = win32.gencache.EnsureDispatch("Excel.Application") wb = excel.Workbooks.Open("Inputs_v3.xlsm")...but it is showing that we couldn't find the file — Goutham Pathuri
– Goutham Pathuri, Commented May 12, 2016 at 9:29
Sounds like it couldn't find the file then ;-) Try giving it a full path name. — nekomatic
– nekomatic, Commented May 12, 2016 at 9:39

Agnel Vishal · Accepted Answer · 2019-08-16 05:00:43Z

6

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.

edited Aug 16, 2019 at 5:00

Agnel Vishal

5806 silver badges13 bronze badges

answered Nov 21, 2018 at 23:06

user2301624

611 silver badge1 bronze badge

Sign up to request clarification or add additional context in comments.

1 Comment

MyStackRunnethOver Over a year ago

While this may solve OP's problem, it would help to explain why OP should use this library instead of their current approach

nekomatic · Accepted Answer · 2016-05-13 13:12:45Z

2

The following code will get you the win32com reference that you actually need to access the Excel worksheet's objects and methods:

import win32com.client as win32
excel = win32.gencache.EnsureDispatch('Excel.Application')
wb = excel.Workbooks.Open('myworkbook.xlsx')
ws = wb.Worksheets('worksheet_name')         # alternatively Worksheets(1) etc

Now you can do, for example:

ws.Shapes(1).CopyPicture()

I've tested this with Python 3.4, pywin32 219 and Excel 2010 on Windows 7.

Note that this doesn't involve xlrd at all - that's a package that can read Excel files without having Excel installed on the computer, but I don't know if it supports getting images of or from Excel workbooks.

edited May 13, 2016 at 13:12

answered May 12, 2016 at 9:38

nekomatic

6,2841 gold badge23 silver badges27 bronze badges

3 Comments

Goutham Pathuri Over a year ago

Thanks.. I need to get a particular picture on the worksheet. According to your code(range) it is taking image of entire screen in the range and in the code it is giving the error: 'Nonetype object has no attribute save' . I guess the code is not detecting the image on the clipboard.But image is getting copied on the clipboard. Can you suggest any solution for this problem?

nekomatic Over a year ago

See edited answer to copy picture, rather than image of worksheet. I don't know PIL and can't test it as I don't have Python 2.x installed - I suggest you do some more research and experimentation on that and if you don't get anywhere, ask a new question specifically about that.

nekomatic Over a year ago

stackoverflow.com/questions/17282278/… might be relevant?

Collectives™ on Stack Overflow

Copy Image from Excel and Save it using python

2 Answers 2

1 Comment

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related