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 cellThe address 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
End cellThe address of the destination cell to 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
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
ResultСловарь с одним эдементом - результатом: ключ элемента = «результат», значение элемента = список адресованных ячеек, удовлетворяющих критерием поиска.Robin.Dictionary  
  • Нет меток