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

Ключ

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

...

Action returns all values of a given column or range of a given page.

Action icon

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" 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.

Output parameters

Result - The variable into which the values from the column will be written.

Settings

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" 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



...