Replace text in worksheet excel

Hi,
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?
Thank you!

@Li_Pham
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()
Select dtCorrected.Rows.Add(ic)).CopyToDataTable()

LINQ query to update(replace)datatable in uipath

1 Like

@ppr Thank you so much, but I’m so new with UI path, could you give me more details on how to do it?

@Li_Pham
have a look on this demo xaml
Li_Pham.xaml (7.4 KB)

so readin data from excel
do the replacement (as it is done in the demo xaml)
write updated datatable back to excel

1 Like

I got it, thank you so much :smiley:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.