Hi everyone, I need to copy Column B & Column F or need to delete all the columns except the Column B & Column F from the excel. Note: Copy/Paste range is taking more time. Sample.xlsx (8.9 KB) Could you help me to solve this? Regards Gokul

@Gokul001 Try below steps. First use Read Range activity to read the entire file and it will give output as DataTable. Let’s say ‘InputDT’. And then use multiple Delete Range activities to delete the data and pass Range as below. "A2:A"+(InputDT.Rows.Count+1).ToString "C2:E"+(InputDT.Rows.Co…

Need to copy the whole column value

Help Activities

Palaniyappan (Palaniyappan P ) October 11, 2021, 1:57pm 5

Did we try with custom component on this scenario

Cheers @Gokul001

2 Likes

Topic		Replies	Views
I want to delete columns in Excel starting from F Activities datatable , excel , activities , studio , question	8	380	September 1, 2023
How to copy column in excel Activities excel	2	875	September 1, 2021
Work book activity doubt Help	13	953	August 19, 2019
Deleting whole columns with Delete range activity Help	5	5090	March 2, 2019
Copy one whole column data Studio activities , studio	8	1525	November 4, 2022

Most Active Users - Yesterday
ashokkarale
Julian_Muhlbauer
SorenB
Jaeyoung_Jung
Jon_Smith
avolaunch
Anil_G
MOMOMOMO
dokumentor
naveen.s
More details...

Need to copy the whole column value

Related topics