Skip to main content

Insert Rows

Inserts new rows to given Excel file.

Input

  • Range: Range to insert the rows
    • Type: System.String
    • Required
  • Where to Insert: Select the position to insert (Start, End or Specific Index).
    • Type: System.Int32
    • Required
    • Dropdown Options:
      • Start
      • End
      • Specific Index
  • Number of Rows: The number of rows to add
    • Type: System.Int32
    • Required
  • Specific Index: The number of the row in your selection to use as starting position.
    • Type: System.Int32

Options

  • Has Headers: If selected, the first row in your selection is not counted when the position where to insert the rows is determined.
    • 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.