Free Support Forum - aspose.com

Empty Cell Returned When Not Empty

Hi,

I am having an issue with the following Excel file using Aspose.Cells. When attempting to read any of the populated cells (ie. A1 - A16), I receive a null field returned. My code is something like the below:

Workbook wb = new Workbook();
wb.Open(fileLocation + fileName);
Cells c = wb.Worksheets[0].Cells;
int i = 1;

while (i <= c.MaxRow)
{
string s = cells[i,0].Value.ToString();
i++;
}

I can see that c.MaxRow has the correct number of rows listed however the value of the cell is constantly null. Are you able to look at the file and let me know if you receive a similar issue?

NOTE: The file is created through calling an SSRS web service

Thanks in advance.

Hi, <?xml:namespace prefix = u1 /><?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Thank you for sharing the template file.

Please try the attached latest version of Aspose.Cells. I checked your issue with the attached version and it works fine.

Thank You & Best Regards,