Write data into excel

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

image

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