PivotAddOptions
type PivotAddOptions = object;What PivotManager.add builds a pivot table from. anchorRef is the top-left cell of the
output on sheetName, written without a sheet prefix. The field lists name source columns by
header text (case-insensitive): a header may sit on the row or the column axis, not both, and may
back several data fields, each with its own aggregation (default sum) and display
name (default the label Excel derives, e.g. Sum of Sales).
Properties
Section titled “Properties”anchorRef
Section titled “anchorRef”anchorRef: string;colFields?
Section titled “colFields?”optional colFields?: string[];dataFields?
Section titled “dataFields?”optional dataFields?: object[];aggregation?
Section titled “aggregation?”optional aggregation?: PivotDataFieldAggregation;The measure’s aggregation; Microsoft APIs call the same setting summarizeBy, while JSF stores it as subtotal.
field: string;optional name?: string;name: string;An empty name generates the lowest free workbook-wide PivotTableN name.
rowFields?
Section titled “rowFields?”optional rowFields?: string[];sheetName
Section titled “sheetName”sheetName: string;sourceRef
Section titled “sourceRef”sourceRef: string;sourceSheetName
Section titled “sourceSheetName”sourceSheetName: string;