Add Data column

I have excel sheet Contain Column like…{project,name,Total}…
I want To add 1 column after “name”. Name of column is “Employee”
Any solution…

First use Add data column activity and then
Use invoke method activity
Where Target Type = null
Target object = Datatable.Columns(“Column_Name”)
Method Name = SetOrdinal
And the Parameter would be the Index of your column i.e 3

Thanks
@Shubham_Akole

what type i select in parameter…?
And select val. 3 and direction is “in”

Find the attached workflow
AddDataColumn.zip (8.6 KB)

IN Parameter with Type INT and VALUE 2
Thanks
@Shubham_Akole

3 Likes

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