Greetings,
I would appreciate any help I could get with the following problem. 30% of
the time after running the following code to get the sheet names out of an
excel file, I will receive a windows error saying that “Microsoft Office
Excel has stopped working”.
Code:
xl=win32com.client.DispatchEx("Excel.Application")
book=xl.Workbooks.Open(filename)
sheetList=[]
for sheet in book.Sheets:
sheetList.append(sheet.Name)
sheet=None # get rid of reference to sheet
try:
book.Close()
book=None
xl.Quit()
except:
print "getting sheet names exception!"
book=None
xl.Quit()
xl=None
return sheetList
The sheetList variable is returned fine, the print in the except statement
does not appear and the program can continue as normal, however the
following Windows error appears:
Microsoft Office Excel has stopped working
Windows can check online for a solution to the problem
->Check online for a solution and close the program
->Close the program
->Debug the program
Problem Details:
*Problem signature:*
Problem Event Name: APPCRASH
Application Name: EXCEL.EXE
Application Version: 12.0.6550.5004
Application Timestamp: 4d2cee93
Fault Module Name: ntdll.dll
Fault Module Version: 6.1.7601.17514
Fault Module Timestamp: 4ce7ba58
Exception Code: c0000005
Exception Offset: 00038da9
OS Version: 6.1.7601.2.1.0.256.1
Locale ID: 1033
*Additional information about the problem:*
LCID: 1033
Brand: Office12Crash
skulcid: 1033
While the program can continue as normal, to users using the program, having
this error popup and having to click “close the program” is not acceptable.
Can anyone help me with a reason as to why I get this error message (and
only sometimes at that) even though no exception is thrown and I retrieved
the sheet names perfectly fine? Is there a way to suppress this error from
even appearing (though not ideal and it is a windows error not an Excel
error so I don’t think this is possible)?
I thank you for any assistance.
Mark
_______________________________________________
python-win32 mailing list
python-win32@python.org
http://mail.python.org/mailman/listinfo/python-win32
