Copy Data from Word to excel

Help
, ,
1

I want to copy the data from word file and paste in Excel how I can do it??

2

Hello,

Can you precise a bit which datas are in your word ? how it is structured ?
Do you want to paste all of the datas ?

Regards

3

No it is structure but I want to paste some particular data from word to excel

4

It is structure and word file have some particular data on each page!!

5

Can you show us an example with some screenshot please ? For us to understand more your issue/question.

Thanks

6

Currently I can’t but I can explain u in detail

There is an word file which has 10 pages or it can be more but it is in structured format!!

Each page is structured with some amount I want to take that amount from word file

Just want to paste in Excel in particular cell

Ex:- word file has
TOTAL AMOUNT 500
I JUST WANT to take 500 and paste in Excel in some particular cell ex. A1

Hope it is clear!!

Regards

7

Currently I can’t but I can explain u in detail

There is an word file which has 10 pages or it can be more but it is in structured format!!

Each page is structured with some amount I want to take that amount from word file

Just want to paste in Excel in particular cell

Ex:- word file has
TOTAL AMOUNT 500
I JUST WANT to take 500 and paste in Excel in some particular cell ex. A1

Hope it is clear!!

Regards

8

Okay it’s clear !

You can use text activities (or even activities from the uipath.word.activities) to read your Word files and use REGEX expression to extract the values you want (Is Match activity) and then store them in a variable to append them (append activity in Excel activities) in an Excel file.

I share you a link to know more about REGEX and create the ones that could be useful for you. REGEX

Do not hesitate to reply bakc if it’s not clear :wink:

Le jeu. 17 oct. 2019 Ă  17:45, Addy_619 via UiPath Community Forum uipath@discoursemail.com a Ă©crit :

1 Like
9

I don’t know regex😅 how much time it will require to learn!!

10

I don’t know regex😅 how much time it will require to learn!!

11

We can help you on that !

The only thing you have to do is to establish a pattern to recognize (a thing that is repeating for each amount to extract)
For example, if each amount is preceded by “TOTAL AMOUNT” it’s a pattern

Give us a pattern and we can translate it to REGEX

1 Like
12

Is there any tool where we can paste pattern and we get regex pattern?

Can u do it Total Amount 500

What will be regex pattern?

13

Is there any tool where we can paste pattern and we get regex pattern?

Can u do it Total Amount 500

What will be regex pattern?

Regards

14

regex is very hard to understand and will not be better than simple string manipulation, unless you have to find multiple times the same pattern inside that word document
 Do you know how to read the word file and extract the text from it? Do you know where (page number) that ‘Total amount 500’ is? or really will have to read all 10 pages to find it?

1 Like
15

Amount will be in each page !!
I had extracted text from PDF early
but I don’t know about word but it has same pattern for all pages!!

16

Amount will be in each page !!
I had extracted text from PDF early
but I don’t know about word but it has same pattern for all pages!!

17

So i advise you to install UiPath.Word.Activities package and start experimenting with it, then see if it can get your text well, when you are ready, identify the text BEFORE and AFTER the number you want and we can help you if difficulty arises.

1 Like
18

Okay thanks for ur help!!