Google Apps Script API
    Preparing search index...

    Interface DataSourceSheet

    Access and modify existing data source sheet. To create a new data source sheet, use Spreadsheet.insertDataSourceSheet(spec).

    Only use this class with data that's connected to a database.

    interface DataSourceSheet {
        addFilter(
            columnName: string,
            filterCriteria: GoogleAppsScript.Spreadsheet.FilterCriteria,
        ): DataSourceSheet;
        asSheet(): GoogleAppsScript.Spreadsheet.Sheet;
        autoResizeColumn(columnName: string): DataSourceSheet;
        autoResizeColumns(columnNames: string[]): DataSourceSheet;
        forceRefreshData(): DataSourceSheet;
        getColumnWidth(columnName: string): number;
        getDataSource(): DataSource;
        getFilters(): DataSourceSheetFilter[];
        getSheetValues(
            columnName: string,
            startRow?: number,
            numRows?: number,
        ): any[];
        getSortSpecs(): GoogleAppsScript.Spreadsheet.SortSpec[];
        getStatus(): DataExecutionStatus;
        refreshData(): DataSourceSheet;
        removeFilters(columnName: string): DataSourceSheet;
        removeSortSpec(columnName: string): DataSourceSheet;
        setColumnWidth(columnName: string, width: number): DataSourceSheet;
        setColumnWidths(columnNames: string[], width: number): DataSourceSheet;
        setSortSpec(columnName: string, ascending: boolean): DataSourceSheet;
        waitForCompletion(timeoutInSeconds: number): DataExecutionStatus;
    }
    Index

    Methods

    addFilter asSheet autoResizeColumn autoResizeColumns forceRefreshData getColumnWidth getDataSource getFilters getSheetValues getSortSpecs getStatus refreshData removeFilters removeSortSpec setColumnWidth setColumnWidths setSortSpec waitForCompletion

    Methods

    Settings
    Member Visibility

    On This Page
    Methods