Insert new excel columns with headers three new columns

Inputextract.xlsx (10.0 KB)

I have attached a excel file. Im trying to add three new columns between another column. The new columns need to have headers. Could somebody provide a workflow for this issue? I posted more of a description in the excel file. Thanks


Check out this video: Adding Specific Columns From One Data Table To Other - YouTube

You can use the same logic



Check as below

  1. Add data columns with Column Name

  2. Invoke Method `Set Ordinal

  3. pass the parameter position of the Column in Int32

Hope this helps you



If i want to add multiple columns do i have to do a invoke/add data row for each new column? Can multiple columns be added in on invoke method?

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.