controlling Excel2000 with COM
Hirsch, John
JohnH at PHM.GOV.AU
Sun Apr 2 21:38:07 EDT 2000
Christer Fernstrom wrote:
I tried the most obvious thing with COM with Excel 20000 in Windows
2000 (p.
67 in "Programming on 32")
>> import win32com.client
>> xl = win32com.client.Dispatch("Excel.Application")
-- This launches Excel (as verified with the windows task manager)
>> xl.visible =1 (I also tried to capitalise Visible)
Result:
Traceback (innermost last):
File "<pyshell#2>", line 1, in ?
xl.visible =1
File "D:\tools\Python\win32com\client\dynamic.py", line 453, in
__setattr__
raise AttributeError, "Property '%s.%s' can not be set." %
(self._username_, attr)
AttributeError: Property 'Excel.Application.visible' can not be set.
Anybody got a clue? Is this a problem related to Office2000?
christer
____________________________________________________________________________
______________
This works for me.
>>> import win32com.client
>>> xl = win32com.client.Dispatch("Excel.Application")
>>> xl.Visible = 1
Must be capital 'V'.
john
More information about the Python-list
mailing list