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

Class Google_Service_Sheets

Service definition for Sheets (v4).

Reads and writes Google Sheets.

For more information about this service, see the API Documentation

Google_Service
Extended by Google_Service_Sheets
Author: Google, Inc.
Located at Sheets.php
Methods summary
public
# __construct( Google_Client $client )

Constructs the internal representation of the Sheets service.

Constructs the internal representation of the Sheets service.

Parameters

$client
Constants summary
string DRIVE

See, edit, create, and delete all of your Google Drive files.

See, edit, create, and delete all of your Google Drive files.

#"https://www.googleapis.com/auth/drive"
string DRIVE_FILE

View and manage Google Drive files and folders that you have opened or created with this app.

View and manage Google Drive files and folders that you have opened or created with this app.

#"https://www.googleapis.com/auth/drive.file"
string DRIVE_READONLY

See and download all your Google Drive files.

See and download all your Google Drive files.

#"https://www.googleapis.com/auth/drive.readonly"
string SPREADSHEETS

See, edit, create, and delete your spreadsheets in Google Drive.

See, edit, create, and delete your spreadsheets in Google Drive.

#"https://www.googleapis.com/auth/spreadsheets"
string SPREADSHEETS_READONLY

View your Google Spreadsheets.

View your Google Spreadsheets.

#"https://www.googleapis.com/auth/spreadsheets.readonly"
Properties summary
public mixed $spreadsheets
#
public mixed $spreadsheets_developerMetadata
#
public mixed $spreadsheets_sheets
#
public mixed $spreadsheets_values
#
© 2020 Google Inc.
Google Sheets API documentation generated by ApiGen 2.8.0