File Not Found after deleting a worksheet

[siddhant2408]

test3.xlsx

Say, if we have a workbook with 3 worksheets and sheet1 is deleted, we start getting an error when opening the file using the Open method:

open file: File not found: xl/worksheets/sheet7.xml

Can we not skip the sheets ids that are not associated with a worksheet?

[dglsparsons]

I think it's to do with extracting the contents of the excel workbook (unzipping them). Obviously the file contents hold a reference to a sheet that no longer exists, i guess the correct behaviour is for this to be gracefully handled by ignoring the error if the file is not present.

I'll have a look.