How to copy and paste whole column without for each activity

I would like to copy and paste column data to excel file at once without using for each how should i do it?

please explain from taking data as column data

Hi @Seonyong
Use send hot key as ctrl+shift+l and ctrl+a

Thanks
Ashwin.S

@Seonyong Use getcolumn activity in uipath

@sreekanth, Just curious. I do not see “getcolumn” when searched. Do I have to update my studio code ?

image
image

Hi @Seonyong,

Use read range activity to get the data to datatable(dt) .

Then use assign activity
Dt=dt.DefaultView.ToTable(false,"columnname")

Use write range to write it in ur excel sheet.

Regards,
Arivu

1 Like