How to copy and paste whole column without for each activity

[Seonyong (Yi Seon Yong)]

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

[AshwinS2 (Ashwin S)]

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

Thanks
Ashwin.S

[sreekanth]

@Seonyong Use getcolumn activity in uipath

[viswanarahari]

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

[arivu96 (Arivazhagan A)]

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