How to insert a column between two columns in excel using activities without using send hotkey ?

Hello! You can use “Read Range” activity to read all the content and fill a DataTable. After this, you can use “datatable.Columns(ColumnName).SetOrdinal(columnPosition)” Example: [image] It will move the column “NewColumn” to position 3. Hope It Helps :wink: Regards,

Thanks for your reply but it is giving error as expression doesn’t produce a value.

could you please elaborate answer or share screenshot …

Thanks for your reply Akshay. In the above link you are trying to modify the data table(swapping columns).But I want to insert the new column in 2nd index.

add column to datatable and then use invoke method activity to set ordinal of the column as in example. It is not possible set ordinal while inserting a column. insert column set ordinal of column

A ton of thanks for you and Lucas !!! It worked for me !!!

Could you please tell the target type, target object and method name you selected that worked?

the answer to this question is in the ff. link . just sharing for future readers. [image] Insert a Column into a specific position in DataTable Help Hi @naotosx , Here is a new example to insert a new column C between columns A and B. InsertColumn.xaml (8.8 KB) Let me kn…

But this is not working for me it i[Untitled] s Showing bellow error, will you please help me in it.

How to insert a column between two columns?

Help

AkshaySandhu (AkshaySingh Sandhu) December 6, 2017, 2:06pm 5

Try this

Topic		Replies	Views
Insert column between column? Activities excel , activities , question	26	3044	March 4, 2022
How to Add New Column in Datatable ( Between Columns B & C ) Activities excel , activities , question	5	1035	June 29, 2023
How do i add different columns between a datatable Studio	6	72	July 29, 2025
How to insert a column between two existing columns in excel Help excel , activities	11	11582	October 29, 2018
How do i add new columns with data into an existing datatable? Help	9	6611	July 13, 2019

How to insert a column between two columns?

Related topics