Excel to word

Help Studio
1

Hi everyone,
i need a small help in pasting the excel values into the word document which has the excel headers as headings. Kindly help

T&R,
S. Sai priya

2

use Append Line Activity as shown.
image

3

but im trying to paste those values from excel word not notepad

4

try to change Filename.doc in the append Line activity and see if it works… or not…

5

ok but how to specify the exact position where it should paste the value…

6

append '\n" → new line character in each iteration you paste… so that every time it will come as newline in the document.

7

Please find the attached ref files to know how my excel and word looks like and please let me know how to create the bot to paste the values under the column “control description” in excel to headings “control description” in wordRef files.zip (70.6 KB)

8

Hi @sai-priya.sanka ,

What about:

  1. Read Range https://docs.uipath.com/activities/docs/excel-read-range
  2. Output Data Table https://docs.uipath.com/activities/docs/output-data-table
  3. Append Text https://docs.uipath.com/activities/docs/word-append-text

Best regards,
Marius

9

But the result will be not in the given format.it will be in the different format… could you please suggest me to have the output in the format shown in the “word ref” file above

10

Hi @sai-priya.sanka ,

Then use:
a. The Read Range activity to read your text from excel, and then
b. The Insert Datatable activity https://docs.uipath.com/activities/docs/word-insert-data-table to add your text at a position relative to a specified text or bookmark.

Hope this helps
Best regards,
Marius