Сравнение версий

Ключ

  • Эта строка добавлена.
  • Эта строка удалена.
  • Изменено форматирование.

...

Action parameters

Input parameters

  1. "Context" field - The context of the action for working with the Excel document
  2. "Column name" field - Name of the column to which the action will be applied. If the field is not filled in, the value from the “Column Index” "Column Index" field is taken.
  3. "Column index" field - The index of the column to which the action will be applied.
  4. "Range start row number" field - The number of the row in which the start cell of the range is located. If the field is not filled in, the first row of the used range is taken.
  5. "Range end row number" field - The number of the row where the end cell of the range is located. If the field is not filled in, the end row of the used area is taken.
  6. "Skip hidden cells" field - Return only visible cells.
  7. "Skip empty cells" field - Return only non-empty cells.

...

Property

Description

Type

Example of filling in

Obligatory to fill in the field

Parameters

Context

Action context for working with an Excel document

Excel instance

Excel context

Yes

Column name

Name of the column to which the action will be applied. If the field is not filled in, the value from the “Column Index” "Column Index" field is taken

String


НетNo

Column index

The index of the column to which the action will be applied

Numeric


НетNo

Range start row number

The number of the row in which the start cell of the range is located. If the field is not filled in, the first row of the used area is taken

Numeric


НетNo

Range end row number

The number of the row in which the end cell of the range is located. If the field is not filled in, the end row of the used area is taken

Numeric


НетNo

Skip hidden cells

Return only visible cells

Boolean

true

НетNo

Skip empty cells

Return only non-empty cells

Boolean

true

НетNo

Results

Result

Variable to which the values from the column will be written

Collection



...

Implementation of the action requires the following actions - “Open”, “Column data”, “Get value by index”"Open", "Column data", "Get value by index".

Implementation

  1. Assemble a robot scheme consisting of actions:

...

2. Set the parameters in the “Open” "Open" action.

3. Set the parameters of the “Column data” "Column data" action.

4. Set the parameters of the “Get "Get value by index” index" action.

5. Click on the “Start” "Start" button in the top panel. 

...