Count Number of none empty cells in Excel using C# in ASP.Net

Last Reply on May 06, 2016 09:39 AM By dharmendr

Posted on May 06, 2016 08:24 AM

I use OLEDB to connect and read the values from the Excel.

If you see on the 1st Column has 4 Values are given and rest are empty..
So I need the empty cell neglected and get the count of the values present.
Similarly for the next aswell.

Kindly help me on it.

You are viewing reply posted by: vygi0913 on May 06, 2016 08:45 AM.
Posted on May 06, 2016 08:45 AM

For the first row it should be 4 and for second row it is 5.

TC No is the for like S.NO so you can ignore it.