Example 1: Unique cell matching

        
          	file path						
open excel workbook	D:\data.xlsx						
&nbsp							
	file path	sheet	text	range	after cell	search order	variable
get excel cell containing	D:\data.xlsx	Car Orders Data	RCV05			by rows	unique_id
&nbsp							
	file path	auto save					
close excel workbook	D:\data.xlsx	false					
&nbsp							
        
    

Result

Example 2: Multiple cells matching

        
          	file path						
open excel workbook	D:\data.xlsx						
&nbsp							
	file path	sheet	text	range	after cell	search order	variable
get excel cell containing	D:\data.xlsx	1	Clinton		D10	by rows	last_name
&nbsp							
	file path	auto save					
close excel workbook	D:\data.xlsx	false					
&nbsp							
        
    

Result

• This action only supports Excel extensions: .xls, .xlsx, .xlsm.
• You need to use built-in action open excel workbook before proceeding with this action.
• If no matching cell is found, a variable with the empty value is returned.
• sheet argument:
  • If a sheet name has the value as a numerical text (e.g. the sheet name is 7), enclose the value in quotation marks to differentiate it from a numerical index value (e.g. "7").
• text argument:
  • The text argument can accept wildcard. Note that argument's values that include wildcard must be entirely enclosed in curly braces {}. As an example, {.*arch.*} matches starch, marching, testarchitect, etc.
• range argument:
  • If the range is empty, the default range is the used range. The used range includes all cells from the top-left cell with data to the bottom-right cell with data or formatting.
• after cell argument:
  • The after cell must be a single cell in the range. Remember that the search begins after this cell.
  • If you don't specify this argument, the search starts after the cell in the upper-left corner of the range.
• search order argument:
  • Specifies the order in which to search the range, can be one of following values:
    • by rows: Searches across a row, then moves to the next row.
    • by columns: Searches down through a column, then moves to the next column.
• variable argument:
  • If the variable in argument cell has not been declared or left empty, TestArchitect supplies a global variable with the name _variable.