Python and Excel

Post #104,158 by ChrisR 5/30/03 4:41:10 PM Reply	Python and Excel The calls to the Win32 COM APIs are causing me some grief in a Python script of mine. The script is intended to convert text into numbers (this reason they got that way is another story). The script below works fine with the excption that the Excel process does not really Quit. Instead, Excel is left open as a process, and I have to load up Excel with the file in question and do a manual save. Anyone know why the Python script doesn't want to close the Excel process? #!/usr/local/bin/python\nimport sys\nimport win32com.client\n\ndef excelFixNum(filename):\n xlapp = win32com.client.Dispatch('Excel.Application')\n xlbook = xlapp.Workbooks.Open(filename)\n\n for wsi in range(1, xlbook.Worksheets.Count+1):\n xlsheet = xlbook.Worksheets(wsi)\n row = 3\n column = 2\n while (xlsheet.Cells(row,column).Value is not None):\n while (xlsheet.Cells(row,column).Value is not None):\n xlsheet.Cells(row,column).Value = float(xlsheet.Cells(row,column).Value)\n column = column + 1\n row = row + 1\n column = 2\n del(xlsheet)\n\n xlbook.Save\n xlbook.Close\n xlapp.Quit\n del(xlbook)\n del(xlapp)\n\nexcelFixNum("myfile.xls")
Post #104,174 by tseliot 5/30/03 5:34:30 PM Reply	Best guess: there's a dialog box waiting for user input Check around in the methods for a quieter shutdown operation. I have this issue with Office apps all the time; as Microsoft themselves are fond of saying in several KB articles, Office was never intended for multi-user (i.e. remote, unattended = programmatic) functionality. Many fears are born of stupidity and ignorance - Which you should be feeding with rumour and generalisation. BOfH, 2002 "Episode" 10
Post #104,200 by ChrisR 5/30/03 8:18:48 PM Reply	I thought the DisplayAlerts property might be it But I can't see much difference. IIRC, that property needed to be hit in VB to keep it out of interactive mode. I'm trying xlapp.DisplayAlerts = 0 The Save method doesn't seem to have any way to tweak it. I guess I'll try the SaveAs method and see if it does any better.
Post #144,042 by FuManChu 3/1/04 5:11:28 PM Reply	Like this one: [link\|http://support.microsoft.com/default.aspx?scid=kb;en-us;Q257757\|http://support.micro...=kb;en-us;Q257757]
Post #104,196 by mmoffitt 5/30/03 7:39:18 PM Reply	Dunno if this applies, but... when I've encountered XL not shutting down properly, sometimes it is because an implicit object pointer that has been created by the running instance of XL is not set to nothing (the app will only close once all pointers are set to nothing). bcnu, Mikem The soul and substance of what customarily ranks as patriotism is moral cowardice and always has been...We have thrown away the most valuable asset we had-- the individual's right to oppose both flag and country when he (just he, by himself) believed them to be in the wrong. We have thrown it away; and with it all that was really respectable about that grotesque and laughable word, Patriotism. - Mark Twain, "Monarchical and Republican Patriotism"
Post #104,201 by ChrisR 5/30/03 8:20:34 PM Reply	del(obj) should do the same in Python But it's possible that the Garbage Collector never calls the destructor before it exits the script. Tried calling the GC manually, but it didn't make much difference.
Post #104,212 by mmoffitt 5/30/03 10:29:45 PM Reply	Sorry. XL automation is a nightmare in general. Good luck. bcnu, Mikem The soul and substance of what customarily ranks as patriotism is moral cowardice and always has been...We have thrown away the most valuable asset we had-- the individual's right to oppose both flag and country when he (just he, by himself) believed them to be in the wrong. We have thrown it away; and with it all that was really respectable about that grotesque and laughable word, Patriotism. - Mark Twain, "Monarchical and Republican Patriotism"
Post #105,416 by mmoffitt 6/9/03 5:11:48 PM Reply	Did you get this fixed? If not,... you might try setting the "DisplayAlerts" property to false. I'm having a similar problem with Powerpoint right now. I'm trying to PostMessage WM_CLOSE and it won't work because I have a modal dialog. This doesn't happen w/XL when the DisplayAlerts property is set to true and so far I've been unable to find a way w/Powerpoint to turn the damned Alerts off! (you can't close an MS office app w/a modal dialog displayed - even if the modal dialog is not visible). hth. bcnu, Mikem The soul and substance of what customarily ranks as patriotism is moral cowardice and always has been...We have thrown away the most valuable asset we had-- the individual's right to oppose both flag and country when he (just he, by himself) believed them to be in the wrong. We have thrown it away; and with it all that was really respectable about that grotesque and laughable word, Patriotism. - Mark Twain, "Monarchical and Republican Patriotism"
Post #105,422 by ChrisR 6/9/03 5:18:02 PM Reply	DisplayAlerts actually made it worse... ...because when it didn't close the files down successfully (same as before), but it also didn't give me a choice when I load up the files manually whether I wanted to keep the changes. For now, I can modify the files and then open them up in Excel. I'm having to go in a manually change a few things that anyhow, so it's no time burner. Will try to fix it one of these days. Saw [link\|http://mail.python.org/pipermail/python-win32/2002-October/000528.html\|Someone Else] had a similar problem in Python.
Post #105,427 by mmoffitt 6/9/03 5:22:21 PM Reply	Ain't MS Office wonderful? I feel your pain, but I don't think it's a Python problem ;-) bcnu, Mikem The soul and substance of what customarily ranks as patriotism is moral cowardice and always has been...We have thrown away the most valuable asset we had-- the individual's right to oppose both flag and country when he (just he, by himself) believed them to be in the wrong. We have thrown it away; and with it all that was really respectable about that grotesque and laughable word, Patriotism. - Mark Twain, "Monarchical and Republican Patriotism"

Welcome to IWETHEY!