Extraction of Data From Word Docs

Help
1

Hi, I just want to know is it a feasible to extract the data from the word docs, Is it possible ?
Or we use only PDF for data extraction.
Please guide.
If possible then how can we extract the data from the Word Docs.
@Palaniyappan @Lahiru.Fernando

3 Likes
2

You can download Word Activity pack from Manage Package tab and use Read text activity to read the Word file

3 Likes
3

Untitled
Untitled1124×617 52.6 KB

1 Like
4

Hi BalKishan

You can install Uipath.word.Activities Package. you can use word application scope and read text activity to read the file and get the output as string .

It is not mandatory that you have to go with PDF for data extraction .

regards
Vishnuvarthan P

1 Like
5

image

Is this ??

2 Likes
6

Yes, it is Read Text

7

I have to extract the tabular data, like we do for Pdf.
So is it possible to capturing the data from the Word docs and save in a an Excel file.

1 Like
8

so I have to put in a Word Application Scope or what?
Is it possible to share me the sample of data extraction from the Word.

1 Like
9

You could try to extract whole value and then use some kind of String manipulation to extract and store the data into DataTable, and after write it down to an Excel file

2 Likes
10

It looks like a Excel scope,
So I wondering to use this bcz first time I am using it.
So would it be possible to share me the sample workflow for this.
image

3 Likes
11

Untitled
Untitled341×825 16.2 KB

So you have new Word activities that you’ve installed, and you need to use Word Application Scope> Read Text to read the text.

OR you can use File > Read Text activity without the Word Application Scope (these activities we already had)

1 Like
12

Hi @balkishan
This component could help you resolve this
https://go.uipath.com/component/export-word-table-to-excel

Cheers

3 Likes
13

Which File ?
can you please explain it more

14

They have used some Java code bro, So it will quite diff to manage the java code.
Ia there any method we can directly converted into excel table from word.

image

15

Did you use these activities? I tried but I am getting exceptions.

2 Likes
16

Hi @srdjan.suc @Palaniyappan
I am also trying to use this, can you explain how to use it, In the folder they have given Java file, Licence.
It would be better if you explain it, I am curious to use it.
Thanks in advance :slight_smile:

How did he use that I didn’t see any .xaml workflow here ??

2 Likes
17

I imported the Activity, but I get wierd exception when I try to input the Word File, and Excel File locations

1 Like
18

Well i haven’t used this before
and i tried to reproduce the same, it was throwing me with java exception
Really Sorry for that
Let me check that once
Cheers @balkishan

2 Likes
19

Please, I will wait your positive reply.

@srdjan.suc meanwhile any other method where we can directly convert from Word table to excel table.

20

Hi @srdjan.suc I added the package but I am not able to see the package in the package area?
image