I have value in Excel column and I want to replace that with fixed value.
I have this Remark column and not sure what data and how much lines will be updated there everytime, I just want to replace all this remark as “Error” like below.
I have value in Excel column and I want to replace that with fixed value.
I have this Remark column and not sure what data and how much lines will be updated there everytime, I just want to replace all this remark as “Error” like below.
@nilesh.mahajan - You can try the below code in ‘Invoke Code’ activity
dt.AsEnumerable().ToList().ForEach(Sub(row) row(“Remark”)= “Error”)
For Reference please check this post…
thnx Prasath for quick response.
I have used the invoke code activity, but somehow it has not changed anything in excel file or Datatable.
Yes, I was used write range but some mistake from my end.
Now its working fine. thnx for help
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.