Insert Column
Insert column into an excel sheet.
Insert a column with values into a specified column name in the excel sheet.
This activity can only be used after the Open Excel File activity.
Input
Number Format : The number format of the column in which the data to be inserted.
Auto - set number format of the cell as the exact format of the given input.
Number - set number format of the cell as the number in which data to be inserted.
Date - set number format of the cell as the date in which data to be inserted.
Text - set number format of the cell as the text in which data to be inserted.
Options
The column name is specified in A
format.
Column Header :
String Argument
Optional
The column header to be inserted.Method : The method to insert a column.
Shift
- shift column after inserting the column data when the column to be inserted contain values.Replace
- replace the input data with the column data if the specified column contains values.
Last updated