How to read Excel, find, replace and delete text in Words with loop

[weelearns]

Hi there!

I would like to automate the following,

1. Read “Found Words” in excel, find and replace the text (text to be replace is in excel “Replaced Words” in existing word document
2. Read “Found Words” in excel, find and delete the words (i have indicated in column 3 which are the words to delete) in the same word document
3. Once completed, save the revised version as a new word document

The excel looks something like this.

Can’t seem to do it on my end, please help. Thanks in advance!!

[Sudharsan_Ka]

Hi @weelearns

Checkout this

[Part 1] Modern Activities - Find/Replace Value | Format Cells

Hello Everyone, Hope you are doing good I would like to present this post who are looking for the Modern Activities Very first thing is to Enable the Modern experience (from Classic) Go to → Activities Panel → Click on Filter → Select Show Modern. [image] Let Jump into the Tutorial we are look into some Modern activities Find/Replace Value Format Cells Note : We need to use Excel Process Scope and Use Excel File for all the above activities Excel Process scope Use Excel File …

Regards
Sudharsan

[weelearns]

Hi @Sudharsan_Ka, thanks for the quick reply, but im looking to replace the text in the another word document and not in excel…

[Sudharsan_Ka]

Hi @weelearns

• Read the excel and store them in a datatable
• For each row in datatable
  • Word Activities to replace the text

3. UiPath | Replace Text in Microsoft Word | UiPath Word Automation | Replace Word Occurrence | RPA

Regards
Sudharsan