Write data into excel

[sshitol (sush)]

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)

[Anil_G (Anil Gorthi)]

@sshitol

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

[Sudharsan_Ka]

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

[sshitol (sush)]

i am unable to open flow

[anon87560229]

You can use use filter datatable , by which u can keep or remove column

1. read excel using read range then using output variable pass to filter DT
   in which keeps name = “Andrew”
2. after Filter DT take output pass in write range
   u will get all names of Anderew

[Sudharsan_Ka]

@sshitol

This are the steps not too complicated

In the code you need to use the code that i sent you before

Regards
Sudharsan