Inserts a new column into a table. If no position is specified, the column is inserted at the end of the table. Can only be used in the Excel Application Scope activity.
Strings must be placed between quotation marks.
TableName - The name of the table in which to add a new column. Only String variables and strings are supported.
ColumnName - The name of the column that you want to add. Only String variables and strings are supported.
Position - The column number where to add a new column. The column count starts at 0. Only Integer variables and integers are supported.
- SheetName - The name of the sheet in which to add a new column. By default, this is filled in with "Sheet1." Only String variables are supported.
- DisplayName - The display name of the activity.
- Private - If selected, the values of variables and arguments are no longer logged at Verbose level.
You can see how the Insert Column activity is used in an example that incorporates multiple activities and it is used for managing multiple databases. You can check and download the example from here.
Updated 9 months ago