Column data Version 9-10 (Net)

Description

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

Action icon

Settings of parameters

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

Special conditions of use

None.

Example of use

Task

There is an Excel document. You need to select values from a selected column with specified ranges. And to get one of the obtained values for an example.