Google Apps Script API
    Preparing search index...

    Interface SpreadsheetApp

    Access and create Google Sheets files. This class is the parent class for the Spreadsheet service.

    interface SpreadsheetApp {
        AutoFillSeries: typeof AutoFillSeries;
        BandingTheme: typeof BandingTheme;
        BooleanCriteria: typeof BooleanCriteria;
        BorderStyle: typeof GoogleAppsScript.Spreadsheet.BorderStyle;
        ColorType: typeof ColorType;
        CopyPasteType: typeof CopyPasteType;
        DataExecutionErrorCode: typeof DataExecutionErrorCode;
        DataExecutionState: typeof DataExecutionState;
        DataSourceParameterType: typeof DataSourceParameterType;
        DataSourceType: typeof DataSourceType;
        DataValidationCriteria: typeof DataValidationCriteria;
        DeveloperMetadataLocationType: typeof DeveloperMetadataLocationType;
        DeveloperMetadataVisibility: typeof DeveloperMetadataVisibility;
        Dimension: typeof GoogleAppsScript.Spreadsheet.Dimension;
        Direction: typeof Direction;
        GroupControlTogglePosition: typeof GroupControlTogglePosition;
        InterpolationType: typeof InterpolationType;
        PivotTableSummarizeFunction: typeof PivotTableSummarizeFunction;
        PivotValueDisplayType: typeof PivotValueDisplayType;
        ProtectionType: typeof ProtectionType;
        RecalculationInterval: typeof RecalculationInterval;
        RelativeDate: typeof RelativeDate;
        SheetType: typeof SheetType;
        TextDirection: typeof GoogleAppsScript.Spreadsheet.TextDirection;
        TextToColumnsDelimiter: typeof TextToColumnsDelimiter;
        ThemeColorType: typeof GoogleAppsScript.Spreadsheet.ThemeColorType;
        ValueType: typeof ValueType;
        WrapStrategy: typeof WrapStrategy;
        create(name: string): GoogleAppsScript.Spreadsheet.Spreadsheet;
        create(
            name: string,
            rows: number,
            columns: number,
        ): GoogleAppsScript.Spreadsheet.Spreadsheet;
        enableAllDataSourcesExecution(): void;
        enableBigQueryExecution(): void;
        flush(): void;
        getActive(): GoogleAppsScript.Spreadsheet.Spreadsheet;
        getActiveRange(): GoogleAppsScript.Spreadsheet.Range;
        getActiveRangeList(): RangeList;
        getActiveSheet(): GoogleAppsScript.Spreadsheet.Sheet;
        getActiveSpreadsheet(): GoogleAppsScript.Spreadsheet.Spreadsheet;
        getCurrentCell(): GoogleAppsScript.Spreadsheet.Range;
        getSelection(): GoogleAppsScript.Spreadsheet.Selection;
        getUi(): Ui;
        newCellImage(): CellImageBuilder;
        newColor(): ColorBuilder;
        newConditionalFormatRule(): ConditionalFormatRuleBuilder;
        newDataSourceSpec(): DataSourceSpecBuilder;
        newDataValidation(): DataValidationBuilder;
        newFilterCriteria(): FilterCriteriaBuilder;
        newRichTextValue(): RichTextValueBuilder;
        newTextStyle(): GoogleAppsScript.Spreadsheet.TextStyleBuilder;
        open(
            file: GoogleAppsScript.Drive.File,
        ): GoogleAppsScript.Spreadsheet.Spreadsheet;
        openById(id: string): GoogleAppsScript.Spreadsheet.Spreadsheet;
        openByUrl(url: string): GoogleAppsScript.Spreadsheet.Spreadsheet;
        setActiveRange(
            range: GoogleAppsScript.Spreadsheet.Range,
        ): GoogleAppsScript.Spreadsheet.Range;
        setActiveRangeList(rangeList: RangeList): RangeList;
        setActiveSheet(
            sheet: GoogleAppsScript.Spreadsheet.Sheet,
        ): GoogleAppsScript.Spreadsheet.Sheet;
        setActiveSheet(
            sheet: GoogleAppsScript.Spreadsheet.Sheet,
            restoreSelection: boolean,
        ): GoogleAppsScript.Spreadsheet.Sheet;
        setActiveSpreadsheet(
            newActiveSpreadsheet: GoogleAppsScript.Spreadsheet.Spreadsheet,
        ): void;
        setCurrentCell(
            cell: GoogleAppsScript.Spreadsheet.Range,
        ): GoogleAppsScript.Spreadsheet.Range;
    }
    Index

    Properties

    AutoFillSeries BandingTheme BooleanCriteria BorderStyle ColorType CopyPasteType DataExecutionErrorCode DataExecutionState DataSourceParameterType DataSourceType DataValidationCriteria DeveloperMetadataLocationType DeveloperMetadataVisibility Dimension Direction GroupControlTogglePosition InterpolationType PivotTableSummarizeFunction PivotValueDisplayType ProtectionType RecalculationInterval RelativeDate SheetType TextDirection TextToColumnsDelimiter ThemeColorType ValueType WrapStrategy

    Methods

    create enableAllDataSourcesExecution enableBigQueryExecution flush getActive getActiveRange getActiveRangeList getActiveSheet getActiveSpreadsheet getCurrentCell getSelection getUi newCellImage newColor newConditionalFormatRule newDataSourceSpec newDataValidation newFilterCriteria newRichTextValue newTextStyle open openById openByUrl setActiveRange setActiveRangeList setActiveSheet setActiveSpreadsheet setCurrentCell

    Properties
    AutoFillSeries: typeof AutoFillSeries
    BandingTheme: typeof BandingTheme
    BooleanCriteria: typeof BooleanCriteria
    BorderStyle: typeof GoogleAppsScript.Spreadsheet.BorderStyle
    ColorType: typeof ColorType
    CopyPasteType: typeof CopyPasteType
    DataExecutionErrorCode: typeof DataExecutionErrorCode
    DataExecutionState: typeof DataExecutionState
    DataSourceParameterType: typeof DataSourceParameterType
    DataSourceType: typeof DataSourceType
    DataValidationCriteria: typeof DataValidationCriteria
    DeveloperMetadataLocationType: typeof DeveloperMetadataLocationType
    DeveloperMetadataVisibility: typeof DeveloperMetadataVisibility
    Dimension: typeof GoogleAppsScript.Spreadsheet.Dimension
    Direction: typeof Direction
    GroupControlTogglePosition: typeof GroupControlTogglePosition
    InterpolationType: typeof InterpolationType
    PivotTableSummarizeFunction: typeof PivotTableSummarizeFunction
    PivotValueDisplayType: typeof PivotValueDisplayType
    ProtectionType: typeof ProtectionType
    RecalculationInterval: typeof RecalculationInterval
    RelativeDate: typeof RelativeDate
    SheetType: typeof SheetType
    TextDirection: typeof GoogleAppsScript.Spreadsheet.TextDirection
    TextToColumnsDelimiter: typeof TextToColumnsDelimiter
    ThemeColorType: typeof GoogleAppsScript.Spreadsheet.ThemeColorType
    ValueType: typeof ValueType
    WrapStrategy: typeof WrapStrategy

    Methods

    Settings
    Member Visibility

    On This Page
    Properties
    Methods