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 !!