How do we check proper result in every column in excel data or data table using C#

[Gani tpt]

I have data in excel file or data table.

example data is below

Mark1 Mark2 Mark3 Mark4

------- -------- ------- ------

100 200 300 400

120 140 160 180

210 220 230 240

260 270 290 295


When i pass the parameter value like EmpMark => 220

So, EmpMark "220" should check in all the columns like mark1,mark2,mark3,mark4,....

if value found in the corresponding column then loop should terminate and identify the columns and rows of the value "220"

Final result would be for "220"

Result column is ==> Mark2

Result Row is ==> 3

How do we do this in c#..?

Continue reading...