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	385	September 1, 2023
How to copy column in excel Activities excel	2	875	September 1, 2021
Work book activity doubt Help	13	956	August 19, 2019
Deleting whole columns with Delete range activity Help	5	5103	March 2, 2019
Copy one whole column data Studio activities , studio	8	1633	November 4, 2022

Need to copy the whole column value

Related topics