Read multiple word files from a folder and paste into an excel

Help
, ,
1

Hi,
I’m trying to automate a process wherein we have multiple word files in a folder. word files have data in tables. I have to copy the data from each word files then paste in a draft excel then paste the required data into final excel.
Process
Open Word → read data → paste to draft excel - Paste into final excel.
This needs to be done for each word file.
Please help.
I have used an assign activity and given the path to the directory having docx files.
How should i proceed with For each

2

Hi
Please follow below steps

  1. System.io.directory.getfiles will give list of all doc files
  2. Use for each loop and read word doc
  3. Parse text and write range into excel
3

Hi @anujkaul
Use directory.getFiles(WordFilePath)
Use for each item in WordDoc
Use word application scope
and use read text
and use writhe range of the text

Thanks
Ashwin S

1 Like
4

Could you please share a sample workflow. I’m not able to upload due to company policy.
It would be helpful.

5

Could you please share a sample workflow. I’m not able to upload due to company policy.
If possible

6

Could you please share a sample workflow. I’m not able to upload due to company policy.
It would be helpful.
Thanks