Click here to Skip to main content
14,635,966 members
Rate this:
Please Sign up or sign in to vote.
See more:
Hello everyone,
I have a web form and i try to fill that form reading data from an excel file.
I have used this example to retrieve data from the excel document.

Upload And Read Excel File In Asp.Net

Everything was fine, but i have some empty cells in excel with only a pattern applied to the cell. Is there a way to read and count those empty cells with a pattern ?
I need to count them to see how many cells with pattern are in a specific row.
Posted
Comments
Kenneth Haugland 3-Aug-12 14:36pm
   
MAby you'll have to call .Forula or .Format on the cells instead of .Value, but I dont know how to do that in a OleDb connection .....

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100