Problem: ExportArray exports an array with a null in a cell that has a value

Aspose.Cells Product Family
1

I say:

Cells cells = worksheet.Cells;
object[,] data = cells.ExportArray(1, 0, cells.MaxDataRow, cells.MaxDataColumn + 1);

I then loop through all the items in this array, and for one particular cell, the value is null. If I look at this spreadsheet in Excel, there is a string “SEDOL” in that cell. This is on the last row of the spreadsheet.

Any idea why this might be happening? Other information I could provide?

2

Could you please post your file here? And which version of Aspose.Cells are you using?