Extraction of Data From Word Docs

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

image

Is this ??

2 Likes

Yes, it is Read Text

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

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

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

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

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

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

Cheers

3 Likes

Which File ?
can you please explain it more

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

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

2 Likes

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

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

1 Like

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

Please, I will wait your positive reply.

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

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

Hi Balkishan,

U can use the below link to find some thing use full in extracting data table from word.
After that you have to do use string manipulation for making it a data table and write it in excel.

https://forum.uipath.com/t/how-to-read-table-in-a-word-document/682/5

how to do string manipulations?

You can also open Word document and use Table Extraction to get table loaded into DataTable variable.

Pros:

  • no extrernal libraries required
  • no string manipulation needed

Cons:

  • requires opening Word document to do UI interaction

obraz