Search text (Office)

Paste range from clipboard Version 1 (Python)

Action group: Office

The action searches for and returns the addresses of all cells that contain the specified text

Property	Description	Type	Filling example	Mandatory field
Parameters
Context	Action context for ods/xlsx document	Robin.OpenSheetD oc		Yes
Text	The text to be searched	Robin.String		Yes
Start line number	The row number of the starting cell of the text search range. Numbering starts from 1. Default value: index of the first line in the used area of the active sheet of the document.	Robin.Numeric		No
End line number	Ordinal number of the end line of the text search range. Numbering starts from 1. By default, the search ends on the last line of the area used	Robin.Numeric		No
Start cell column	The start column of the text search range. By default, the search starts from the first column of the area used	Robin.String		No
Destination cell column	End column of the text search range. By default, the search ends at the last column of the scope used.	Robin.String		No
Search Method	Text search method. All methods are not case sensitive. Default value: Full text search.	Robin.String		No
Results
Result	Dictionary with records - found cells: record key = cell address, record value = cell value.	Robin.Dictionary

None.

There is a file Book1.xlsx, it is necessary to find the text "test" in the range from 1-4 line in column A, save and close the document.

Use the actions "Open", "Search text", "Save", "Close".

Move the "Open" action to the workspace and set its parameters
In the "Path to file" field specify the path to the file Book1.xlsx
Move the "Search text" action to the workspace and set its parameters
In the "Context" field, specify the context created in step 1.
In the "Text" field specify the value = text.
In the "Sheet" field specify the value = Sheet1.
Fill the "Start line number" and "End line number" fields with the values 1 and 4, respectively.
Fill in the fields "Start cell column", "End cell column".
Fill in the "Search method" field, specifying the value "Full text search".
Move the "Save" action to the workspace and set its parameter.
In the "Context" field specify the context of the opened document.
Move the "Close" action to the workspace and set its parameter.
Launch the robot using the "Start" button in the top panel.