PivotTableCreateOptions
Contents
[
Hide
]PivotTableCreateOptions class
Options for creating a new PivotTable.
class PivotTableCreateOptions;
Constructors
| Name | Description |
|---|---|
| constructor() | Default Constructor. |
Properties
| Property | Type | Description |
|---|---|---|
| tableName | string | Gets or sets the name of the new PivotTable report. |
| useSameSource | boolean | Gets or sets a value indicating whether to share the same data source with existing pivot tables. Default value is true. |
| isXlsClassic | boolean | Gets or sets a value indicating whether to create classic Excel 97-2003 style PivotTable. |
constructor()
Default Constructor.
constructor();
tableName
Gets or sets the name of the new PivotTable report.
tableName : string;
Remarks
If not set , an automatic name will be set.
useSameSource
Gets or sets a value indicating whether to share the same data source with existing pivot tables. Default value is true.
useSameSource : boolean;
Remarks
When set to true, multiple pivot tables can reuse one pivot cache to reduce memory consumption.
isXlsClassic
Gets or sets a value indicating whether to create classic Excel 97-2003 style PivotTable.
isXlsClassic : boolean;
Remarks
Classic PivotTable uses legacy layout and formatting from Excel 97-2003. When not explicitly set, the default value is determined by the target workbook file format.
