icon-phone530-820-3390 530-820-3390icon-supportSupport

Documentation

Delete Row Data Action: deleteRowData

The deleteRowData action removes a specific row from a given sheet in an Excel file. This function is useful for cleaning up unnecessary or irrelevant data from your spreadsheets.

Note: Ensure that the file being used is not open during the Case execution to avoid errors or conflicts.

Example: You have an Excel file employeeData.xlsx and need to delete row 8 from the sheet named 2023Details.

Steps to Configure:

  1. Add a new step.
  2. Select Set a Variable Value from the Action dropdown.
  3. Enter a variable name in the Element Key field (e.g., RowDeletionStatus). This variable will store the operation result (e.g., success or failure).
  4. Click on Form, select Functions, and choose EXCEL Handler Functions from the dropdown.
  5. In the Cmd field, select deleteRowData and provide the following parameters:
    • FPath: Specify the path to the Excel file (e.g., C:\HR\employeeData.xlsx).
    • Sheet: Specify the name or number of the sheet from which the row will be deleted (e.g., 2023Details).
    • Row Number: Enter the number of the row to be deleted (e.g.,8).
  6. Click Save.
Tabular View
Card View

Outcome on execution:

  • The action deletes row 8 from the sheet 2023Details in the specified Excel file.
  • If the row is successfully deleted, the action returns true in the variable defined in the Element Key.
  • If the operation fails (e.g., row not found or permission denied accessing the excel file), it returns false.
  • This variable can be used in later steps of your automation process to reference the stored information using the syntax ${VariableName} (e.g., ${RowDeletionStatus}).

Back To Top