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

Reply via email to