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

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.

Last updated