How can we copy collection to a word file Collection is in form of table and also want to add few lines after the table Should be done in blue prism

Question

How can we copy the collection to a word file? The collection is in form of a table and also wants to add a few lines after the table. Should be done in blue prism!

Answer 1

In Automation Anywhere we can, let me explain how but not sure if same logic will work in BP..

-Create a variable with default value > open html body tag and table tag called it vhtml.
-get the data from excel sheet and loop through each cell row by row and append to vhtml. Keep on adding td tags and excel cell data.
-after the end of loop close the html table and body tags.
-Now save the content of vhtml in a file with extension .html
-open the .html file in browser and copy all the content
-paste the copied content in word file.