Add new column at specific position in excel

[vamsikrish28 (Vamsi Krishna)]

How can I add a new column after first 4 columns in an excel worksheet?

[vamsikrish28 (Vamsi Krishna)]

@Palaniyappan Can you suggest me any solution?

[Manish540 (Manish Shettigar)]

This link may help you, @vamsikrish28

Insert a Column into a specific position in DataTable

Hi @naotosx, I have specified the position of the column using the method setOrdinal in the invoke method activity: [image] The DataColumn.SetOrdinal(Int32) method changes the ordinal or position of the DataColumn to the specified ordinal or position. When you change a column’s ordinal, the column is moved to the new position in the collection of columns. Any columns between the previous and new ordinal will be renumbered, to adjust for a column’s new ordinal. Best Regards, Susana

[Palaniyappan (Palaniyappan P)]

Hi
Hope this would help you for sure

Here the set ordinal is used to add the datacolumn at desired position and here in the xaml attached will have set at Column B with 1, you can set as 4 To add at your desired position

Here you go with that sample xaml
add datacolumn.zip (2.6 KB)

Cheers @vamsikrish28