Google Apps Script API
    Preparing search index...

    Interface DataSourcePivotTable

    Access and modify existing data source pivot table. Only use this class with data that's connected to a database

    interface DataSourcePivotTable {
        addColumnGroup(
            columnName: string,
        ): GoogleAppsScript.Spreadsheet.PivotGroup;
        addFilter(
            columnName: string,
            filterCriteria: GoogleAppsScript.Spreadsheet.FilterCriteria,
        ): PivotFilter;
        addPivotValue(
            columnName: string,
            summarizeFunction: PivotTableSummarizeFunction,
        ): GoogleAppsScript.Spreadsheet.PivotValue;
        addRowGroup(columnName: string): GoogleAppsScript.Spreadsheet.PivotGroup;
        asPivotTable(): GoogleAppsScript.Spreadsheet.PivotTable;
        forceRefreshData(): DataSourcePivotTable;
        getDataSource(): DataSource;
        getStatus(): DataExecutionStatus;
        refreshData(): DataSourcePivotTable;
        waitForCompletion(timeoutInSeconds: number): DataExecutionStatus;
    }
    Index

    Methods

    addColumnGroup addFilter addPivotValue addRowGroup asPivotTable forceRefreshData getDataSource getStatus refreshData waitForCompletion

    Methods

    Settings
    Member Visibility

    On This Page
    Methods