Google Apps Script API
    Preparing search index...

    Interface Sheets

    interface Sheets {
        Spreadsheets: SpreadsheetsCollection;
        newAddBandingRequest(): AddBandingRequest;
        newAddChartRequest(): AddChartRequest;
        newAddConditionalFormatRuleRequest(): AddConditionalFormatRuleRequest;
        newAddDimensionGroupRequest(): AddDimensionGroupRequest;
        newAddFilterViewRequest(): AddFilterViewRequest;
        newAddNamedRangeRequest(): AddNamedRangeRequest;
        newAddProtectedRangeRequest(): AddProtectedRangeRequest;
        newAddSheetRequest(): AddSheetRequest;
        newAppendCellsRequest(): AppendCellsRequest;
        newAppendDimensionRequest(): AppendDimensionRequest;
        newAutoFillRequest(): AutoFillRequest;
        newAutoResizeDimensionsRequest(): AutoResizeDimensionsRequest;
        newBandedRange(): BandedRange;
        newBandingProperties(): BandingProperties;
        newBasicChartAxis(): BasicChartAxis;
        newBasicChartDomain(): BasicChartDomain;
        newBasicChartSeries(): BasicChartSeries;
        newBasicChartSpec(): BasicChartSpec;
        newBasicFilter(): BasicFilter;
        newBatchClearValuesByDataFilterRequest(): BatchClearValuesByDataFilterRequest;
        newBatchClearValuesRequest(): BatchClearValuesRequest;
        newBatchGetValuesByDataFilterRequest(): BatchGetValuesByDataFilterRequest;
        newBatchUpdateSpreadsheetRequest(): BatchUpdateSpreadsheetRequest;
        newBatchUpdateValuesByDataFilterRequest(): BatchUpdateValuesByDataFilterRequest;
        newBatchUpdateValuesRequest(): BatchUpdateValuesRequest;
        newBooleanCondition(): GoogleAppsScript.Sheets.Schema.BooleanCondition;
        newBooleanRule(): BooleanRule;
        newBorder(): GoogleAppsScript.Sheets.Schema.Border;
        newBorders(): Borders;
        newBubbleChartSpec(): BubbleChartSpec;
        newCandlestickChartSpec(): CandlestickChartSpec;
        newCandlestickData(): CandlestickData;
        newCandlestickDomain(): CandlestickDomain;
        newCandlestickSeries(): CandlestickSeries;
        newCellData(): CellData;
        newCellFormat(): CellFormat;
        newChartData(): ChartData;
        newChartSourceRange(): ChartSourceRange;
        newChartSpec(): ChartSpec;
        newClearBasicFilterRequest(): ClearBasicFilterRequest;
        newClearValuesRequest(): any;
        newColor(): GoogleAppsScript.Sheets.Schema.Color;
        newConditionalFormatRule(): GoogleAppsScript.Sheets.Schema.ConditionalFormatRule;
        newConditionValue(): ConditionValue;
        newCopyPasteRequest(): CopyPasteRequest;
        newCopySheetToAnotherSpreadsheetRequest(): CopySheetToAnotherSpreadsheetRequest;
        newCreateDeveloperMetadataRequest(): CreateDeveloperMetadataRequest;
        newCutPasteRequest(): CutPasteRequest;
        newDataFilter(): DataFilter;
        newDataFilterValueRange(): DataFilterValueRange;
        newDataValidationRule(): DataValidationRule;
        newDateTimeRule(): DateTimeRule;
        newDeleteBandingRequest(): DeleteBandingRequest;
        newDeleteConditionalFormatRuleRequest(): DeleteConditionalFormatRuleRequest;
        newDeleteDeveloperMetadataRequest(): DeleteDeveloperMetadataRequest;
        newDeleteDimensionGroupRequest(): DeleteDimensionGroupRequest;
        newDeleteDimensionRequest(): DeleteDimensionRequest;
        newDeleteEmbeddedObjectRequest(): DeleteEmbeddedObjectRequest;
        newDeleteFilterViewRequest(): DeleteFilterViewRequest;
        newDeleteNamedRangeRequest(): GoogleAppsScript.Sheets.Schema.DeleteNamedRangeRequest;
        newDeleteProtectedRangeRequest(): DeleteProtectedRangeRequest;
        newDeleteRangeRequest(): DeleteRangeRequest;
        newDeleteSheetRequest(): DeleteSheetRequest;
        newDeveloperMetadata(): GoogleAppsScript.Sheets.Schema.DeveloperMetadata;
        newDeveloperMetadataLocation(): GoogleAppsScript.Sheets.Schema.DeveloperMetadataLocation;
        newDeveloperMetadataLookup(): DeveloperMetadataLookup;
        newDimensionGroup(): DimensionGroup;
        newDimensionProperties(): DimensionProperties;
        newDimensionRange(): DimensionRange;
        newDuplicateFilterViewRequest(): DuplicateFilterViewRequest;
        newDuplicateSheetRequest(): DuplicateSheetRequest;
        newEditors(): Editors;
        newEmbeddedChart(): GoogleAppsScript.Sheets.Schema.EmbeddedChart;
        newEmbeddedObjectPosition(): EmbeddedObjectPosition;
        newErrorValue(): ErrorValue;
        newExtendedValue(): ExtendedValue;
        newFilterView(): FilterView;
        newFindReplaceRequest(): FindReplaceRequest;
        newGetSpreadsheetByDataFilterRequest(): GetSpreadsheetByDataFilterRequest;
        newGradientRule(): GradientRule;
        newGridCoordinate(): GridCoordinate;
        newGridData(): GridData;
        newGridProperties(): GridProperties;
        newGridRange(): GridRange;
        newHistogramChartSpec(): HistogramChartSpec;
        newHistogramRule(): HistogramRule;
        newHistogramSeries(): HistogramSeries;
        newInsertDimensionRequest(): InsertDimensionRequest;
        newInsertRangeRequest(): InsertRangeRequest;
        newInterpolationPoint(): InterpolationPoint;
        newIterativeCalculationSettings(): IterativeCalculationSettings;
        newLineStyle(): LineStyle;
        newManualRule(): ManualRule;
        newManualRuleGroup(): ManualRuleGroup;
        newMergeCellsRequest(): MergeCellsRequest;
        newMoveDimensionRequest(): MoveDimensionRequest;
        newNamedRange(): GoogleAppsScript.Sheets.Schema.NamedRange;
        newNumberFormat(): NumberFormat;
        newOrgChartSpec(): OrgChartSpec;
        newOverlayPosition(): OverlayPosition;
        newPadding(): Padding;
        newPasteDataRequest(): PasteDataRequest;
        newPieChartSpec(): PieChartSpec;
        newPivotGroup(): GoogleAppsScript.Sheets.Schema.PivotGroup;
        newPivotGroupRule(): PivotGroupRule;
        newPivotGroupSortValueBucket(): PivotGroupSortValueBucket;
        newPivotGroupValueMetadata(): PivotGroupValueMetadata;
        newPivotTable(): GoogleAppsScript.Sheets.Schema.PivotTable;
        newPivotValue(): GoogleAppsScript.Sheets.Schema.PivotValue;
        newProtectedRange(): ProtectedRange;
        newRandomizeRangeRequest(): RandomizeRangeRequest;
        newRepeatCellRequest(): RepeatCellRequest;
        newRequest(): GoogleAppsScript.Sheets.Schema.Request;
        newRowData(): RowData;
        newSearchDeveloperMetadataRequest(): SearchDeveloperMetadataRequest;
        newSetBasicFilterRequest(): SetBasicFilterRequest;
        newSetDataValidationRequest(): SetDataValidationRequest;
        newSheet(): GoogleAppsScript.Sheets.Schema.Sheet;
        newSheetProperties(): SheetProperties;
        newSortRangeRequest(): SortRangeRequest;
        newSortSpec(): GoogleAppsScript.Sheets.Schema.SortSpec;
        newSourceAndDestination(): SourceAndDestination;
        newSpreadsheet(): GoogleAppsScript.Sheets.Schema.Spreadsheet;
        newSpreadsheetProperties(): SpreadsheetProperties;
        newTextFormat(): TextFormat;
        newTextFormatRun(): TextFormatRun;
        newTextPosition(): TextPosition;
        newTextRotation(): GoogleAppsScript.Sheets.Schema.TextRotation;
        newTextToColumnsRequest(): TextToColumnsRequest;
        newTreemapChartColorScale(): TreemapChartColorScale;
        newTreemapChartSpec(): TreemapChartSpec;
        newUnmergeCellsRequest(): UnmergeCellsRequest;
        newUpdateBandingRequest(): UpdateBandingRequest;
        newUpdateBordersRequest(): UpdateBordersRequest;
        newUpdateCellsRequest(): UpdateCellsRequest;
        newUpdateChartSpecRequest(): UpdateChartSpecRequest;
        newUpdateConditionalFormatRuleRequest(): UpdateConditionalFormatRuleRequest;
        newUpdateDeveloperMetadataRequest(): UpdateDeveloperMetadataRequest;
        newUpdateDimensionGroupRequest(): UpdateDimensionGroupRequest;
        newUpdateDimensionPropertiesRequest(): UpdateDimensionPropertiesRequest;
        newUpdateEmbeddedObjectPositionRequest(): UpdateEmbeddedObjectPositionRequest;
        newUpdateFilterViewRequest(): UpdateFilterViewRequest;
        newUpdateNamedRangeRequest(): UpdateNamedRangeRequest;
        newUpdateProtectedRangeRequest(): UpdateProtectedRangeRequest;
        newUpdateSheetPropertiesRequest(): UpdateSheetPropertiesRequest;
        newUpdateSpreadsheetPropertiesRequest(): UpdateSpreadsheetPropertiesRequest;
        newValueRange(): ValueRange;
        newWaterfallChartColumnStyle(): WaterfallChartColumnStyle;
        newWaterfallChartCustomSubtotal(): WaterfallChartCustomSubtotal;
        newWaterfallChartDomain(): WaterfallChartDomain;
        newWaterfallChartSeries(): WaterfallChartSeries;
        newWaterfallChartSpec(): WaterfallChartSpec;
    }
    Index

    Properties

    Spreadsheets

    Methods

    newAddBandingRequest newAddChartRequest newAddConditionalFormatRuleRequest newAddDimensionGroupRequest newAddFilterViewRequest newAddNamedRangeRequest newAddProtectedRangeRequest newAddSheetRequest newAppendCellsRequest newAppendDimensionRequest newAutoFillRequest newAutoResizeDimensionsRequest newBandedRange newBandingProperties newBasicChartAxis newBasicChartDomain newBasicChartSeries newBasicChartSpec newBasicFilter newBatchClearValuesByDataFilterRequest newBatchClearValuesRequest newBatchGetValuesByDataFilterRequest newBatchUpdateSpreadsheetRequest newBatchUpdateValuesByDataFilterRequest newBatchUpdateValuesRequest newBooleanCondition newBooleanRule newBorder newBorders newBubbleChartSpec newCandlestickChartSpec newCandlestickData newCandlestickDomain newCandlestickSeries newCellData newCellFormat newChartData newChartSourceRange newChartSpec newClearBasicFilterRequest newClearValuesRequest newColor newConditionalFormatRule newConditionValue newCopyPasteRequest newCopySheetToAnotherSpreadsheetRequest newCreateDeveloperMetadataRequest newCutPasteRequest newDataFilter newDataFilterValueRange newDataValidationRule newDateTimeRule newDeleteBandingRequest newDeleteConditionalFormatRuleRequest newDeleteDeveloperMetadataRequest newDeleteDimensionGroupRequest newDeleteDimensionRequest newDeleteEmbeddedObjectRequest newDeleteFilterViewRequest newDeleteNamedRangeRequest newDeleteProtectedRangeRequest newDeleteRangeRequest newDeleteSheetRequest newDeveloperMetadata newDeveloperMetadataLocation newDeveloperMetadataLookup newDimensionGroup newDimensionProperties newDimensionRange newDuplicateFilterViewRequest newDuplicateSheetRequest newEditors newEmbeddedChart newEmbeddedObjectPosition newErrorValue newExtendedValue newFilterView newFindReplaceRequest newGetSpreadsheetByDataFilterRequest newGradientRule newGridCoordinate newGridData newGridProperties newGridRange newHistogramChartSpec newHistogramRule newHistogramSeries newInsertDimensionRequest newInsertRangeRequest newInterpolationPoint newIterativeCalculationSettings newLineStyle newManualRule newManualRuleGroup newMergeCellsRequest newMoveDimensionRequest newNamedRange newNumberFormat newOrgChartSpec newOverlayPosition newPadding newPasteDataRequest newPieChartSpec newPivotGroup newPivotGroupRule newPivotGroupSortValueBucket newPivotGroupValueMetadata newPivotTable newPivotValue newProtectedRange newRandomizeRangeRequest newRepeatCellRequest newRequest newRowData newSearchDeveloperMetadataRequest newSetBasicFilterRequest newSetDataValidationRequest newSheet newSheetProperties newSortRangeRequest newSortSpec newSourceAndDestination newSpreadsheet newSpreadsheetProperties newTextFormat newTextFormatRun newTextPosition newTextRotation newTextToColumnsRequest newTreemapChartColorScale newTreemapChartSpec newUnmergeCellsRequest newUpdateBandingRequest newUpdateBordersRequest newUpdateCellsRequest newUpdateChartSpecRequest newUpdateConditionalFormatRuleRequest newUpdateDeveloperMetadataRequest newUpdateDimensionGroupRequest newUpdateDimensionPropertiesRequest newUpdateEmbeddedObjectPositionRequest newUpdateFilterViewRequest newUpdateNamedRangeRequest newUpdateProtectedRangeRequest newUpdateSheetPropertiesRequest newUpdateSpreadsheetPropertiesRequest newValueRange newWaterfallChartColumnStyle newWaterfallChartCustomSubtotal newWaterfallChartDomain newWaterfallChartSeries newWaterfallChartSpec

    Properties
    Spreadsheets: SpreadsheetsCollection

    Methods

    Settings
    Member Visibility

    On This Page
    Properties
    Methods
    newAddBandingRequest newAddChartRequest newAddConditionalFormatRuleRequest newAddDimensionGroupRequest newAddFilterViewRequest newAddNamedRangeRequest newAddProtectedRangeRequest newAddSheetRequest newAppendCellsRequest newAppendDimensionRequest newAutoFillRequest newAutoResizeDimensionsRequest newBandedRange newBandingProperties newBasicChartAxis newBasicChartDomain newBasicChartSeries newBasicChartSpec newBasicFilter newBatchClearValuesByDataFilterRequest newBatchClearValuesRequest newBatchGetValuesByDataFilterRequest newBatchUpdateSpreadsheetRequest newBatchUpdateValuesByDataFilterRequest newBatchUpdateValuesRequest newBooleanCondition newBooleanRule newBorder newBorders newBubbleChartSpec newCandlestickChartSpec newCandlestickData newCandlestickDomain newCandlestickSeries newCellData newCellFormat newChartData newChartSourceRange newChartSpec newClearBasicFilterRequest newClearValuesRequest newColor newConditionalFormatRule newConditionValue newCopyPasteRequest newCopySheetToAnotherSpreadsheetRequest newCreateDeveloperMetadataRequest newCutPasteRequest newDataFilter newDataFilterValueRange newDataValidationRule newDateTimeRule newDeleteBandingRequest newDeleteConditionalFormatRuleRequest newDeleteDeveloperMetadataRequest newDeleteDimensionGroupRequest newDeleteDimensionRequest newDeleteEmbeddedObjectRequest newDeleteFilterViewRequest newDeleteNamedRangeRequest newDeleteProtectedRangeRequest newDeleteRangeRequest newDeleteSheetRequest newDeveloperMetadata newDeveloperMetadataLocation newDeveloperMetadataLookup newDimensionGroup newDimensionProperties newDimensionRange newDuplicateFilterViewRequest newDuplicateSheetRequest newEditors newEmbeddedChart newEmbeddedObjectPosition newErrorValue newExtendedValue newFilterView newFindReplaceRequest newGetSpreadsheetByDataFilterRequest newGradientRule newGridCoordinate newGridData newGridProperties newGridRange newHistogramChartSpec newHistogramRule newHistogramSeries newInsertDimensionRequest newInsertRangeRequest newInterpolationPoint newIterativeCalculationSettings newLineStyle newManualRule newManualRuleGroup newMergeCellsRequest newMoveDimensionRequest newNamedRange newNumberFormat newOrgChartSpec newOverlayPosition newPadding newPasteDataRequest newPieChartSpec newPivotGroup newPivotGroupRule newPivotGroupSortValueBucket newPivotGroupValueMetadata newPivotTable newPivotValue newProtectedRange newRandomizeRangeRequest newRepeatCellRequest newRequest newRowData newSearchDeveloperMetadataRequest newSetBasicFilterRequest newSetDataValidationRequest newSheet newSheetProperties newSortRangeRequest newSortSpec newSourceAndDestination newSpreadsheet newSpreadsheetProperties newTextFormat newTextFormatRun newTextPosition newTextRotation newTextToColumnsRequest newTreemapChartColorScale newTreemapChartSpec newUnmergeCellsRequest newUpdateBandingRequest newUpdateBordersRequest newUpdateCellsRequest newUpdateChartSpecRequest newUpdateConditionalFormatRuleRequest newUpdateDeveloperMetadataRequest newUpdateDimensionGroupRequest newUpdateDimensionPropertiesRequest newUpdateEmbeddedObjectPositionRequest newUpdateFilterViewRequest newUpdateNamedRangeRequest newUpdateProtectedRangeRequest newUpdateSheetPropertiesRequest newUpdateSpreadsheetPropertiesRequest newValueRange newWaterfallChartColumnStyle newWaterfallChartCustomSubtotal newWaterfallChartDomain newWaterfallChartSeries newWaterfallChartSpec