A group of actions: Excel


The action returns the address of the cell that contains the given text.

Action icon

Settings

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
ContextAction context for working with an Excel documentRobin.ExcelExcel contextYes
Start cell columnColumn of the starting cell from which the search will be performed. Fill in the format «XY», where «X» is the column number and «Y» is the line number. By default, the bounds of the used area are applied from the context.Robin.String No
Start cell rowRow of the starting cell from which the search will be performed. By default, the bounds of the used area are applied from the context.Robin.Numeric No
End cell columnColumn of the destination cell to which the search will be performed. By default, the bounds of the used area are applied from the context.Robin.String No
End cell rowRow of the destination cell to which the search will be performed. By default, the bounds of the used area are applied from the context.Robin.Numeric No
Skip hiddenHidden cells will not be searched.Robin.BooleantrueNo
TextThe text to be searched for.Robin.String Yes
Search methodSearch method. Full-text search will be applied by default.Robin.String No
Results
ResultDictionary with elements - found cells: element key = cell address, element value = cell value.Robin.Dictionary  
  • Нет меток