Say I have 3 column Last Week, Current Week and Change. I need to only insert a new column every time before column Change Is that possible ? Somewhat like this I need to achieve Scenario 1 : [image] Scenario 2 : [image]

You can find that position of Change column and store it in Integer variable… Then use assign for Degreement (position_variable - 1) … For ex, Position_int=Datatable_variable.Columns.IndexOf(“Change”) Position_int = position_int -1 Use Insert Column activity pass table name, column name as you w…

How to insert a column in excel based on a certain column name

Help Robot

sangeethaneelavannan1 (Sangeetha Neelavannan) December 26, 2022, 10:09am 3

Hi @Ishan_Shelke
dt.Columns(“columnname”).SetOrdinal(dt.Columns(“change”).Ordinal)

Topic		Replies	Views
Insert column between column? Activities excel , activities , question	26	2903	March 4, 2022
Add columns datatable Activities excel , activities , question	2	423	May 17, 2023
Add column in excel with column name Help datatable , activities , question	21	13888	August 26, 2020
Inserting new column in excel file Help excel , activities , question	6	2145	January 23, 2020
How to insert a column between two columns? Help excel	11	11761	February 4, 2019

How to insert a column in excel based on a certain column name

Related topics