Inserting new column in excel file

Help
, ,
1

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.

image
image881×383 19.2 KB

@Palaniyappan @ImPratham45

1 Like
2

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

1 Like
3

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.

6

Look for my solution

1 Like
7

Hi @balkishan,

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

1 Like
8

Hi @balkishan
Check this out!

1 Like
9

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