Adding Data Row to another excel file

Help StudioX
,
4

HI @Gus_Fring ,

Yes, you should add assign activity.

  1. Use Read Range Activity to read the input file.
  2. Define columns for output data table using Build Datatable activity.
  3. Then use Assign activity “DT_Input.DefaultView.ToTable(False,“Invoice Code”,“Category”,“Department”)”
  4. Finally use Write Range activity.

Sample xaml is attached follow this.

Specific_Column.xaml (7.9 KB)

Thanks,
Muthuraj