Interface NewPivotTable

What the New PivotTable dialog makes, as IPivotTableCollection.add takes it.

interface NewPivotTable {
    location: ICellRanges | null;
    name?: string;
    source: string | ICellRanges | null;
}

Properties

location: ICellRanges | null

The table's top-left cell.

name?: string

The table's name. When omitted the next free default name is used.

source: string | ICellRanges | null

The cells to summarize: one range, or a table's or defined name's name.