Hi,
I have a list of data in Excel like:
and I need to add/replace these data inside a Word.
The fact is, in the Excel file there are more then 50 rows of data and I am looking for some automatic way to do this.
Thanks,
Diego
Hi,
I have a list of data in Excel like:
and I need to add/replace these data inside a Word.
The fact is, in the Excel file there are more then 50 rows of data and I am looking for some automatic way to do this.
Thanks,
Diego
1.Read range for Excel ,store the O/P in Datatable
2.use For each row activity loop -to loop thro’ the datatable. Inside this for each use invoke method(Add) activity to Store the key value pairs in a dictionary variable.
3.use For each activity -to loop thro’ the dictionary keys.Inside this for each use replace text activity ,to replace the item with dictionary value.
Hi,
I actually used an “Excel Application Scope” with a “Read Range” followed by a “Lookup Data Table” inside a “Try Catch”.
This is working quite well.
Regards,
Diego
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.