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