When invoking the LoadFromStream(Stream stream) method on the Workbook class, providing a valid FileStream object, we are getting the following exception:
- Code: Select all
Message "Index was outside the bounds of the array."
Source "Spire.XLS"
StackTrace " at Spire.Xls.Core.Spreadsheet.XlsWorksheet.0(spr1920 A_0, Boolean A_1)\r\n at spr2247.0(XmlReader A_0, XlsWorksheet A_1, List`1 A_2)\r\n at spr2247.1(XmlReader A_0, XlsWorksheet A_1, List`1 A_2)\r\n at spr2247.0(XmlReader A_0, XlsWorksheet A_1, Stream A_2, List`1 A_3)\r\n at spr2247.0(XmlReader A_0, XlsWorksheet A_1, String A_2, MemoryStream& A_3, MemoryStream& A_4, List`1 A_5, Dictionary`2 A_6, Dictionary`2 A_7)\r\n at spr7284.1(XlsWorksheet A_0, Dictionary`2 A_1)\r\n at Spire.Xls.Core.Spreadsheet.XlsWorksheet.ParseData(Dictionary`2 dictUpdatedSSTIndexes)\r\n at spr2247.0(Dictionary`2 A_0)\r\n at spr7487.0(List`1& A_0)\r\n at spr7487.1(List`1& A_0)\r\n at Spire.Xls.Core.Spreadsheet.XlsWorkbook.0(Stream A_0, String A_1)\r\n at Spire.Xls.Core.Spreadsheet.XlsWorkbook.0(Stream A_0, String A_1, ExcelVersion A_2, ExcelParseOptions A_3)\r\n at Spire.Xls.Core.Spreadsheet.XlsWorkbook..ctor(spr1584 A_0, Object A_1, Stream A_2, ExcelParseOptions A_3, ExcelVersion A_4)\r\n at spr468.0(Object A_0, Stream A_1, ExcelVersion A_2, ExcelParseOptions A_3)\r\n at spr4726.0(Object A_0, Stream A_1, ExcelVersion A_2, ExcelParseOptions A_3)\r\n at spr6962.0(Stream A_0, ExcelVersion A_1, ExcelParseOptions A_2)\r\n at spr6962.0(Stream A_0, ExcelVersion A_1)\r\n at spr6962.0(Stream A_0)\r\n at Spire.Xls.Workbook.LoadFromStream(Stream stream)\r\n ..."
The FileStream points to an XLSX file with 5 sheets.
Sheet 1: 568245 cells over 32679 rows.
Sheet 2: 1342771 cells over 169008 rows.
Sheet 3: 1376556 cells over 169008 rows.
Sheet 4: 1346886 cells over 169008 rows.
Sheet 5: 1346581 cells over 169008 rows.
Spire.XLS.dll version is 7.5.20.4040
Please advise what the issue is, and if there's certain limitation to the size of the spreadsheet that can be processed through the LoadFromStream method (and if so, how is that limit quantified)?
Thanks,
Will