Dear Spire,
I am looping a list of saved excel files and it's terminate with ambiguous error when trying to load a file (not first one), I would like to know how to get actual error it hits when it trying to load that file.
Workbook sworkbook = sworkbook.LoadFromFile(tmpfilepath);
And the error I get as below:
Exception.Message : Value should be greater than zero and less than count of worksheets.
Parameter name: DisplayedTab
Exception.StackTrace : at Spire.Xls.Core.Spreadsheet.XlsWorkbook.set_DisplayedTab(Int32 value)
at spr᠁.ᜀ(XmlReader A_0, RelationsCollection A_1, spr៏ A_2, String A_3, Stream A_4, Stream A_5, List`1& A_6, Stream A_7)
at spr៏.ᜀ(List`1& A_0)
at spr៏.ᜁ(List`1& A_0)
at Spire.Xls.Core.Spreadsheet.XlsWorkbook.ᜀ(Stream A_0, String A_1)
at Spire.Xls.Core.Spreadsheet.XlsWorkbook.ᜀ(Stream A_0, String A_1, ExcelVersion A_2, ExcelParseOptions A_3)
at Spire.Xls.Core.Spreadsheet.XlsWorkbook.ᜀ(String A_0, String A_1, ExcelVersion A_2, ExcelParseOptions A_3)
at Spire.Xls.Core.Spreadsheet.XlsWorkbook..ctor(sprជ A_0, Object A_1, String A_2, ExcelParseOptions A_3, Boolean A_4, String A_5, ExcelVersion A_6)
at spr឴.ᜀ(Object A_0, String A_1, ExcelParseOptions A_2, Boolean A_3, String A_4, ExcelVersion A_5)
at spr.ᜀ(String A_0, ExcelParseOptions A_1, Boolean A_2, String A_3, ExcelVersion A_4)
at Spire.Xls.Workbook.LoadFromFile(String fileName, ExcelVersion version)...
Additional Info:
The Spire version I am working with is 8.10.2.6035
The excel file to be loaded was saved using workbook.SaveToFile(fullpath, ExcelVersion.Version2016); (and I can view the file using Ms Excel)
Best Regards,
Shyan