Excel Row Actions

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

• Insert or delete rows

1. Select the Excel file on which you would like to perform a row action.

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

3. 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.

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

5. Instruct the wizard how to handle any errors encountered.

   Read more about error handling.

6. Enable timeout monitoring.

   Read more about Timeout Monitoring.