hi:
i have a worksheet like this:
a b c d
a1 c1 d1
this is a empty row.
b3 c3 d3
.....
i want to read the rows have data;
if i use while() i dont know how to check the last row.
is there a method to get the aviable rows count?
code error :int sheetRowCount = ((Infragistics.Excel.WorksheetItemCollection<Infragistics.Excel.WorksheetRow>)(worksheet.Rows)).Count;
Hello, Thanks for the above solution In my case I want to read used column count and following snippet is not working for that.int sheetColCount = (worksheet.Columns as ICollection<WorksheetColumn>).Count; is there a method for the same ?
I get it
int sheetRowCount = (worksheet.Rows as ICollection<WorksheetRow>).Count;