I’m trying to very simply insert a picture from a file into an excel spreadsheet. I know how to do this in VBA and it works fine, however when I try this from python I get an error. Doing a search on this turned up nothing.

The code I’m using is:

from win32com.client.dynamic import Dispatch

xl = Dispatch( 'Excel.Application' )

xl.Visible=1

xl.Workbooks.Add()

xl.ActiveSheet.Pictures.Insert("C:\a.jpg")

 

Traceback (most recent call last):

  File "<pyshell#7>", line 1, in <module>

    xl.ActiveSheet.Pictures.Insert("C:\a.jpg")

AttributeError: 'function' object has no attribute 'Insert'

 

I’m not sure why I get this issue since ‘ActiveSheet.Pictures.Insert("C:\a.jpg")’ works fine from within Excel. Several internet posts from my searches also suggest to use this method.

 

I’ve tried this on both Python 2.1 and 2.5 with the same results.

Any idea what the problem is or how I can insert the picture??

 

TIA,

Jim

 

-- 
http://mail.python.org/mailman/listinfo/python-list

Reply via email to