how to count rows in excel

Posted by Oswaldlily under ASP.NET on 9/26/2011 | Points: 10 | Views : 3790 | Status : [Member] | Replies : 2

How to count no of rows in excel(rows which contain data alone)..

* no need to count blank rows

Reply | Reply with Attachment

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

0	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

0	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

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

Latest Posts