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.
1 Like