how to count rows in excel

Posted by Oswaldlily under ASP.NET on 9/26/2011 | Points: 10 | Views : 3145 | Status : [Member] | Replies : 2
How to count no of rows in excel(rows which contain data alone)..


* no need to count blank rows




Responses

Posted by: CS1401 on: 9/27/2011 [Member] Starter | Points: 25

Up
0
Down
http://www.contextures.com/xlfunctions04.html
refer this link.

...

Oswaldlily, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: T.saravanan on: 9/27/2011 [Member] [MVP] Silver | Points: 25

Up
0
Down
Hi,

Just read the excel file into dataset then easily to find out the row count.

For your reference....http://www.dotnetfunda.com/codes/code972-read-a-excel-file-with-sheet-wise-into-dataset-using-csharp.aspx

Incase dataset read empty row means just remove the row from dataset then count no.of rows.

Thanks,
T.Saravanan

Oswaldlily, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response