How to copy and paste whole column without for each activity


#1

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


#2

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

Thanks
Ashwin.S


#3

@Seonyong Use getcolumn activity in uipath


#4

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

image
image


#5

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