Hi Team,
I am having one excel with header as “car, name and purchase”.
So we have to write purchase value “40000” in front of name. But is it possible to filter “name” column and then update rather than updating each row.
For ex. “name column having value Andrew” so BOT have to pick all “andrew” and update purchase value in front of that row which having name as “andrew”.
test.xlsx (11.0 KB)
Read the data into datatable and then perform your actions and write the data back to excel
For example if you want to update all rows with name as ANDREW then use a for loop and write a if condition to check the name andrew ans if yea then update the respective column
You can do the same by using for eqch row in excel also and use a if condition like currentrow(“name”).ToString.equals(“Andrew”)
Cheers
HI @sshitol
Checkout this expression you need to give this expression in the invoke code and pass the name you need and purchase rate you need in the variable
Dt1.AsEnumerable().Where(Function(s) s(1).ToString.Trim.Equals(Name)).ToList().ForEach(Sub(row) row(2) =Amount_)
Invoke code arguments
Find the xaml file and output file for the reference
Sequence.xaml (13.8 KB)
test.xlsx (11.3 KB)
Hope this helps!
Regards
Sudharsan
You can use use filter datatable , by which u can keep or remove column
This are the steps not too complicated
In the code you need to use the code that i sent you before
Regards
Sudharsan
