How to copy column in excel

I need to copy b and c entire column using vbscript

Adding how to paste the copied column


  1. First use Read Range activity to read the data from source file and it will give output as DataTable. And let’s say ‘DTExcelData’.

  2. And then try below expression.

              DTRequiredData = DTExcelData.DefaultView.ToTable(false,"B-ColumnName","C-ColumnName")
  3. And then use Write Range activity to write destination file.

1 Like