Delete from Excel

Delete specified cell values from an Excel file.

1. Enter the name of the Excel file from which you want to delete cell values:

   • 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. If the selected Excel file is password protected, enter the password.

3. Specify the worksheet and cells from which to delete values:

   Select in Excel

   Use this method to select the cells that you want to use from the Excel sheet for your Advanced Command or DAC.

   1. Click Select in Excel to invoke the Excel selector.

      The Select from Excel window appears with the selected Excel file open behind it.

   

   2. Click directly in the Excel file and select the worksheet (tab) and cells you want to use in your Advanced Command or DAC.

      The worksheet name and cell range you have selected will appear in the selector window's Current selection fields.

      If the selector window interferes with viewing or selecting the cells you need, simply drag the window to a more convenient location on the screen.

   

   3. When you are satisfied with your selection, click OK.

   The Advanced Command or DAC window appears with the Worksheet and Range fields populated by your selections.

   If you want to make modifications to your selections, you can do so either manually or by repeating the Select in Excel process.

   

   Enter Excel data selection manually

   Use this method to manually select the worksheet content to be used in your Advanced Command or DAC.

   This approach can be particularly useful when you want to use variable values to select cells.

   1. Specify the worksheet (tab) where the cells containing the desired values for your Advanced Command or DAC selection are located.

      

   2. Choose one of three methods for specifying the cells you want to use from the Excel sheet:

   • Range: Designate the range using a "standard" Excel format (e.g., the range from Column A Row 1 to Column D Row 8 is designated as A1:D8).

   • From/To: Designate the starting column and row, using numbers and/or letters (e.g., cell C5 could be designated as Column 3, Row 5 or Column C, Row 5).

     (Optional) Designate the ending column and row, using numbers and/or letters.

     • If you don't designate an ending column, the robot will copy data from all columns until it detects that it has reached the last column in the range (by reading 20 consecutive empty columns).

     • If you don't designate an ending row, the robot will copy data from all rows until it detects that it has reached the last row in the range (by reading 20 consecutive empty columns).

   • Entire worksheet: The robot will copy data from the entire worksheet until it detects it has reached the last row and column in the sheet (by reading 20 consecutive empty rows/columns).

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

5. (Optional) Select Enable timeout monitoring.

   For more information on timeout monitoring, see Timeout Monitoring.