Copy data from one excel to another excel using header wise

[Anil_G (Anil Gorthi)]

@vikas.mali

Welcome to the community

Use read range and then use setordinal method to change the positions and use add data column to add new column…this way transform the datatable to destination format and then use write range activity to write back

Can't use SetOrdinal in InvokeMethod

@richard.ho SetOrdinal requires a parameter , indicating the new position: the validation method was indicating that there is not SetOrdinal Method with the given Arguments As the argument was missing, so the error came up. do following: [grafik] click on the … to open the configuration editor of the parameters assign as shown the new index fot htis moved column

Hope this helps

cheers