Skip to main content

Insert Column

Inserts a new column to given Excel file.

Input

  • Range: The range where the column will be inserted
    • Type: System.String
    • Required
  • Add Header: The header of the column
    • Type: System.String
  • Where to Insert: Information about where the column should be inserted (to the right or to the left).
    • Type: System.Int32
    • Required
    • Dropdown Options:
      • Start
      • End
      • Specific Index
  • Relative to Column: If there is no heading, enter the code of the column. (A, B, C etc.)
    • Type: System.String
    • Required

Options

  • Has Headers: If there are headers in the range where it will be inserted, it should be checked.
    • Type: System.Boolean
    • Required

Details

  • This activity can only be used within the Use Excel File activity. Excel application must be installed on the machine where the process will run.