Number of rows with SpreadsheetLight

Question

I am looking for a function similar to DataTable.Rows.Count that can be used with SLDocument to find out how many rows contain data in them. Is there something in SpreadsheetLight? Any other ways to achieve this?

-Brendan

Answer 1

SLWorksheetStatistics stats1 = firstdoc.GetWorksheetStatistics();


for (int j = 1; j < stats1.EndRowIndex; j++)
{
    var value = firstdoc.GetCellValueAsString(0, j)  ;

}