Insert Column
Insert column into an excel sheet.
Last updated
Visualyze Documentation
Insert column into an excel sheet.
Last updated
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 : ExcelHandle Variable
A variable name that references the opened excel file handle.
Sheet Name : String Argument
The name of the sheet in which the column of data is to be inserted.
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.
Column Name : String Argument
The column name to be inserted.
The column name is specified in A format.
Column Header : String Argument Optional
The column header to be inserted.
Column Data : Object Argument
Column values to be inserted. The column data must be a list of objects, a list of strings, or a list of ExcelCell.
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.
