[python-win32] exception while opening excel file

[iceblink at chello.nl]

---- Mark Hammond <mhammond at skippinet.com.au> schreef:
> > > Normally I can just press "close" in the excel error box, and
> > continue
> > > to work on the file. But how do I handle this in py-win32?
> > 
> > So what happens when you try to open it normally?
> 
> Oops - sorry - I see you already gave the exception you get trying to open
> the file.  I'm afraid I don't know the answer though.
> 

In answer to my own question, the following code seems to work:

xlApp = Dispatch("Excel.Application")
wb1=xlApp.Workbooks.Open(inputfile,ReadOnly=1,CorruptLoad=1)
xlApp.SendKeys("{Enter}",Wait=1)
xlApp.DisplayAlerts = 0
xlApp.Quit()
del xlApp

The trick was to find the right CorruptLoad statement and corresponding number for "xlRepairFile".

The DisplayAlerts is needed to prevent Excel from asking if it should save a file that was opened as ReadOnly in the first place... hmmmm.

Best regards,

Patrick Asselman