I get the problem to replace a text “ABC” in excel worksheet with “XYZ”.
The word “ABC” can appear in any columns or rows in my worksheet.
Could you advise me how to replace them?
Have a Look Here
(From r In dtData.AsEnumerable
Select ia = r.ItemArray.toList
Select ic = ia.ConvertAll(Function (e) e.ToString.Trim.Replace(“ABC”,“XYZ”)).toArray()
@ppr Thank you so much, but I’m so new with UI path, could you give me more details on how to do it?
so readin data from excel
do the replacement (as it is done in the demo xaml)
write updated datatable back to excel
I got it, thank you so much
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.