Skip to main content

Clear Range

Clears all data and formatting from a range of cells.

Input​

  • Sheet Name: The Excel sheet to be processed (If no sheet name is entered, the last used Excel sheet is taken by default)
    • Type: System.String
  • Cells: Set what cells to clear, leave blank to clear all cells
    • Type: System.String
  • Has Headers: First row in the range is a header row.
    • Type: System.Boolean

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.