Skip to main content

Delete Rows

Deletes given rows from given Excel file. (You can write line numbers. For example, by typing 3:10, you can delete all lines in the range including lines 3 and 10. Or, simply enter a single line number to delete just that line.)

Input​

  • Sheet Name: The Excel sheet to be processed
    • Type: System.String
  • at Position: Information about which rows will be deleted. (Applies only when the "Entire Visible Rows" option is selected)
    • Type: System.String
  • Has Headers: When marked, if the first row to be deleted is a header row, it is skipped, and the other rows are deleted.
    • Type: System.Boolean
    • Required
  • What to Delete: The type of delete to be performed.
    • Type: System.Int32
    • Required
    • Dropdown Options:
      • Specific Rows
      • All Visible Rows
      • All Hidden Rows
      • All Duplicate Rows

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.