Inserting new column in excel file

Hi, I am able to create a new column in excel but this column is created at the last of the column, But I want to create this like in C position. I am not able to see here to give the new column position.

@Palaniyappan @ImPratham45

1 Like

You can use Invoke Method for set location using Set Ordinal Method

1 Like

which method I can invoke for this to set the new column location.
Not what happened I have 10 columns in my excel but new column when I create it created at last on 11th position but I want to create this on 3rd position. How can I do this.

Look for my solution

1 Like

Hi @balkishan,

Try the below code in invoke code activity
dataTable.Columns.Add("<ColumnName>", GetType(String)).SetOrdinal(3)

1 Like

Hi @balkishan
Check this out!

1 Like

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