Hi
—we can ADD DATACOLUMN ACTIVITY for this and also the INVOKE METHOD activity for pla u g at required position
—use excel application scope and pass the file path of first excel as input and use read range and get the output with a variable of type datatable named dt1
—again use another excel application scope and read range activity to get the datatable of aecojd excel with a variable named dt2
—now use a assign activity like
col_variable = dt1.Columns(“yourcolumnname”)
Where col_variable is a variable of type System.Data.DataColumn
—now use INVOKE METHOD with SetOrdinal method to place at desired position in dt2 datatable
With column index as input parameter which usually starts from 0 for first column
which can be written to excel with WRITE RANGE activity
Cheers @prasssaadd