We use version 7.11.49 and got some troubles with loading an XLSX file (see in attachments).
- Code: Select all
using (FileStream fileStream = File.OpenRead(@"C:\Users\Downloads\test.xlsx"))
{
var _workbook = new Workbook();
try
{
_workbook.LoadFromStream(fileStream, ExcelVersion.Version2010);
}
catch (Exception ex)
{
_workbook = null;
}
}
When the file is loading to the workbook we catch an exception "Value was either too large or too small for an unsigned byte." but then after some time the application crashes with null reference exception
at spr626.1(XlsWorksheet A_0, Dictionary`2 A_1)
at Spire.Xls.Core.Spreadsheet.XlsWorksheet.ParseData(Dictionary`2 dictUpdatedSSTIndexes)
at Spire.Xls.Core.Spreadsheet.XlsWorksheetBase.ParseData()
at Spire.Xls.Core.Spreadsheet.XlsWorksheet.40()
at Spire.Xls.Core.Spreadsheet.XlsWorkbook.ClearAll()
at Spire.Xls.Core.Spreadsheet.XlsWorkbook.DisposeAll()
at Spire.Xls.Core.Spreadsheet.XlsWorkbook.Close(Boolean SaveChanges, String Filename)
at Spire.Xls.Core.Spreadsheet.XlsWorkbook.Close(Boolean saveChanges)
at Spire.Xls.Core.Spreadsheet.XlsWorkbook.Close()
at Spire.Xls.Core.Spreadsheet.XlsWorkbook.Finalize()
There are 2 solutions how to avoid this: 1) upgrade to the latest version 2) open file and save it again
Could you tell me what the problem with the file?