How to insert new column in excel sheet

I will get excel sheet from the dynamically,how to insert column in the given excel sheet.

1 Like

Did you check β€œInsert Column” activity

Hii, thanks for reply
Insert column is only useful for tables ,but in my excel sheet tables are not there

You just has to create a datatable output variable for the excel and pass that variable in β€œinsert column” activity.
Any excel template you have.

I am sharing one sample document with some random data,the sheet contains 3 columns i have to insert one new between B and C column,can you please help me with thatBook1.xlsx (8.1 KB)

My bad i thought its Datatable but its just a table.:stuck_out_tongue:
Np here is workaround. Added new column :slight_smile:
insercolumn.xaml (8.3 KB)


Thank you so much for the solution.Is there any possibility to insert between two columns.

You could do that but its bit messy
either use macros to swap between column or you need to use inbuilt shortcut key of excel and use send hotkey to perform the same.

1 Like

Hi @ddpadil,

Tried your WF and it’s’ working. But when i add new column at the end to an excel with existing columns, Nothing happened like No added column executed. Can you please help me with this? Appreciate your help thanks.