Excel.Interfaces.PivotTableLoadOptions interface
Represents an Excel PivotTable. To learn more about the PivotTable object model, read Work with PivotTables using the Excel JavaScript API.
Remarks
Properties
$all | Specifying |
name | Name of the PivotTable. |
worksheet | The worksheet containing the current PivotTable. |
Property Details
$all
Specifying $all
for the load options loads all the scalar properties (such as Range.address
) but not the navigational properties (such as Range.format.fill.color
).
$all?: boolean;
Property Value
boolean
name
worksheet
The worksheet containing the current PivotTable.
worksheet?: Excel.Interfaces.WorksheetLoadOptions;
Property Value
Remarks
Collaborate with us on GitHub
The source for this content can be found on GitHub, where you can also create and review issues and pull requests. For more information, see our contributor guide.
Office Add-ins