Search for Value

Object for Excel data search

Settings

This object depends on the "New Excel" or "Open Excel" object to work.

Field	Descriptive
Títle	Object Title
Object Identifier Name	Singular object name for the Excel data search
Select Main Object	Option to select the Excel spreadsheet
Text	Text to search for
Search Type	Option to select the type of the search ("Exactly" or "Containing" the text entered)
Minimum Column	Minimum search range column (minimum value 1)
Maximum Column	Maximum search range column
Minimum Row	Minimum search range row (minimum value 1)
Maximum Row	Maximum search range row

Example

To search for values in an Excel spreadsheet file you need to follow a few steps:

1 - Select the "Open Excel" object from the "Excel" menu and drag it to your working area.

• First you must define a unique name for the object in the "Object Identifier Name" field, inform the complete directory containing the name and the extension of the file and then set a password if it is required.

2 - Then select the object "Search for Value" from the "Excel" menu, inform a name for the object, select the main object, inform the text to search for and select the search type ("Exactly" or "Containing" the informed text) and ,lastly, inform the target columns and rows for the search.