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.