Action group:  Excel Insert table


Action icon

Version:

  • 12 (net)
  • 11 (net)
  • 10 (net)

The action writes data from a variable of type Table to the specified area of the active Excel workbook page

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

Start cell column nameThe column name of the initial cell in which the top left cell of the table will be placed. If the field is not filled in, the value from the "Start cell column index" field is taken.String
No
Start cell column indexThe column index of the initial cell in which the top left cell of the table will be placed. If the field is not filled in, the border of the used area is taken.Numeric
No
Start cell rowThe cell row in which the top left cell of the table will be placed.Numeric
No
TableVariable of Table type with dataTable
Yes
With headingIf true, the table header will be inserted into the document along with its rows.BooleantrueNo


 


Version:

  • 9 (net)

The action writes data from a variable of type Table to the specified area of the active Excel workbook page

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

Start cell column nameThe cell column in which the top left cell of the table will be placed.String
No
Start cell rowThe cell row in which the top left cell of the table will be placed.Numeric
No
TableVariable of Table type with dataTable
Yes
With headingIf true, the table header will be inserted into the document along with its rows.BooleantrueNo


 


Version:

  • 8 (net)

The action writes data from a variable of type Table to the specified area of the active Excel workbook page

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

Start cell column nameThe cell column in which the top left cell of the table will be placed.String
No
Start cell rowThe cell row in which the top left cell of the table will be placed.Numeric
No
TableVariable of Table type with dataTable
Yes


 


Version:

  • 6 (net)
  • 5 (net)
  • 4 (net)
  • 3 (net)
  • 2 (net)
  • 1 (net)

The action writes data from a variable of type Table to the specified area of the active Excel workbook page

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

Start cellAddress of the cell where the top left cell of the table will be placed. Fill in the format "XY", where "X" is the column number and "Y" is the row number.String
No
TableVariable of Table type with dataTable
Yes
  • Нет меток