Copy selected columns from one Excel file to another

Help Studio
, , ,
6

@Paulissen
What @Lahiru.Fernando said is correct. Just one change in it, if there are too many columns in excel and you want very few columns to be copied, then using remove datatable column will be an expensive process. Instead, use Filter data table.

  1. Using read range activity, read data from excel.
  2. Use Filter data table activity. In the Filter Wizard,

  • Do not specify anything in Filter Rows tab.

  • In output columns tab, Mark column selection mode to “Keep” and Under columns, add the columns that you want in your output datatable.

  1. Use write range activity to write the data in new excel/sheet.
2 Likes