Is there a way to read whether a row has data (ignoring fact that styling exists on the row)?

Aspose.Cells Product Family
1

My program is reading data from a worksheet, row by row. In the vast majority of cases, Excel validation and/or styling is "embedded" in one or more cells in the row.

Is there a way to determine whether a row has data (ignoring fact that styling exists on the row)? I am using Aspose.Excel 3.6.2.1.

I am desperately looking for work-arounds as I approach a deadline. Thanks.

2

I would use the following logic this may or may not work for you (this is ad-hoc and not tested):

private bool RowHasData(Worksheet worksheet, int rowIndex)

{

if (worksheet.Cells.Start == null)// This is for the first row only

return false;

else

if (rowIndex > worksheet.Cells.MaxDataRow)

return false;

else

return true;

}

3

I don’t know how I missed the MaxDataRow method! Thanks for pointing it out to me. It works. Smile [:)]