Hello,
You can do Screen Scraping to select the table from the word document and extract the contents of the table into a generated DataTable. Then you can use Write Range activity to put the table in an Excel file. Please note that in order to do Screen Scraping you must have the word document open.
Here’s some more info on Screen Scraping:
The UiPath Documentation Portal - the home of all our valuable information. Find here everything you need to guide you in your automation journey in the UiPath ecosystem, from complex installation guides to quick tutorials, to practical business...
You could also try to simply copy the table from the document and paste it into excel. Please check these threads:
If position that you are referring is not same as the table#. Then you can use go to Table number (f5) and select Alt+5 or click table selector Image to copy the table and paste in Excel (Ctrl+v)
Hi Skumar,
Yes, it is possible to read a table using the Read text activity in the Word application scope. But the output of this will be a string and not a datatable.
If you wish to copy the data table as a table, use the Ctrl+G shortcut, go to table and use Ctrl+C to copy the table. You can then paste it to excel and use Excel based activities to get it out as a data table.
Regards,
Amrita
