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

• 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.

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.