Leggi e rivedi la documentazione di Automation Anywhere

Automation 360

Chiudi contenuti

Contenuti

Apri contenuti

Using Find action

  • Aggiornato: 2021/02/18
    • Automation 360 v.x
    • Crea
    • Spazio di lavoro RPA

Using Find action

Use the Find action to find a particular string in a Microsoft Excel spreadsheet or a CSV file.

To find a value in a Microsoft Excel spreadsheet, do the following:

Procedura

  1. Double-click or drag the Find action from the Excel node in the Actions palette.
  2. Select an option from the From list to specify a starting point of the cell range for search:
    • Beginning: Starts the search from the beginning of the spreadsheet.
    • End: Starts the search from the end of the spreadsheet.
    • Active cell: Starts the search from the active cell in the spreadsheet.
    • Specific cell: Enables you to specify the address of the cell from where you want to start the search.
  3. Select an option from the Till list to specify an end point of the cell range for search:
    • Beginning: Ends the search at the beginning of the spreadsheet.
    • End: Ends the search at the end of the spreadsheet.
    • Active cell: Ends the search at the active cell in the spreadsheet.
    • Specific cell: Enables you to specify the address of the cell where you want to end the search.
  4. Specify the string you want to search for in the Find field.
  5. Select from the following search options:
    • By rows: Enables you to search by rows.
    • By columns: Enables you to search by columns.
    • Match by case: Only performs this action on cells that contain a string that matches the uppercase and lowercase characters of the string you specified in the Find field.
    • Match entire cell contents: Enables you to find only those cells that contain the entire string you have specified in the Find field.
  6. Select the list variable of string data type that you want to use to store the output from the Assign cell addresses variable list.
  7. Inserite il nome della sessione utilizzata per aprire la cartella di lavoro con il comando Apriaction.
  8. In the Assign value to variable list, select a string variable.
    La Control Room mostra un nome descrittivo predefinito della variabile. Se si creano diverse variabili di output, ai nomi delle variabili successive vengono aggiunti -1, -2, -3 e così via per evitare duplicazioni.
  9. Fai clic su Salva.
Invia feedback