Hi, need some help related to excel automation.
In excel you have to update the status without using the loop. there are two columns i.e. Number and Status. and the Number contains 4 digit number it is repeated two or three times. user input the number you have to find that number and update the status found at every row where you find respectively. without using the loop.
example.xlsx (8.3 KB)
Just attaching the excel for reference.
In the excel, there are 2 columns ‘Numbers’ and ‘Status’
‘Numbers’ column contains 4 digit numbers.
Task is to find the user provided number in the ‘Numbers’ column and update the ‘Status’ present besides as ‘Found’
This user provided number can be existing multiple times as well under the ‘Numbers’ column.
Wherever this number is found in the ‘Numbers’ column, we have to update the ‘Status’ with ‘Found’ value.
And this exercise needs to be done without using looping techniques
LoadDataRow method return data row of dt. and its contents are array of items : {r("Number"),if(r("Number").ToString=strInput,"Found",r("Status"))}
This means
Column0: r("Number")
Column1: if(r("Number").ToString=strInput,"Found",r("Status"))