Excel Column Actions

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

• Insert or delete columns

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

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

3. Select the column action you would like to perform:

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

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

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

   • Delete columns: Delete the specified number of columns 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 (optional). Read more about Timeout Monitoring.