Need to copy the whole column value

@Gokul001

Try below steps.

  1. First use Read Range activity to read the entire file and it will give output as DataTable. Let’s say ‘InputDT’.

  2. 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.Count+1).ToString
     "G2:Z"+(InputDT.Rows.Count+1).ToString
    

Note: Replace Z with end column.

1 Like