[python-win32] Problem with COM and MsExcel

Brunain Christophe Christophe.Brunain@health.fgov.be
Wed, 2 Apr 2003 08:46:03 +0200

Hello all !

I begin tu use python win and the COM features

I try to do a little scripyt that takes a text file (an unload from a
database) and to put it in an excel worksheet

It works good, but only one time

the second time I execute the script, i only se the menubar and the =
on the top of the screen, the document itself is not displaying

I see only what was my screen before the execution of the script

If i close all the excel sheets and look in the task manager, I see an
EXCEL.EXE still running

If i make an "end process" it works, but if i try to run the script =
again, it makes an error.

here is the script i use

import win32com.client

ex =3D win32com.client.Dispatch("Excel.Application")
ex.Visible =3D 1
ex.Run("SaveText","C:\\test\\codes", "C:\\test\\codes2.xls")

and the traceback i got when i close the excel.exe and run the script =

PythonWin 2.2.2 (#37, Oct 14 2002, 17:02:34) [MSC 32 bit (Intel)] on =
Portions Copyright 1994-2001 Mark Hammond (mhammond@skippinet.com.au) - =
'Help/About PythonWin' for further copyright information.
Traceback (most recent call last):
line 307, in RunScript
    debugger.run(codeObject, __main__.__dict__, start_stepping=3D0)
  File =
line 60, in run
    _GetCurrentDebugger().run(cmd, globals,locals, start_stepping)
  File =
line 591, in run
    exec cmd in globals, locals
  File "C:\test\test1.py", line 4, in ?
    ex.Visible =3D 1
  File "C:\Python22\lib\site-packages\win32com\client\dynamic.py", line =
in __setattr__
    raise AttributeError, "Property '%s.%s' can not be set." %
(self._username_, attr)
AttributeError: Property 'Excel.Application.Visible' can not be set.

Does someone know what's wrong ?
i've looked in the archives of this mailing list but i haven't found :(

Thanks a lot for your answers

PS :
Sorry if my english is not so good

Brunain Christophe
Service informatique de l'expertise m=E9dicale
SPF Sant=E9 Publique, S=E9curit=E9 de la chaine alimentaire et =