Overview

Classes

  • Google_Service_Sheets
  • Google_Service_Sheets_AddBandingRequest
  • Google_Service_Sheets_AddBandingResponse
  • Google_Service_Sheets_AddChartRequest
  • Google_Service_Sheets_AddChartResponse
  • Google_Service_Sheets_AddConditionalFormatRuleRequest
  • Google_Service_Sheets_AddDimensionGroupRequest
  • Google_Service_Sheets_AddDimensionGroupResponse
  • Google_Service_Sheets_AddFilterViewRequest
  • Google_Service_Sheets_AddFilterViewResponse
  • Google_Service_Sheets_AddNamedRangeRequest
  • Google_Service_Sheets_AddNamedRangeResponse
  • Google_Service_Sheets_AddProtectedRangeRequest
  • Google_Service_Sheets_AddProtectedRangeResponse
  • Google_Service_Sheets_AddSheetRequest
  • Google_Service_Sheets_AddSheetResponse
  • Google_Service_Sheets_AddSlicerRequest
  • Google_Service_Sheets_AddSlicerResponse
  • Google_Service_Sheets_AppendCellsRequest
  • Google_Service_Sheets_AppendDimensionRequest
  • Google_Service_Sheets_AppendValuesResponse
  • Google_Service_Sheets_AutoFillRequest
  • Google_Service_Sheets_AutoResizeDimensionsRequest
  • Google_Service_Sheets_BandedRange
  • Google_Service_Sheets_BandingProperties
  • Google_Service_Sheets_BaselineValueFormat
  • Google_Service_Sheets_BasicChartAxis
  • Google_Service_Sheets_BasicChartDomain
  • Google_Service_Sheets_BasicChartSeries
  • Google_Service_Sheets_BasicChartSpec
  • Google_Service_Sheets_BasicFilter
  • Google_Service_Sheets_BatchClearValuesByDataFilterRequest
  • Google_Service_Sheets_BatchClearValuesByDataFilterResponse
  • Google_Service_Sheets_BatchClearValuesRequest
  • Google_Service_Sheets_BatchClearValuesResponse
  • Google_Service_Sheets_BatchGetValuesByDataFilterRequest
  • Google_Service_Sheets_BatchGetValuesByDataFilterResponse
  • Google_Service_Sheets_BatchGetValuesResponse
  • Google_Service_Sheets_BatchUpdateSpreadsheetRequest
  • Google_Service_Sheets_BatchUpdateSpreadsheetResponse
  • Google_Service_Sheets_BatchUpdateValuesByDataFilterRequest
  • Google_Service_Sheets_BatchUpdateValuesByDataFilterResponse
  • Google_Service_Sheets_BatchUpdateValuesRequest
  • Google_Service_Sheets_BatchUpdateValuesResponse
  • Google_Service_Sheets_BooleanCondition
  • Google_Service_Sheets_BooleanRule
  • Google_Service_Sheets_Border
  • Google_Service_Sheets_Borders
  • Google_Service_Sheets_BubbleChartSpec
  • Google_Service_Sheets_CandlestickChartSpec
  • Google_Service_Sheets_CandlestickData
  • Google_Service_Sheets_CandlestickDomain
  • Google_Service_Sheets_CandlestickSeries
  • Google_Service_Sheets_CellData
  • Google_Service_Sheets_CellFormat
  • Google_Service_Sheets_ChartAxisViewWindowOptions
  • Google_Service_Sheets_ChartCustomNumberFormatOptions
  • Google_Service_Sheets_ChartData
  • Google_Service_Sheets_ChartSourceRange
  • Google_Service_Sheets_ChartSpec
  • Google_Service_Sheets_ClearBasicFilterRequest
  • Google_Service_Sheets_ClearValuesRequest
  • Google_Service_Sheets_ClearValuesResponse
  • Google_Service_Sheets_Color
  • Google_Service_Sheets_ColorStyle
  • Google_Service_Sheets_ConditionalFormatRule
  • Google_Service_Sheets_ConditionValue
  • Google_Service_Sheets_CopyPasteRequest
  • Google_Service_Sheets_CopySheetToAnotherSpreadsheetRequest
  • Google_Service_Sheets_CreateDeveloperMetadataRequest
  • Google_Service_Sheets_CreateDeveloperMetadataResponse
  • Google_Service_Sheets_CutPasteRequest
  • Google_Service_Sheets_DataFilter
  • Google_Service_Sheets_DataFilterValueRange
  • Google_Service_Sheets_DataValidationRule
  • Google_Service_Sheets_DateTimeRule
  • Google_Service_Sheets_DeleteBandingRequest
  • Google_Service_Sheets_DeleteConditionalFormatRuleRequest
  • Google_Service_Sheets_DeleteConditionalFormatRuleResponse
  • Google_Service_Sheets_DeleteDeveloperMetadataRequest
  • Google_Service_Sheets_DeleteDeveloperMetadataResponse
  • Google_Service_Sheets_DeleteDimensionGroupRequest
  • Google_Service_Sheets_DeleteDimensionGroupResponse
  • Google_Service_Sheets_DeleteDimensionRequest
  • Google_Service_Sheets_DeleteDuplicatesRequest
  • Google_Service_Sheets_DeleteDuplicatesResponse
  • Google_Service_Sheets_DeleteEmbeddedObjectRequest
  • Google_Service_Sheets_DeleteFilterViewRequest
  • Google_Service_Sheets_DeleteNamedRangeRequest
  • Google_Service_Sheets_DeleteProtectedRangeRequest
  • Google_Service_Sheets_DeleteRangeRequest
  • Google_Service_Sheets_DeleteSheetRequest
  • Google_Service_Sheets_DeveloperMetadata
  • Google_Service_Sheets_DeveloperMetadataLocation
  • Google_Service_Sheets_DeveloperMetadataLookup
  • Google_Service_Sheets_DimensionGroup
  • Google_Service_Sheets_DimensionProperties
  • Google_Service_Sheets_DimensionRange
  • Google_Service_Sheets_DuplicateFilterViewRequest
  • Google_Service_Sheets_DuplicateFilterViewResponse
  • Google_Service_Sheets_DuplicateSheetRequest
  • Google_Service_Sheets_DuplicateSheetResponse
  • Google_Service_Sheets_Editors
  • Google_Service_Sheets_EmbeddedChart
  • Google_Service_Sheets_EmbeddedObjectPosition
  • Google_Service_Sheets_ErrorValue
  • Google_Service_Sheets_ExtendedValue
  • Google_Service_Sheets_FilterCriteria
  • Google_Service_Sheets_FilterView
  • Google_Service_Sheets_FindReplaceRequest
  • Google_Service_Sheets_FindReplaceResponse
  • Google_Service_Sheets_GetSpreadsheetByDataFilterRequest
  • Google_Service_Sheets_GradientRule
  • Google_Service_Sheets_GridCoordinate
  • Google_Service_Sheets_GridData
  • Google_Service_Sheets_GridProperties
  • Google_Service_Sheets_GridRange
  • Google_Service_Sheets_HistogramChartSpec
  • Google_Service_Sheets_HistogramRule
  • Google_Service_Sheets_HistogramSeries
  • Google_Service_Sheets_InsertDimensionRequest
  • Google_Service_Sheets_InsertRangeRequest
  • Google_Service_Sheets_InterpolationPoint
  • Google_Service_Sheets_IterativeCalculationSettings
  • Google_Service_Sheets_KeyValueFormat
  • Google_Service_Sheets_LineStyle
  • Google_Service_Sheets_ManualRule
  • Google_Service_Sheets_ManualRuleGroup
  • Google_Service_Sheets_MatchedDeveloperMetadata
  • Google_Service_Sheets_MatchedValueRange
  • Google_Service_Sheets_MergeCellsRequest
  • Google_Service_Sheets_MoveDimensionRequest
  • Google_Service_Sheets_NamedRange
  • Google_Service_Sheets_NumberFormat
  • Google_Service_Sheets_OrgChartSpec
  • Google_Service_Sheets_OverlayPosition
  • Google_Service_Sheets_Padding
  • Google_Service_Sheets_PasteDataRequest
  • Google_Service_Sheets_PieChartSpec
  • Google_Service_Sheets_PivotFilterCriteria
  • Google_Service_Sheets_PivotGroup
  • Google_Service_Sheets_PivotGroupRule
  • Google_Service_Sheets_PivotGroupSortValueBucket
  • Google_Service_Sheets_PivotGroupValueMetadata
  • Google_Service_Sheets_PivotTable
  • Google_Service_Sheets_PivotValue
  • Google_Service_Sheets_ProtectedRange
  • Google_Service_Sheets_RandomizeRangeRequest
  • Google_Service_Sheets_RepeatCellRequest
  • Google_Service_Sheets_Request
  • Google_Service_Sheets_Response
  • Google_Service_Sheets_RowData
  • Google_Service_Sheets_ScorecardChartSpec
  • Google_Service_Sheets_SearchDeveloperMetadataRequest
  • Google_Service_Sheets_SearchDeveloperMetadataResponse
  • Google_Service_Sheets_SetBasicFilterRequest
  • Google_Service_Sheets_SetDataValidationRequest
  • Google_Service_Sheets_Sheet
  • Google_Service_Sheets_SheetProperties
  • Google_Service_Sheets_Slicer
  • Google_Service_Sheets_SlicerSpec
  • Google_Service_Sheets_SortRangeRequest
  • Google_Service_Sheets_SortSpec
  • Google_Service_Sheets_SourceAndDestination
  • Google_Service_Sheets_Spreadsheet
  • Google_Service_Sheets_SpreadsheetProperties
  • Google_Service_Sheets_Spreadsheets_Resource
  • Google_Service_Sheets_SpreadsheetsDeveloperMetadata_Resource
  • Google_Service_Sheets_SpreadsheetsSheets_Resource
  • Google_Service_Sheets_SpreadsheetsValues_Resource
  • Google_Service_Sheets_SpreadsheetTheme
  • Google_Service_Sheets_TextFormat
  • Google_Service_Sheets_TextFormatRun
  • Google_Service_Sheets_TextPosition
  • Google_Service_Sheets_TextRotation
  • Google_Service_Sheets_TextToColumnsRequest
  • Google_Service_Sheets_ThemeColorPair
  • Google_Service_Sheets_TreemapChartColorScale
  • Google_Service_Sheets_TreemapChartSpec
  • Google_Service_Sheets_TrimWhitespaceRequest
  • Google_Service_Sheets_TrimWhitespaceResponse
  • Google_Service_Sheets_UnmergeCellsRequest
  • Google_Service_Sheets_UpdateBandingRequest
  • Google_Service_Sheets_UpdateBordersRequest
  • Google_Service_Sheets_UpdateCellsRequest
  • Google_Service_Sheets_UpdateChartSpecRequest
  • Google_Service_Sheets_UpdateConditionalFormatRuleRequest
  • Google_Service_Sheets_UpdateConditionalFormatRuleResponse
  • Google_Service_Sheets_UpdateDeveloperMetadataRequest
  • Google_Service_Sheets_UpdateDeveloperMetadataResponse
  • Google_Service_Sheets_UpdateDimensionGroupRequest
  • Google_Service_Sheets_UpdateDimensionPropertiesRequest
  • Google_Service_Sheets_UpdateEmbeddedObjectPositionRequest
  • Google_Service_Sheets_UpdateEmbeddedObjectPositionResponse
  • Google_Service_Sheets_UpdateFilterViewRequest
  • Google_Service_Sheets_UpdateNamedRangeRequest
  • Google_Service_Sheets_UpdateProtectedRangeRequest
  • Google_Service_Sheets_UpdateSheetPropertiesRequest
  • Google_Service_Sheets_UpdateSlicerSpecRequest
  • Google_Service_Sheets_UpdateSpreadsheetPropertiesRequest
  • Google_Service_Sheets_UpdateValuesByDataFilterResponse
  • Google_Service_Sheets_UpdateValuesResponse
  • Google_Service_Sheets_ValueRange
  • Google_Service_Sheets_WaterfallChartColumnStyle
  • Google_Service_Sheets_WaterfallChartCustomSubtotal
  • Google_Service_Sheets_WaterfallChartDomain
  • Google_Service_Sheets_WaterfallChartSeries
  • Google_Service_Sheets_WaterfallChartSpec
  • Overview
  • Class
  • Tree

Google Sheets API

Classes summary
Google_Service_Sheets Service definition for Sheets (v4).
Google_Service_Sheets_AddBandingRequest
Google_Service_Sheets_AddBandingResponse
Google_Service_Sheets_AddChartRequest
Google_Service_Sheets_AddChartResponse
Google_Service_Sheets_AddConditionalFormatRuleRequest
Google_Service_Sheets_AddDimensionGroupRequest
Google_Service_Sheets_AddDimensionGroupResponse
Google_Service_Sheets_AddFilterViewRequest
Google_Service_Sheets_AddFilterViewResponse
Google_Service_Sheets_AddNamedRangeRequest
Google_Service_Sheets_AddNamedRangeResponse
Google_Service_Sheets_AddProtectedRangeRequest
Google_Service_Sheets_AddProtectedRangeResponse
Google_Service_Sheets_AddSheetRequest
Google_Service_Sheets_AddSheetResponse
Google_Service_Sheets_AddSlicerRequest
Google_Service_Sheets_AddSlicerResponse
Google_Service_Sheets_AppendCellsRequest
Google_Service_Sheets_AppendDimensionRequest
Google_Service_Sheets_AppendValuesResponse
Google_Service_Sheets_AutoFillRequest
Google_Service_Sheets_AutoResizeDimensionsRequest
Google_Service_Sheets_BandedRange
Google_Service_Sheets_BandingProperties
Google_Service_Sheets_BaselineValueFormat
Google_Service_Sheets_BasicChartAxis
Google_Service_Sheets_BasicChartDomain
Google_Service_Sheets_BasicChartSeries
Google_Service_Sheets_BasicChartSpec
Google_Service_Sheets_BasicFilter
Google_Service_Sheets_BatchClearValuesByDataFilterRequest
Google_Service_Sheets_BatchClearValuesByDataFilterResponse
Google_Service_Sheets_BatchClearValuesRequest
Google_Service_Sheets_BatchClearValuesResponse
Google_Service_Sheets_BatchGetValuesByDataFilterRequest
Google_Service_Sheets_BatchGetValuesByDataFilterResponse
Google_Service_Sheets_BatchGetValuesResponse
Google_Service_Sheets_BatchUpdateSpreadsheetRequest
Google_Service_Sheets_BatchUpdateSpreadsheetResponse
Google_Service_Sheets_BatchUpdateValuesByDataFilterRequest
Google_Service_Sheets_BatchUpdateValuesByDataFilterResponse
Google_Service_Sheets_BatchUpdateValuesRequest
Google_Service_Sheets_BatchUpdateValuesResponse
Google_Service_Sheets_BooleanCondition
Google_Service_Sheets_BooleanRule
Google_Service_Sheets_Border
Google_Service_Sheets_Borders
Google_Service_Sheets_BubbleChartSpec
Google_Service_Sheets_CandlestickChartSpec
Google_Service_Sheets_CandlestickData
Google_Service_Sheets_CandlestickDomain
Google_Service_Sheets_CandlestickSeries
Google_Service_Sheets_CellData
Google_Service_Sheets_CellFormat
Google_Service_Sheets_ChartAxisViewWindowOptions
Google_Service_Sheets_ChartCustomNumberFormatOptions
Google_Service_Sheets_ChartData
Google_Service_Sheets_ChartSourceRange
Google_Service_Sheets_ChartSpec
Google_Service_Sheets_ClearBasicFilterRequest
Google_Service_Sheets_ClearValuesRequest
Google_Service_Sheets_ClearValuesResponse
Google_Service_Sheets_Color
Google_Service_Sheets_ColorStyle
Google_Service_Sheets_ConditionalFormatRule
Google_Service_Sheets_ConditionValue
Google_Service_Sheets_CopyPasteRequest
Google_Service_Sheets_CopySheetToAnotherSpreadsheetRequest
Google_Service_Sheets_CreateDeveloperMetadataRequest
Google_Service_Sheets_CreateDeveloperMetadataResponse
Google_Service_Sheets_CutPasteRequest
Google_Service_Sheets_DataFilter
Google_Service_Sheets_DataFilterValueRange
Google_Service_Sheets_DataValidationRule
Google_Service_Sheets_DateTimeRule
Google_Service_Sheets_DeleteBandingRequest
Google_Service_Sheets_DeleteConditionalFormatRuleRequest
Google_Service_Sheets_DeleteConditionalFormatRuleResponse
Google_Service_Sheets_DeleteDeveloperMetadataRequest
Google_Service_Sheets_DeleteDeveloperMetadataResponse
Google_Service_Sheets_DeleteDimensionGroupRequest
Google_Service_Sheets_DeleteDimensionGroupResponse
Google_Service_Sheets_DeleteDimensionRequest
Google_Service_Sheets_DeleteDuplicatesRequest
Google_Service_Sheets_DeleteDuplicatesResponse
Google_Service_Sheets_DeleteEmbeddedObjectRequest
Google_Service_Sheets_DeleteFilterViewRequest
Google_Service_Sheets_DeleteNamedRangeRequest
Google_Service_Sheets_DeleteProtectedRangeRequest
Google_Service_Sheets_DeleteRangeRequest
Google_Service_Sheets_DeleteSheetRequest
Google_Service_Sheets_DeveloperMetadata
Google_Service_Sheets_DeveloperMetadataLocation
Google_Service_Sheets_DeveloperMetadataLookup
Google_Service_Sheets_DimensionGroup
Google_Service_Sheets_DimensionProperties
Google_Service_Sheets_DimensionRange
Google_Service_Sheets_DuplicateFilterViewRequest
Google_Service_Sheets_DuplicateFilterViewResponse
Google_Service_Sheets_DuplicateSheetRequest
Google_Service_Sheets_DuplicateSheetResponse
Google_Service_Sheets_Editors
Google_Service_Sheets_EmbeddedChart
Google_Service_Sheets_EmbeddedObjectPosition
Google_Service_Sheets_ErrorValue
Google_Service_Sheets_ExtendedValue
Google_Service_Sheets_FilterCriteria
Google_Service_Sheets_FilterView
Google_Service_Sheets_FindReplaceRequest
Google_Service_Sheets_FindReplaceResponse
Google_Service_Sheets_GetSpreadsheetByDataFilterRequest
Google_Service_Sheets_GradientRule
Google_Service_Sheets_GridCoordinate
Google_Service_Sheets_GridData
Google_Service_Sheets_GridProperties
Google_Service_Sheets_GridRange
Google_Service_Sheets_HistogramChartSpec
Google_Service_Sheets_HistogramRule
Google_Service_Sheets_HistogramSeries
Google_Service_Sheets_InsertDimensionRequest
Google_Service_Sheets_InsertRangeRequest
Google_Service_Sheets_InterpolationPoint
Google_Service_Sheets_IterativeCalculationSettings
Google_Service_Sheets_KeyValueFormat
Google_Service_Sheets_LineStyle
Google_Service_Sheets_ManualRule
Google_Service_Sheets_ManualRuleGroup
Google_Service_Sheets_MatchedDeveloperMetadata
Google_Service_Sheets_MatchedValueRange
Google_Service_Sheets_MergeCellsRequest
Google_Service_Sheets_MoveDimensionRequest
Google_Service_Sheets_NamedRange
Google_Service_Sheets_NumberFormat
Google_Service_Sheets_OrgChartSpec
Google_Service_Sheets_OverlayPosition
Google_Service_Sheets_Padding
Google_Service_Sheets_PasteDataRequest
Google_Service_Sheets_PieChartSpec
Google_Service_Sheets_PivotFilterCriteria
Google_Service_Sheets_PivotGroup
Google_Service_Sheets_PivotGroupRule
Google_Service_Sheets_PivotGroupSortValueBucket
Google_Service_Sheets_PivotGroupValueMetadata
Google_Service_Sheets_PivotTable
Google_Service_Sheets_PivotValue
Google_Service_Sheets_ProtectedRange
Google_Service_Sheets_RandomizeRangeRequest
Google_Service_Sheets_RepeatCellRequest
Google_Service_Sheets_Request
Google_Service_Sheets_Response
Google_Service_Sheets_RowData
Google_Service_Sheets_ScorecardChartSpec
Google_Service_Sheets_SearchDeveloperMetadataRequest
Google_Service_Sheets_SearchDeveloperMetadataResponse
Google_Service_Sheets_SetBasicFilterRequest
Google_Service_Sheets_SetDataValidationRequest
Google_Service_Sheets_Sheet
Google_Service_Sheets_SheetProperties
Google_Service_Sheets_Slicer
Google_Service_Sheets_SlicerSpec
Google_Service_Sheets_SortRangeRequest
Google_Service_Sheets_SortSpec
Google_Service_Sheets_SourceAndDestination
Google_Service_Sheets_Spreadsheet
Google_Service_Sheets_SpreadsheetProperties
Google_Service_Sheets_Spreadsheets_Resource The "spreadsheets" collection of methods. Typical usage is: <code> $sheetsService = new Google_Service_Sheets(...); $spreadsheets = $sheetsService->spreadsheets; </code>
Google_Service_Sheets_SpreadsheetsDeveloperMetadata_Resource The "developerMetadata" collection of methods. Typical usage is: <code> $sheetsService = new Google_Service_Sheets(...); $developerMetadata = $sheetsService->developerMetadata; </code>
Google_Service_Sheets_SpreadsheetsSheets_Resource The "sheets" collection of methods. Typical usage is: <code> $sheetsService = new Google_Service_Sheets(...); $sheets = $sheetsService->sheets; </code>
Google_Service_Sheets_SpreadsheetsValues_Resource The "values" collection of methods. Typical usage is: <code> $sheetsService = new Google_Service_Sheets(...); $values = $sheetsService->values; </code>
Google_Service_Sheets_SpreadsheetTheme
Google_Service_Sheets_TextFormat
Google_Service_Sheets_TextFormatRun
Google_Service_Sheets_TextPosition
Google_Service_Sheets_TextRotation
Google_Service_Sheets_TextToColumnsRequest
Google_Service_Sheets_ThemeColorPair
Google_Service_Sheets_TreemapChartColorScale
Google_Service_Sheets_TreemapChartSpec
Google_Service_Sheets_TrimWhitespaceRequest
Google_Service_Sheets_TrimWhitespaceResponse
Google_Service_Sheets_UnmergeCellsRequest
Google_Service_Sheets_UpdateBandingRequest
Google_Service_Sheets_UpdateBordersRequest
Google_Service_Sheets_UpdateCellsRequest
Google_Service_Sheets_UpdateChartSpecRequest
Google_Service_Sheets_UpdateConditionalFormatRuleRequest
Google_Service_Sheets_UpdateConditionalFormatRuleResponse
Google_Service_Sheets_UpdateDeveloperMetadataRequest
Google_Service_Sheets_UpdateDeveloperMetadataResponse
Google_Service_Sheets_UpdateDimensionGroupRequest
Google_Service_Sheets_UpdateDimensionPropertiesRequest
Google_Service_Sheets_UpdateEmbeddedObjectPositionRequest
Google_Service_Sheets_UpdateEmbeddedObjectPositionResponse
Google_Service_Sheets_UpdateFilterViewRequest
Google_Service_Sheets_UpdateNamedRangeRequest
Google_Service_Sheets_UpdateProtectedRangeRequest
Google_Service_Sheets_UpdateSheetPropertiesRequest
Google_Service_Sheets_UpdateSlicerSpecRequest
Google_Service_Sheets_UpdateSpreadsheetPropertiesRequest
Google_Service_Sheets_UpdateValuesByDataFilterResponse
Google_Service_Sheets_UpdateValuesResponse
Google_Service_Sheets_ValueRange
Google_Service_Sheets_WaterfallChartColumnStyle
Google_Service_Sheets_WaterfallChartCustomSubtotal
Google_Service_Sheets_WaterfallChartDomain
Google_Service_Sheets_WaterfallChartSeries
Google_Service_Sheets_WaterfallChartSpec
© 2020 Google Inc.
Google Sheets API documentation generated by ApiGen 2.8.0