Docs Support Console
    Contact Us Start free

    Class /GOOG/CL_SHEETS_V4

    Class

     /GOOG/CL_SHEETS_V4
    • Inheriting from: /GOOG/CL_HTTP_CLIENT
    • Description: Google Sheets API v4
    For general information about a class in ABAP SDK for Google Cloud, see API client stub .

    Types

    Type Description Visibility
    TY_001
    		AddBandingRequest PUBLIC
    TY_002
    		AddBandingResponse PUBLIC
    TY_003
    		AddChartRequest PUBLIC
    TY_004
    		AddChartResponse PUBLIC
    TY_005
    		AddConditionalFormatRuleRequest PUBLIC
    TY_006
    		AddDataSourceRequest PUBLIC
    TY_007
    		AddDataSourceResponse PUBLIC
    TY_008
    		AddDimensionGroupRequest PUBLIC
    TY_009
    		AddDimensionGroupResponse PUBLIC
    TY_010
    		AddFilterViewRequest PUBLIC
    TY_011
    		AddFilterViewResponse PUBLIC
    TY_012
    		AddNamedRangeRequest PUBLIC
    TY_013
    		AddNamedRangeResponse PUBLIC
    TY_014
    		AddProtectedRangeRequest PUBLIC
    TY_015
    		AddProtectedRangeResponse PUBLIC
    TY_016
    		AddSheetRequest PUBLIC
    TY_017
    		AddSheetResponse PUBLIC
    TY_018
    		AddSlicerRequest PUBLIC
    TY_019
    		AddSlicerResponse PUBLIC
    TY_020
    		AppendCellsRequest PUBLIC
    TY_021
    		AppendDimensionRequest PUBLIC
    TY_022
    		AppendValuesResponse PUBLIC
    TY_023
    		AutoFillRequest PUBLIC
    TY_024
    		AutoResizeDimensionsRequest PUBLIC
    TY_025
    		BandedRange PUBLIC
    TY_026
    		BandingProperties PUBLIC
    TY_027
    		BaselineValueFormat PUBLIC
    TY_028
    		BasicChartAxis PUBLIC
    TY_029
    		BasicChartDomain PUBLIC
    TY_030
    		BasicChartSeries PUBLIC
    TY_031
    		BasicChartSpec PUBLIC
    TY_032
    		BasicFilter PUBLIC
    TY_033
    		BasicSeriesDataPointStyleOverride PUBLIC
    TY_034
    		BatchClearValuesByDataFilterRequest PUBLIC
    TY_035
    		BatchClearValuesByDataFilterResponse PUBLIC
    TY_036
    		BatchClearValuesRequest PUBLIC
    TY_037
    		BatchClearValuesResponse PUBLIC
    TY_038
    		BatchGetValuesByDataFilterRequest PUBLIC
    TY_039
    		BatchGetValuesByDataFilterResponse PUBLIC
    TY_040
    		BatchGetValuesResponse PUBLIC
    TY_041
    		BatchUpdateSpreadsheetRequest PUBLIC
    TY_042
    		BatchUpdateSpreadsheetResponse PUBLIC
    TY_043
    		BatchUpdateValuesByDataFilterRequest PUBLIC
    TY_044
    		BatchUpdateValuesByDataFilterResponse PUBLIC
    TY_045
    		BatchUpdateValuesRequest PUBLIC
    TY_046
    		BatchUpdateValuesResponse PUBLIC
    TY_047
    		BigQueryDataSourceSpec PUBLIC
    TY_048
    		BigQueryQuerySpec PUBLIC
    TY_049
    		BigQueryTableSpec PUBLIC
    TY_050
    		BooleanCondition PUBLIC
    TY_051
    		BooleanRule PUBLIC
    TY_052
    		Border PUBLIC
    TY_053
    		Borders PUBLIC
    TY_054
    		BubbleChartSpec PUBLIC
    TY_055
    		CandlestickChartSpec PUBLIC
    TY_056
    		CandlestickData PUBLIC
    TY_057
    		CandlestickDomain PUBLIC
    TY_058
    		CandlestickSeries PUBLIC
    TY_059
    		CellData PUBLIC
    TY_060
    		CellFormat PUBLIC
    TY_061
    		ChartAxisViewWindowOptions PUBLIC
    TY_062
    		ChartCustomNumberFormatOptions PUBLIC
    TY_063
    		ChartData PUBLIC
    TY_064
    		ChartDateTimeRule PUBLIC
    TY_065
    		ChartGroupRule PUBLIC
    TY_066
    		ChartHistogramRule PUBLIC
    TY_067
    		ChartSourceRange PUBLIC
    TY_068
    		ChartSpec PUBLIC
    TY_069
    		ClearBasicFilterRequest PUBLIC
    TY_071
    		ClearValuesResponse PUBLIC
    TY_072
    		Color PUBLIC
    TY_073
    		ColorStyle PUBLIC
    TY_074
    		ConditionValue PUBLIC
    TY_075
    		ConditionalFormatRule PUBLIC
    TY_076
    		CopyPasteRequest PUBLIC
    TY_077
    		CopySheetToAnotherSpreadsheetRequest PUBLIC
    TY_078
    		CreateDeveloperMetadataRequest PUBLIC
    TY_079
    		CreateDeveloperMetadataResponse PUBLIC
    TY_080
    		CutPasteRequest PUBLIC
    TY_081
    		DataExecutionStatus PUBLIC
    TY_082
    		DataFilter PUBLIC
    TY_083
    		DataFilterValueRange PUBLIC
    TY_084
    		DataLabel PUBLIC
    TY_085
    		DataSource PUBLIC
    TY_086
    		DataSourceChartProperties PUBLIC
    TY_087
    		DataSourceColumn PUBLIC
    TY_088
    		DataSourceColumnReference PUBLIC
    TY_089
    		DataSourceFormula PUBLIC
    TY_090
    		DataSourceObjectReference PUBLIC
    TY_091
    		DataSourceObjectReferences PUBLIC
    TY_092
    		DataSourceParameter PUBLIC
    TY_093
    		DataSourceRefreshDailySchedule PUBLIC
    TY_094
    		DataSourceRefreshMonthlySchedule PUBLIC
    TY_095
    		DataSourceRefreshSchedule PUBLIC
    TY_096
    		DataSourceRefreshWeeklySchedule PUBLIC
    TY_097
    		DataSourceSheetDimensionRange PUBLIC
    TY_098
    		DataSourceSheetProperties PUBLIC
    TY_099
    		DataSourceSpec PUBLIC
    TY_100
    		DataSourceTable PUBLIC
    TY_101
    		DataValidationRule PUBLIC
    TY_102
    		DateTimeRule PUBLIC
    TY_103
    		DeleteBandingRequest PUBLIC
    TY_104
    		DeleteConditionalFormatRuleRequest PUBLIC
    TY_105
    		DeleteConditionalFormatRuleResponse PUBLIC
    TY_106
    		DeleteDataSourceRequest PUBLIC
    TY_107
    		DeleteDeveloperMetadataRequest PUBLIC
    TY_108
    		DeleteDeveloperMetadataResponse PUBLIC
    TY_109
    		DeleteDimensionGroupRequest PUBLIC
    TY_110
    		DeleteDimensionGroupResponse PUBLIC
    TY_111
    		DeleteDimensionRequest PUBLIC
    TY_112
    		DeleteDuplicatesRequest PUBLIC
    TY_113
    		DeleteDuplicatesResponse PUBLIC
    TY_114
    		DeleteEmbeddedObjectRequest PUBLIC
    TY_115
    		DeleteFilterViewRequest PUBLIC
    TY_116
    		DeleteNamedRangeRequest PUBLIC
    TY_117
    		DeleteProtectedRangeRequest PUBLIC
    TY_118
    		DeleteRangeRequest PUBLIC
    TY_119
    		DeleteSheetRequest PUBLIC
    TY_120
    		DeveloperMetadata PUBLIC
    TY_121
    		DeveloperMetadataLocation PUBLIC
    TY_122
    		DeveloperMetadataLookup PUBLIC
    TY_123
    		DimensionGroup PUBLIC
    TY_124
    		DimensionProperties PUBLIC
    TY_125
    		DimensionRange PUBLIC
    TY_126
    		DuplicateFilterViewRequest PUBLIC
    TY_127
    		DuplicateFilterViewResponse PUBLIC
    TY_128
    		DuplicateSheetRequest PUBLIC
    TY_129
    		DuplicateSheetResponse PUBLIC
    TY_130
    		Editors PUBLIC
    TY_131
    		EmbeddedChart PUBLIC
    TY_132
    		EmbeddedObjectBorder PUBLIC
    TY_133
    		EmbeddedObjectPosition PUBLIC
    TY_134
    		ErrorValue PUBLIC
    TY_135
    		ExtendedValue PUBLIC
    TY_136
    		FilterCriteria PUBLIC
    TY_137
    		FilterSpec PUBLIC
    TY_138
    		FilterView PUBLIC
    TY_139
    		FindReplaceRequest PUBLIC
    TY_140
    		FindReplaceResponse PUBLIC
    TY_141
    		GetSpreadsheetByDataFilterRequest PUBLIC
    TY_142
    		GradientRule PUBLIC
    TY_143
    		GridCoordinate PUBLIC
    TY_144
    		GridData PUBLIC
    TY_145
    		GridProperties PUBLIC
    TY_146
    		GridRange PUBLIC
    TY_147
    		HistogramChartSpec PUBLIC
    TY_148
    		HistogramRule PUBLIC
    TY_149
    		HistogramSeries PUBLIC
    TY_150
    		InsertDimensionRequest PUBLIC
    TY_151
    		InsertRangeRequest PUBLIC
    TY_152
    		InterpolationPoint PUBLIC
    TY_153
    		Interval PUBLIC
    TY_154
    		IterativeCalculationSettings PUBLIC
    TY_155
    		KeyValueFormat PUBLIC
    TY_156
    		LineStyle PUBLIC
    TY_157
    		Link PUBLIC
    TY_158
    		ManualRule PUBLIC
    TY_159
    		ManualRuleGroup PUBLIC
    TY_160
    		MatchedDeveloperMetadata PUBLIC
    TY_161
    		MatchedValueRange PUBLIC
    TY_162
    		MergeCellsRequest PUBLIC
    TY_163
    		MoveDimensionRequest PUBLIC
    TY_164
    		NamedRange PUBLIC
    TY_165
    		NumberFormat PUBLIC
    TY_166
    		OrgChartSpec PUBLIC
    TY_167
    		OverlayPosition PUBLIC
    TY_168
    		Padding PUBLIC
    TY_169
    		PasteDataRequest PUBLIC
    TY_170
    		PieChartSpec PUBLIC
    TY_171
    		PivotFilterCriteria PUBLIC
    TY_172
    		PivotFilterSpec PUBLIC
    TY_173
    		PivotGroup PUBLIC
    TY_174
    		PivotGroupLimit PUBLIC
    TY_175
    		PivotGroupRule PUBLIC
    TY_176
    		PivotGroupSortValueBucket PUBLIC
    TY_177
    		PivotGroupValueMetadata PUBLIC
    TY_178
    		PivotTable PUBLIC
    TY_179
    		PivotValue PUBLIC
    TY_180
    		PointStyle PUBLIC
    TY_181
    		ProtectedRange PUBLIC
    TY_182
    		RandomizeRangeRequest PUBLIC
    TY_183
    		RefreshDataSourceObjectExecutionStatus PUBLIC
    TY_184
    		RefreshDataSourceRequest PUBLIC
    TY_185
    		RefreshDataSourceResponse PUBLIC
    TY_186
    		RepeatCellRequest PUBLIC
    TY_187
    		Request PUBLIC
    TY_188
    		Response PUBLIC
    TY_189
    		RowData PUBLIC
    TY_190
    		ScorecardChartSpec PUBLIC
    TY_191
    		SearchDeveloperMetadataRequest PUBLIC
    TY_192
    		SearchDeveloperMetadataResponse PUBLIC
    TY_193
    		SetBasicFilterRequest PUBLIC
    TY_194
    		SetDataValidationRequest PUBLIC
    TY_195
    		Sheet PUBLIC
    TY_196
    		SheetProperties PUBLIC
    TY_197
    		Slicer PUBLIC
    TY_198
    		SlicerSpec PUBLIC
    TY_199
    		SortRangeRequest PUBLIC
    TY_200
    		SortSpec PUBLIC
    TY_201
    		SourceAndDestination PUBLIC
    TY_202
    		Spreadsheet PUBLIC
    TY_203
    		SpreadsheetProperties PUBLIC
    TY_204
    		SpreadsheetTheme PUBLIC
    TY_205
    		TextFormat PUBLIC
    TY_206
    		TextFormatRun PUBLIC
    TY_207
    		TextPosition PUBLIC
    TY_208
    		TextRotation PUBLIC
    TY_209
    		TextToColumnsRequest PUBLIC
    TY_210
    		ThemeColorPair PUBLIC
    TY_211
    		TimeOfDay PUBLIC
    TY_212
    		TreemapChartColorScale PUBLIC
    TY_213
    		TreemapChartSpec PUBLIC
    TY_214
    		TrimWhitespaceRequest PUBLIC
    TY_215
    		TrimWhitespaceResponse PUBLIC
    TY_216
    		UnmergeCellsRequest PUBLIC
    TY_217
    		UpdateBandingRequest PUBLIC
    TY_218
    		UpdateBordersRequest PUBLIC
    TY_219
    		UpdateCellsRequest PUBLIC
    TY_220
    		UpdateChartSpecRequest PUBLIC
    TY_221
    		UpdateConditionalFormatRuleRequest PUBLIC
    TY_222
    		UpdateConditionalFormatRuleResponse PUBLIC
    TY_223
    		UpdateDataSourceRequest PUBLIC
    TY_224
    		UpdateDataSourceResponse PUBLIC
    TY_225
    		UpdateDeveloperMetadataRequest PUBLIC
    TY_226
    		UpdateDeveloperMetadataResponse PUBLIC
    TY_227
    		UpdateDimensionGroupRequest PUBLIC
    TY_228
    		UpdateDimensionPropertiesRequest PUBLIC
    TY_229
    		UpdateEmbeddedObjectBorderRequest PUBLIC
    TY_230
    		UpdateEmbeddedObjectPositionRequest PUBLIC
    TY_231
    		UpdateEmbeddedObjectPositionResponse PUBLIC
    TY_232
    		UpdateFilterViewRequest PUBLIC
    TY_233
    		UpdateNamedRangeRequest PUBLIC
    TY_234
    		UpdateProtectedRangeRequest PUBLIC
    TY_235
    		UpdateSheetPropertiesRequest PUBLIC
    TY_236
    		UpdateSlicerSpecRequest PUBLIC
    TY_237
    		UpdateSpreadsheetPropertiesRequest PUBLIC
    TY_238
    		UpdateValuesByDataFilterResponse PUBLIC
    TY_239
    		UpdateValuesResponse PUBLIC
    TY_240
    		ValueRange PUBLIC
    TY_241
    		WaterfallChartColumnStyle PUBLIC
    TY_242
    		WaterfallChartCustomSubtotal PUBLIC
    TY_243
    		WaterfallChartDomain PUBLIC
    TY_244
    		WaterfallChartSeries PUBLIC
    TY_245
    		WaterfallChartSpec PUBLIC
    TY_246
    		CancelDataSourceRefreshRequest PUBLIC
    TY_247
    		CancelDataSourceRefreshResponse PUBLIC
    TY_248
    		CancelDataSourceRefreshStatus PUBLIC
    TY_249
    		RefreshCancellationStatus PUBLIC
    TY_250
    		LookerDataSourceSpec PUBLIC
    TY_T_025
    		BandedRange PUBLIC
    TY_T_028
    		BasicChartAxis PUBLIC
    TY_T_029
    		BasicChartDomain PUBLIC
    TY_T_030
    		BasicChartSeries PUBLIC
    TY_T_033
    		BasicSeriesDataPointStyleOverride PUBLIC
    TY_T_056
    		CandlestickData PUBLIC
    TY_T_059
    		CellData PUBLIC
    TY_T_074
    		ConditionValue PUBLIC
    TY_T_075
    		ConditionalFormatRule PUBLIC
    TY_T_082
    		DataFilter PUBLIC
    TY_T_083
    		DataFilterValueRange PUBLIC
    TY_T_085
    		DataSource PUBLIC
    TY_T_087
    		DataSourceColumn PUBLIC
    TY_T_088
    		DataSourceColumnReference PUBLIC
    TY_T_090
    		DataSourceObjectReference PUBLIC
    TY_T_092
    		DataSourceParameter PUBLIC
    TY_T_095
    		DataSourceRefreshSchedule PUBLIC
    TY_T_120
    		DeveloperMetadata PUBLIC
    TY_T_123
    		DimensionGroup PUBLIC
    TY_T_124
    		DimensionProperties PUBLIC
    TY_T_125
    		DimensionRange PUBLIC
    TY_T_131
    		EmbeddedChart PUBLIC
    TY_T_135
    		ExtendedValue PUBLIC
    TY_T_137
    		FilterSpec PUBLIC
    TY_T_138
    		FilterView PUBLIC
    TY_T_144
    		GridData PUBLIC
    TY_T_146
    		GridRange PUBLIC
    TY_T_149
    		HistogramSeries PUBLIC
    TY_T_159
    		ManualRuleGroup PUBLIC
    TY_T_160
    		MatchedDeveloperMetadata PUBLIC
    TY_T_161
    		MatchedValueRange PUBLIC
    TY_T_164
    		NamedRange PUBLIC
    TY_T_172
    		PivotFilterSpec PUBLIC
    TY_T_173
    		PivotGroup PUBLIC
    TY_T_177
    		PivotGroupValueMetadata PUBLIC
    TY_T_179
    		PivotValue PUBLIC
    TY_T_181
    		ProtectedRange PUBLIC
    TY_T_183
    		RefreshDataSourceObjectExecutionStatus PUBLIC
    TY_T_187
    		Request PUBLIC
    TY_T_188
    		Response PUBLIC
    TY_T_189
    		RowData PUBLIC
    TY_T_195
    		Sheet PUBLIC
    TY_T_197
    		Slicer PUBLIC
    TY_T_200
    		SortSpec PUBLIC
    TY_T_206
    		TextFormatRun PUBLIC
    TY_T_210
    		ThemeColorPair PUBLIC
    TY_T_238
    		UpdateValuesByDataFilterResponse PUBLIC
    TY_T_239
    		UpdateValuesResponse PUBLIC
    TY_T_240
    		ValueRange PUBLIC
    TY_T_242
    		WaterfallChartCustomSubtotal PUBLIC
    TY_T_244
    		WaterfallChartSeries PUBLIC
    TY_T_248
    		CancelDataSourceRefreshStatus PUBLIC
    TY_T_INT4
    		Table of Integers PUBLIC
    TY_T_STRING
    		Table of Strings PUBLIC

    Constants

    Name Type Description Value Visibility
    C_SUPPORTED_AUTH
    		/GOOG/SUPP_AUTH Supported Auth Types OOIJWW PUBLIC
    C_SERVICE_NAME
    		/GOOG/SERVICE_NAME Google Service Name sheets:v4 PUBLIC
    C_ROOT_URL
    		STRING API Root URL https://sheets.googleapis.com PUBLIC
    C_REVISION_DATE
    		DATUM Discovery Document revision Date 20241112 PUBLIC
    C_PATH_PREFIX
    		STRING API Path Prefix PUBLIC
    C_ON_PREM_VERSION
    		/GOOG/SDK_VERSION Lowest On-premises Version 1.5 PUBLIC
    C_CLOUD_VERSION
    		/GOOG/SDK_VERSION Lowest Cloud Version 1.0 PUBLIC

    Methods

    For general information about a method in ABAP SDK for Google Cloud, see API method .

    CONSTRUCTOR

    • Description: Constructor
    • Visibility: PUBLIC

    Parameters

    Name Category Type Description
    IV_KEY_NAME
    		IMPORTING /GOOG/KEYNAME Google Cloud Key Name
    IV_LOG_OBJ
    		IMPORTING BALOBJ_D Application log: Object name (Application code)
    IV_LOG_SUBOBJ
    		IMPORTING BALSUBOBJ Application Log: Subobject

    Exception

    Name Description
    /GOOG/CX_SDK ABAP SDK for Google Cloud: Exception Class

    APPEND_VALUES

    • Description: sheets.spreadsheets.values.append
    • Visibility: PUBLIC

    Parameters

    Name Category Type Description
    IV_Q_INCLUDEVALUESINRESPONSE
    		IMPORTING STRING includeValuesInResponse
    IV_Q_INSERTDATAOPTION
    		IMPORTING STRING insertDataOption
    IV_Q_RESPONSEDATETIMERENDEROPT
    		IMPORTING STRING responseDateTimeRenderOption
    IV_Q_RESPONSEVALUERENDEROPTION
    		IMPORTING STRING responseValueRenderOption
    IV_Q_VALUEINPUTOPTION
    		IMPORTING STRING valueInputOption
    IV_P_RANGE
    		IMPORTING STRING range
    IV_P_SPREADSHEET_ID
    		IMPORTING STRING spreadsheetId
    IS_INPUT
    		IMPORTING TY_240 ValueRange
    ES_RAW
    		EXPORTING DATA Raw Output Data
    ES_OUTPUT
    		EXPORTING TY_022 AppendValuesResponse
    EV_RET_CODE
    		EXPORTING I Return Code
    EV_ERR_TEXT
    		EXPORTING STRING Error Text
    ES_ERR_RESP
    		EXPORTING /GOOG/ERR_RESP Error Response

    Exception

    Name Description
    /GOOG/CX_SDK ABAP SDK for Google Cloud: Exception Class

    BATCH_CLEAR_BY_DATA_FILTER

    • Description: sheets.spreadsheets.values.batchClearByDataFilter
    • Visibility: PUBLIC

    Parameters

    Name Category Type Description
    IV_P_SPREADSHEET_ID
    		IMPORTING STRING spreadsheetId
    IS_INPUT
    		IMPORTING TY_034 BatchClearValuesByDataFilterRequest
    ES_RAW
    		EXPORTING DATA Raw Output Data
    ES_OUTPUT
    		EXPORTING TY_035 BatchClearValuesByDataFilterResponse
    EV_RET_CODE
    		EXPORTING I Return Code
    EV_ERR_TEXT
    		EXPORTING STRING Error Text
    ES_ERR_RESP
    		EXPORTING /GOOG/ERR_RESP Error Response

    Exception

    Name Description
    /GOOG/CX_SDK ABAP SDK for Google Cloud: Exception Class

    BATCH_CLEAR_VALUES

    • Description: sheets.spreadsheets.values.batchClear
    • Visibility: PUBLIC

    Parameters

    Name Category Type Description
    IV_P_SPREADSHEET_ID
    		IMPORTING STRING spreadsheetId
    IS_INPUT
    		IMPORTING TY_036 BatchClearValuesRequest
    ES_RAW
    		EXPORTING DATA Raw Output Data
    ES_OUTPUT
    		EXPORTING TY_037 BatchClearValuesResponse
    EV_RET_CODE
    		EXPORTING I Return Code
    EV_ERR_TEXT
    		EXPORTING STRING Error Text
    ES_ERR_RESP
    		EXPORTING /GOOG/ERR_RESP Error Response

    Exception

    Name Description
    /GOOG/CX_SDK ABAP SDK for Google Cloud: Exception Class

    BATCH_GET_BY_DATA_FILTER_VA

    • Description: sheets.spreadsheets.values.batchGetByDataFilter
    • Visibility: PUBLIC

    Parameters

    Name Category Type Description
    IV_P_SPREADSHEET_ID
    		IMPORTING STRING spreadsheetId
    IS_INPUT
    		IMPORTING TY_038 BatchGetValuesByDataFilterRequest
    ES_RAW
    		EXPORTING DATA Raw Output Data
    ES_OUTPUT
    		EXPORTING TY_039 BatchGetValuesByDataFilterResponse
    EV_RET_CODE
    		EXPORTING I Return Code
    EV_ERR_TEXT
    		EXPORTING STRING Error Text
    ES_ERR_RESP
    		EXPORTING /GOOG/ERR_RESP Error Response

    Exception

    Name Description
    /GOOG/CX_SDK ABAP SDK for Google Cloud: Exception Class

    BATCH_GET_VALUES

    • Description: sheets.spreadsheets.values.batchGet
    • Visibility: PUBLIC

    Parameters

    Name Category Type Description
    IV_Q_DATETIMERENDEROPTION
    		IMPORTING STRING dateTimeRenderOption
    IV_Q_MAJORDIMENSION
    		IMPORTING STRING majorDimension
    IV_Q_RANGES
    		IMPORTING STRING ranges
    IV_Q_VALUERENDEROPTION
    		IMPORTING STRING valueRenderOption
    IV_P_SPREADSHEET_ID
    		IMPORTING STRING spreadsheetId
    ES_RAW
    		EXPORTING DATA Raw Output Data
    ES_OUTPUT
    		EXPORTING TY_040 BatchGetValuesResponse
    EV_RET_CODE
    		EXPORTING I Return Code
    EV_ERR_TEXT
    		EXPORTING STRING Error Text
    ES_ERR_RESP
    		EXPORTING /GOOG/ERR_RESP Error Response

    Exception

    Name Description
    /GOOG/CX_SDK ABAP SDK for Google Cloud: Exception Class

    BATCH_UPDATE_BY_DATA_FILTER

    • Description: sheets.spreadsheets.values.batchUpdateByDataFilter
    • Visibility: PUBLIC

    Parameters

    Name Category Type Description
    IV_P_SPREADSHEET_ID
    		IMPORTING STRING spreadsheetId
    IS_INPUT
    		IMPORTING TY_043 BatchUpdateValuesByDataFilterRequest
    ES_RAW
    		EXPORTING DATA Raw Output Data
    ES_OUTPUT
    		EXPORTING TY_044 BatchUpdateValuesByDataFilterResponse
    EV_RET_CODE
    		EXPORTING I Return Code
    EV_ERR_TEXT
    		EXPORTING STRING Error Text
    ES_ERR_RESP
    		EXPORTING /GOOG/ERR_RESP Error Response

    Exception

    Name Description
    /GOOG/CX_SDK ABAP SDK for Google Cloud: Exception Class

    BATCH_UPDATE_SPREADSHEETS

    • Description: sheets.spreadsheets.batchUpdate
    • Visibility: PUBLIC

    Parameters

    Name Category Type Description
    IV_P_SPREADSHEET_ID
    		IMPORTING STRING spreadsheetId
    IS_INPUT
    		IMPORTING TY_041 BatchUpdateSpreadsheetRequest
    ES_RAW
    		EXPORTING DATA Raw Output Data
    ES_OUTPUT
    		EXPORTING TY_042 BatchUpdateSpreadsheetResponse
    EV_RET_CODE
    		EXPORTING I Return Code
    EV_ERR_TEXT
    		EXPORTING STRING Error Text
    ES_ERR_RESP
    		EXPORTING /GOOG/ERR_RESP Error Response

    Exception

    Name Description
    /GOOG/CX_SDK ABAP SDK for Google Cloud: Exception Class

    BATCH_UPDATE_VALUES

    • Description: sheets.spreadsheets.values.batchUpdate
    • Visibility: PUBLIC

    Parameters

    Name Category Type Description
    IV_P_SPREADSHEET_ID
    		IMPORTING STRING spreadsheetId
    IS_INPUT
    		IMPORTING TY_045 BatchUpdateValuesRequest
    ES_RAW
    		EXPORTING DATA Raw Output Data
    ES_OUTPUT
    		EXPORTING TY_046 BatchUpdateValuesResponse
    EV_RET_CODE
    		EXPORTING I Return Code
    EV_ERR_TEXT
    		EXPORTING STRING Error Text
    ES_ERR_RESP
    		EXPORTING /GOOG/ERR_RESP Error Response

    Exception

    Name Description
    /GOOG/CX_SDK ABAP SDK for Google Cloud: Exception Class

    CLEAR_VALUES

    • Description: sheets.spreadsheets.values.clear
    • Visibility: PUBLIC

    Parameters

    Name Category Type Description
    IV_P_RANGE
    		IMPORTING STRING range
    IV_P_SPREADSHEET_ID
    		IMPORTING STRING spreadsheetId
    IS_INPUT
    		IMPORTING DATA Input Data
    ES_RAW
    		EXPORTING DATA Raw Output Data
    ES_OUTPUT
    		EXPORTING TY_071 ClearValuesResponse
    EV_RET_CODE
    		EXPORTING I Return Code
    EV_ERR_TEXT
    		EXPORTING STRING Error Text
    ES_ERR_RESP
    		EXPORTING /GOOG/ERR_RESP Error Response

    Exception

    Name Description
    /GOOG/CX_SDK ABAP SDK for Google Cloud: Exception Class

    COPY_TO_SHEETS

    • Description: sheets.spreadsheets.sheets.copyTo
    • Visibility: PUBLIC

    Parameters

    Name Category Type Description
    IV_P_SHEET_ID
    		IMPORTING STRING sheetId
    IV_P_SPREADSHEET_ID
    		IMPORTING STRING spreadsheetId
    IS_INPUT
    		IMPORTING TY_077 CopySheetToAnotherSpreadsheetRequest
    ES_RAW
    		EXPORTING DATA Raw Output Data
    ES_OUTPUT
    		EXPORTING TY_196 SheetProperties
    EV_RET_CODE
    		EXPORTING I Return Code
    EV_ERR_TEXT
    		EXPORTING STRING Error Text
    ES_ERR_RESP
    		EXPORTING /GOOG/ERR_RESP Error Response

    Exception

    Name Description
    /GOOG/CX_SDK ABAP SDK for Google Cloud: Exception Class

    CREATE_SPREADSHEETS

    • Description: sheets.spreadsheets.create
    • Visibility: PUBLIC

    Parameters

    Name Category Type Description
    IS_INPUT
    		IMPORTING TY_202 Spreadsheet
    ES_RAW
    		EXPORTING DATA Raw Output Data
    ES_OUTPUT
    		EXPORTING TY_202 Spreadsheet
    EV_RET_CODE
    		EXPORTING I Return Code
    EV_ERR_TEXT
    		EXPORTING STRING Error Text
    ES_ERR_RESP
    		EXPORTING /GOOG/ERR_RESP Error Response

    Exception

    Name Description
    /GOOG/CX_SDK ABAP SDK for Google Cloud: Exception Class

    GET_BY_DATA_FILTER_SPREADSH

    • Description: sheets.spreadsheets.getByDataFilter
    • Visibility: PUBLIC

    Parameters

    Name Category Type Description
    IV_P_SPREADSHEET_ID
    		IMPORTING STRING spreadsheetId
    IS_INPUT
    		IMPORTING TY_141 GetSpreadsheetByDataFilterRequest
    ES_RAW
    		EXPORTING DATA Raw Output Data
    ES_OUTPUT
    		EXPORTING TY_202 Spreadsheet
    EV_RET_CODE
    		EXPORTING I Return Code
    EV_ERR_TEXT
    		EXPORTING STRING Error Text
    ES_ERR_RESP
    		EXPORTING /GOOG/ERR_RESP Error Response

    Exception

    Name Description
    /GOOG/CX_SDK ABAP SDK for Google Cloud: Exception Class

    GET_DEVELOPER_METADATA

    • Description: sheets.spreadsheets.developerMetadata.get
    • Visibility: PUBLIC

    Parameters

    Name Category Type Description
    IV_P_METADATA_ID
    		IMPORTING STRING metadataId
    IV_P_SPREADSHEET_ID
    		IMPORTING STRING spreadsheetId
    ES_RAW
    		EXPORTING DATA Raw Output Data
    ES_OUTPUT
    		EXPORTING TY_120 DeveloperMetadata
    EV_RET_CODE
    		EXPORTING I Return Code
    EV_ERR_TEXT
    		EXPORTING STRING Error Text
    ES_ERR_RESP
    		EXPORTING /GOOG/ERR_RESP Error Response

    Exception

    Name Description
    /GOOG/CX_SDK ABAP SDK for Google Cloud: Exception Class

    GET_SPREADSHEETS

    • Description: sheets.spreadsheets.get
    • Visibility: PUBLIC

    Parameters

    Name Category Type Description
    IV_Q_INCLUDEGRIDDATA
    		IMPORTING STRING includeGridData
    IV_Q_RANGES
    		IMPORTING STRING ranges
    IV_P_SPREADSHEET_ID
    		IMPORTING STRING spreadsheetId
    ES_RAW
    		EXPORTING DATA Raw Output Data
    ES_OUTPUT
    		EXPORTING TY_202 Spreadsheet
    EV_RET_CODE
    		EXPORTING I Return Code
    EV_ERR_TEXT
    		EXPORTING STRING Error Text
    ES_ERR_RESP
    		EXPORTING /GOOG/ERR_RESP Error Response

    Exception

    Name Description
    /GOOG/CX_SDK ABAP SDK for Google Cloud: Exception Class

    GET_VALUES

    • Description: sheets.spreadsheets.values.get
    • Visibility: PUBLIC

    Parameters

    Name Category Type Description
    IV_Q_DATETIMERENDEROPTION
    		IMPORTING STRING dateTimeRenderOption
    IV_Q_MAJORDIMENSION
    		IMPORTING STRING majorDimension
    IV_Q_VALUERENDEROPTION
    		IMPORTING STRING valueRenderOption
    IV_P_RANGE
    		IMPORTING STRING range
    IV_P_SPREADSHEET_ID
    		IMPORTING STRING spreadsheetId
    ES_RAW
    		EXPORTING DATA Raw Output Data
    ES_OUTPUT
    		EXPORTING TY_240 ValueRange
    EV_RET_CODE
    		EXPORTING I Return Code
    EV_ERR_TEXT
    		EXPORTING STRING Error Text
    ES_ERR_RESP
    		EXPORTING /GOOG/ERR_RESP Error Response

    Exception

    Name Description
    /GOOG/CX_SDK ABAP SDK for Google Cloud: Exception Class

    SEARCH_DEVELOPER_METADATA

    • Description: sheets.spreadsheets.developerMetadata.search
    • Visibility: PUBLIC

    Parameters

    Name Category Type Description
    IV_P_SPREADSHEET_ID
    		IMPORTING STRING spreadsheetId
    IS_INPUT
    		IMPORTING TY_191 SearchDeveloperMetadataRequest
    ES_RAW
    		EXPORTING DATA Raw Output Data
    ES_OUTPUT
    		EXPORTING TY_192 SearchDeveloperMetadataResponse
    EV_RET_CODE
    		EXPORTING I Return Code
    EV_ERR_TEXT
    		EXPORTING STRING Error Text
    ES_ERR_RESP
    		EXPORTING /GOOG/ERR_RESP Error Response

    Exception

    Name Description
    /GOOG/CX_SDK ABAP SDK for Google Cloud: Exception Class

    UPDATE_VALUES

    • Description: sheets.spreadsheets.values.update
    • Visibility: PUBLIC

    Parameters

    Name Category Type Description
    IV_Q_INCLUDEVALUESINRESPONSE
    		IMPORTING STRING includeValuesInResponse
    IV_Q_RESPONSEDATETIMERENDEROPT
    		IMPORTING STRING responseDateTimeRenderOption
    IV_Q_RESPONSEVALUERENDEROPTION
    		IMPORTING STRING responseValueRenderOption
    IV_Q_VALUEINPUTOPTION
    		IMPORTING STRING valueInputOption
    IV_P_RANGE
    		IMPORTING STRING range
    IV_P_SPREADSHEET_ID
    		IMPORTING STRING spreadsheetId
    IS_INPUT
    		IMPORTING TY_240 ValueRange
    ES_RAW
    		EXPORTING DATA Raw Output Data
    ES_OUTPUT
    		EXPORTING TY_239 UpdateValuesResponse
    EV_RET_CODE
    		EXPORTING I Return Code
    EV_ERR_TEXT
    		EXPORTING STRING Error Text
    ES_ERR_RESP
    		EXPORTING /GOOG/ERR_RESP Error Response

    Exception

    Name Description
    /GOOG/CX_SDK ABAP SDK for Google Cloud: Exception Class

    CLOSE

    • Description: Close Connection
    • Visibility: PUBLIC
    Design a Mobile Site
    View Site in Mobile | Classic
    Share by: