How to read a table in Word file, then write the table to excel file

[Chris-Yiwei (Ji)]

Dear all,
i have some word files contain tables them, I wanna to read the table in word file ,then write the table to excel file. how could i achieve this function? Anybody who could give me a guide to deal with problem?
or some .xaml demo code ?

thanks a lot in advanced .

Best Regards

[Ellboy (Elliott)]

Try this:

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

[Chris-Yiwei (Ji)]

thanks a lot for your reply.
in fact , content of word file would be changed always, how could deal with this problem?

[Ellboy (Elliott)]

I would use a do while and have the condition be that new information is different to the infomation gained in the last step. As the ctrl + g shortcut advances until it reaches the last table and stays theres, then you know you’ve copied all the tables when the new info on the clipboard ios the same as the last one.

[Chris-Yiwei (Ji)]

thanks a lot for your reply , could you give me a .xaml demo?

thanks a lot in advanced.

[Ellboy (Elliott)]

I don’t have time unfortunately but this is agood opportunity for you to shapren your skills. This will get you comfotable with some control structures if you can do this yourself

[Chris-Yiwei (Ji)]

thanks a lot for you guide. i will try it .

[balupad14 (Balamurugan)]

Hi @Chris-Yiwei

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

[otico (John Michael)]

Hi @Chris-Yiwei,

I created a small activity in C#, Visual Studio to extract the datatable from a word document using “DocumentFormat.OpenXml” library.

The input required is the filepath of the document file, and a non-required input TableIndex that specifies which table to read from in the document (if there is multiple table exists), but by default this one is set to index 0 so if no value given it will return the value from the first table it finds.

Now since this activity returns datatype Data.Datatable, you can use the UiPath Excel activity to write the datatable into the excel file after executing this activity.

I hope this can be part of the solution your looking for

otico.GetDTFromWordDocument.Activities.0.1.0.nupkg (1.2 MB)

[Mrinmayee_Wankhade1 (Mrinmayee Wankhade)]

Hi Otico,

This particular package “otico.GetDTFromWordDocument.Activities.0.1.0.nupkg” is not supported in Windows OS. Can you please provide me the one which does.

PFA.

Thank you!

Regards,
Mrinmayee