История страницы

Context

Action context for working with an Excel document

Excel instance

Context excel

Yes

Start cell column name

The column name of the initial cell (the beginning of the range) from which the area will be set. If the field is not filled in, the value from the "Index cell column name" field is taken.

String

No

Index cell column name

Column index of the initial cell (beginning of the range) from which the area will be set. If the field is not filled in, the boundary of the used area is taken.

Numeric

No

Start cell row

The row of the initial cell (beginning of the range) from which the area will be set. If the field is not filled in, the boundary of the used area is taken.

Numeric

No

End cell column name

The column name of the end cell (end of range) to which the area to be copied will be set. If the field is not filled in, the value from the "End cell column index" field is taken.

String

No

End cell column index

The column index of the end cell (end of range) to which the area to be copied will be set. If the field is not filled in, the boundary of the used area is taken.

Numeric

No

End cell row

The row of the end cell (end of the range) to which the area to be copied will be set. If the field is not filled in, the boundary of the used area is taken.

Numeric

No

Skip hidden

A boolean variable. If True, only visible rows and columns are returned, otherwise all rows and columns are returned.

Boolean

true

No

Heading

If true, the first row of the table will be highlighted separately as a header and will not be included in the table content rows.

Boolean

true

No

Remove duplicate header

If the value is "true", indexes will be added to the same column names in the header of the resulting table. The numbering starts from 1.

Boolean

true

No

Result

The variable into which the range data will be written

Table