How to replace the word in a document by getting value from the excel and continue loop


#1

how to replace the word in a document by getting value from the excel and continue loop
if any one knows reply me…

thanks
in advance.


How to replace the text in a worddocument with excel
#3

how to replace the text in a worddocument with excel and give result


#4

Is it a word doc or ?

If it is word doc then you can follow below steps:

  1. First Read the Data from Your Excel file by using “Excel application Scope”
  2. Use Read Range Activity inside Excel application scope and pass the sheet name to read the data of that sheet and it will return a datatable as an output.Assign it to an output variable of datatable.
  3. Then either use “For Each Row” Activity or “For-Each”(with type argument " System.Data.DataRow").
  4. use the data as per your need. ( if still not aware then see many examples are available on forum already and official site too. You can Take online training first, which is free from Uipath RPA Academy).
  5. Then you can use inside loop the Word Application scope and its Replace Text Activity.
    To understand Word application scope and its activities , check it out below link:
    Word Automation
    Replace Text Activity Guide - Word Activity

Regards…!!
Aksh


#5

Hey @sindhuja

i have moved your topic from 404 Category to here. please do not create the same question again in other categories or here as well.