Picture in Excel issue

[Steve Holden]

Jim Chiang wrote:
> 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
> 
>  
> 
I suspect that Pictures is a function that returns a collection - try

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

Remember that VBA uses implied function calls, you have to be explicit 
in Python.

regards
  Steve
-- 
Steve Holden       +44 150 684 7255  +1 800 494 3119
Holden Web LLC/Ltd          http://www.holdenweb.com
Skype: holdenweb       http://holdenweb.blogspot.com
Recent Ramblings     http://del.icio.us/steve.holden