Excel Row Actions

With this command:

• Retrieve the number of rows within a specified column and store it into a new or existing variable.

• Insert or delete rows.

1. Enter the name of the Excel file from which you want to perform a row action:

   • Enter a variable.

     To use a variable in this field, enclose its name between two $ signs (e.g., $MyVar$). When the wizard is executed, the variable name will be substituted with its corresponding value.

   • Enter text.

   • Click Browse and select the Excel file from which you would like to delete cell values.

2. (Optional) Select Unlock file with password for password-protected files and enter the password.

3. Enter the relevant worksheet within the file (identified either by Worksheet name or Worksheet position).

4. Select the row action you would like to perform:

   • Get row count: Retrieve the number of rows within a specified column.

     • You can specify the number of empty cells before the wizard stops counting and assumes all remaining rows are empty.

   • Insert rows: Insert the specified number of rows at the specified position.

   • Delete rows: Delete the specified number of rows at the specified position.

   Provide additional information as required (fields will vary by the action selected).

5. Expand the Error handling option to provide instructions to the wizard on how to manage encountered errors.

   For more information on error handling, see Error handling.

6. (Optional) Select Enable timeout monitoring.

   For more information on timeout monitoring, see Timeout Monitoring.