Insert Column
Insert column into an excel sheet.
Insert a column with values into a specified column name in the excel sheet.
Input
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.
Options
Column Name :
String Argument
The column name to be inserted.
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.
Last updated