I need to copy b and c entire column using vbscript
Adding how to paste the copied column
First use Read Range activity to read the data from source file and it will give output as DataTable. And let’s say ‘DTExcelData’.
And then try below expression.
DTRequiredData = DTExcelData.DefaultView.ToTable(false,"B-ColumnName","C-ColumnName")
And then use Write Range activity to write destination file.