I receive the following stack trace the second time I try to render a image of any XLSX file:
System.NullReferenceException: Object reference not set to and instance of an object.
at spr955.1(XlsWorksheet A_0, Dictionary'2 A_1)
at Spire.Xls.Core.Spreadsheet.XlsWorksheet.ParseData(Dictionary'2 dictUpdatedSSTIndexes)
at Spire.Xls.Core.Spreadsheet.XlsWorksheet.10()
at Spire.Xls.Core.Spreadsheet.XlsWorksheet.ClearAll()
at Spire.Xls.Core.Spreadsheet.XlsWorksheet.DisposeAll()
at Spire.Xls.Core.Spreadsheet.XlsWorksheet.Close(Boolean SaveChanges, String Filename)
at Spire.Xls.Core.Spreadsheet.XlsWorksheet.Finalize()
This will only occur after trying to render the attached file first. Any other XLSX file that I try to render after will cause this error to be throw.
The code being used to Render the image is as follows:
- Code: Select all
Workbook workbook = new Workbook();
workbook.LoadFromStream(content);
Worksheet sheet = workbook.Worksheets[0];
var usedRange = sheet.Range;
return sheet.ToImage(usedRange.Row, usedRange.Column, usedRange.LastRow, usedRange.LastColumn);
please note the above code is within a try/catch
I have also tried wrapping this is a using block and manually disposing neither have had any affect.
Hope to here from you soon
Thanks
James