I have a excel file. when i try to count the rows number, its return 1 more than the original one.
I have checked the file several times but there is only 10 rows. but its return 11.
Here is the sample code:
Worksheet worksheet = workbook.Worksheets;
int rowCount = worksheet.Cells.Rows.Count ;
Is it possible to count a blank row? Whats the problem?
Plz help me out.
Thanks in advanced