EmbeddedTableCollection.Add

Syntax:

Add(<TypeOfTheEmbeddedTable>, <Area>)

Parameters:

<TypeOfTheEmbeddedTable> (required)

Type: Type.
Only PivotTable type is permitted.

<Area> (optional)

Type: SpreadsheetDocumentRange.
The embedded table will be located in an area with the coordinates of the left upper corner equal to the corresponding coordinates of area specified in the parameter.

Returned value:

Type: PivotTable.

Description:

Ads an embedded table to the collection.

Availability:

Server, thick client, external connection.

Example:

PivotTable = SpreadDocument.EmbeddedTables.Add(Type("PivotTable"));

    

1C:Enterprise Developer's Community