Word Table data to Excel

[deepikamurugesan (Deepi)]

Hi,
I need to generate Excel file based on Word File…
The Word File Contains Table with Data…
I need to Update that table to Excel…
Any one give better suggession…
Regards,

[florin.stan]

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:

Studio - Examples of Using Output or Screen Scraping Methods

You could also try to simply copy the table from the document and paste it into excel. Please check these threads:

Word table to excel

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)

How to read table in a Word document

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

[balupad14 (Balamurugan)]

Hi @deepikamurugesan,

Check this link

Uipath Marketplace ! BalaReva Word Activities

Dear all, Here I have attached the sample that to extract table from word and transfer into the excel. From word. [image] To Excel [image] Input : [image] Output : [image] Sample WordTableExtract.zip (1.3 MB) Thank you Balamurugan.S

Regards
Balamurugan.S