I want to read the data from multiple rows and columns in excel using C#

Posted by Prashant6252 under DotNetFunda.Com on 2/5/2015 | Points: 10 | Views : 2464 | Status : [Member] | Replies : 0
Hi All,

I want to write a function, that reads values from multiple rows and columns from excel using C#. Assuming there is only one worksheet in the excel. In the later point of time, if i add any more sheets in the workbook, i can easily easily give reference to that sheet and access the data as well.

In attached excel, I want to check for the condition using state as parameter, If state matches with stat1, i want to read the values for that row Ex: If stat1 == stat1, then i want to read values as stat1, Office1, Und1, A1, City1 nd Count1 and store it in Variable.

Will be waiting for the reply.
Thanks in Advance !!


(No response found.)

Login to post response