[python-win32] RE:Problem with COM and MsExcel

[Tom]

Hi,
try add at end command ex = None. This will close
Excel object.

Tomas   

From: Brunain Christophe
<Christophe.Brunain@health.fgov.be>
To: "Pythonwin (E-mail)" <python-win32@python.org>
Date: Wed, 2 Apr 2003 08:46:03 +0200 
Subject: [python-win32] Problem with COM and MsExcel

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 =
toolbar
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 =
once
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.Workbooks.Open("C:\\test\\test.xls")
ex.Run("SaveText","C:\\test\\codes",
"C:\\test\\codes2.xls")
ex.Quit

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

PythonWin 2.2.2 (#37, Oct 14 2002, 17:02:34) [MSC 32
bit (Intel)] on =
win32.
Portions Copyright 1994-2001 Mark Hammond
(mhammond@skippinet.com.au) - 
=
see
'Help/About PythonWin' for further copyright
information.
Traceback (most recent call last):
  File
"C:\Python22\lib\site-packages\Pythonwin\pywin\framework\scriptutils.py"=
,
line 307, in RunScript
    debugger.run(codeObject, __main__.__dict__,
start_stepping=3D0)
  File =
"C:\Python22\lib\site-packages\Pythonwin\pywin\debugger\__init__.py",
line 60, in run
    _GetCurrentDebugger().run(cmd, globals,locals,
start_stepping)
  File =
"C:\Python22\lib\site-packages\Pythonwin\pywin\debugger\debugger.py",
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 
=
504,
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 =
Environnement



__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more
http://tax.yahoo.com