I will get excel sheet from the dynamically,how to insert column in the given excel sheet.
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.
Np here is workaround. Added new column
insercolumn.xaml (8.3 KB)
Insert column at first position
Exception thrown while adding trying to add new column to an existing excel file
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.