Copy from excel, past in word

Help Studio
, ,
1

Hi,

How do I copy a selected range from excel to paste in new word doc?

Thanks

2

Hi @Shannon_Quek

Asuming that you want to past a datatable you can follow this tutorial

Let us know if any doubts or different requirement appear

Regards!

3

Hi,

I am not pasting a table but a selected range

4

It will be a table as well, you can support from the above tutorial

Regards

5

Hi @Shannon_Quek did you try the Insert DataTable in Document activity? You’ll use a Read Range activity to read the table from Excel → store as a DataTable variable, then use that DataTable variable in this activity.

image

6

ok i will try thanks!

7

image
what do i put here for read range? as I have already selected the range which I want.
also, the range varies for different excel sheets

8

If you leave it blank it’ll read the whole Excel sheet. If your table starts from the first row you can leave it blank, otherwise you’ll need to specify the cell addresses of the top left and bottom right of your table e.g. “A1:C5”.

9

my range varies so there is not a fixed one, is there a way to overcome this?

10

Does the table always start from row 1 / could you make your table to always start from row 1? Then you don’t have to specify a range, UiPath will automatically determine the start and end of the table.

If not there are some alternatives such as naming your table in Excel and using that table name in the Read Range activity, e.g.:

image
image785×261 14.6 KB

Or use the Find First/Last Row activity to get the start and end cell addresses

image

11

Hi @Shannon_Quek

I have attached the workflow for the reference. Please do check and follow the below steps.

Main
Main856×688 42.8 KB

Hope it helps!!
Regards,

12

@Shannon_Quek

If the range is already selected in excel and if you need only that range always and if the range would be selected always in excel…then you can use modern read range activity as below

Excel.Sheet("Sheetnma").SelectedRange

This will read the already selected range from excel

Cheers