Hi Guys,
I have excel1 with Test case column same in excel2 … but the test case places where different…
here i want to update the result in 2nd excel…to the respective test case… If the test case matches…
In my first excel test_01 is in 1st row…and in my 2nd excel “test_01” is for example 10th row…so i want to update the result in 10th row in status column…
this is my first excel…
i want to get the result like this.
can any one help me out without using for each loop here … i got the answer using for each …here the problem is if i have some 1000 rows its taking some time to produce the result …so i want to know how
can i get the same result without using for each loop…
“D”+(sheet2DT.Rows.IndexOf(row_sheet2)+2).ToString i have used this expression to get the result using for each…
Thanks,
Suresh