Using Find action
Use the Find action to find a particular string in a Microsoft Excel spreadsheet or a CSV file.
Procedura
- Double-click or drag the Find action from the Excel node in the Actions palette.
-
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.
-
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.
- Specify the string you want to search for in the Find field.
-
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.
- Select the list variable of string data type that you want to use to store the output from the Assign cell addresses variable list.
- Inserite il nome della sessione utilizzata per aprire la cartella di lavoro con il comando Apriaction.
-
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.
- Fai clic su Salva.