How to copy&paste a table from Excel to Word document

#1

Hi Everyone,

I want to copy several information from a Excel spreadsheet to a Word document. I succeeded to get a specific cell and place it in a specific location in my Word document using Set Bookmark Content. But I didn’t find the solution to copy a table and paste it in a specific location in my Word document, keeping the content and the format.

Could someone help me with this ?

Thank you in advance for your help.

How to copy table from excel into word document
#2

https://forum.uipath.com/t/inserting-the-data-to-word-table/26866

#3

Thank you for your answer!

I’ve already managed to do this kind of operations. What I would like to do is take a table (with colors, format, content) from Excel an put it in a part well defined of a Word Document.

Hope you will be able to help me.

#4

Hi @bwade,

Can you try following steps:

  1. Use Excel scope activity and inside send hot key to select all (ctrl + a). If you want to select a range you use select range activity
  2. Send hot key to copy (ctrl + c)
    3)Send hot key to paste to word(ctrl + v). This step you need to give proper selector so that it paste it to right place.
Copy Word content for each row and replace with the row content (keeping format)
#5

Hi @Sasi.lalo

Thank you! It works when I use the Activity Click at the right place and after paste (when it is on the first page of document). What I can’t do is to find the specific place in my Word Document (for Example in Part 3, page 2) and and send hot key.

Could you enlighten me about this?

#6

Hi @bwad,

Can you try hot key “Ctrl+G” in word, where you have multiple option to choose.

#7

Thanks a lot @Sasi.lalo, it works perfectly!