Classe /GOOG/CL_SHEETS_V4

Classe


 /GOOG/CL_SHEETS_V4

Héritage de : /GOOG/CL_HTTP_CLIENT
Description : Google Sheets API v4

Pour obtenir des informations générales sur une classe du SDK ABAP pour Google Cloud, consultez la page Bouchon de client API.

Types

Type	Description	Visibilité
`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_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_INT4`	`Table of Integers`	PUBLIC
`TY_T_STRING`	`Table of Strings`	PUBLIC

Constantes

Nom	Type	Description	Valeur	Visibilité
`C_SUPPORTED_AUTH`	`/GOOG/SUPP_AUTH`	Types d'authentification pris en charge	OOIJWW	PUBLIC
`C_SERVICE_NAME`	`/GOOG/SERVICE_NAME`	Nom du service Google	sheets:v4	PUBLIC
`C_ROOT_URL`	`STRING`	URL racine de l'API	https://sheets.googleapis.com	PUBLIC
`C_REVISION_DATE`	`DATUM`	Date de révision du document de découverte	20240318	PUBLIC
`C_PATH_PREFIX`	`STRING`	Préfixe de chemin d'API		PUBLIC
`C_ON_PREM_VERSION`	`/GOOG/SDK_VERSION`	Version sur site la plus basse	1.5	PUBLIC
`C_CLOUD_VERSION`	`/GOOG/SDK_VERSION`	Version Cloud la plus basse	1.0	PUBLIC

Méthodes

Pour obtenir des informations générales sur une méthode du SDK ABAP pour Google Cloud, consultez la page Méthode API.

CONSTRUCTOR

Description : Constructor
Visibilité : PUBLIQUE

Paramètres

Nom	Catégorie	Type	Description
`IV_KEY_NAME`	IMPORTING	`/GOOG/KEYNAME`	Nom de la clé Google Cloud
`IV_LOG_OBJ`	IMPORTING	`BALOBJ_D`	Journal d'application : nom de l'objet (code d'application)
`IV_LOG_SUBOBJ`	IMPORTING	`BALSUBOBJ`	Journal d'application : sous-objet

Exception

Nom	Description
`/GOOG/CX_SDK`	SDK ABAP pour Google Cloud : classe d'exception

APPEND_VALUES

Description : sheets.spreadsheets.values.append
Visibility: Public

Paramètres

Nom	Catégorie	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`	Données brutes de sortie
`ES_OUTPUT`	EXPORTING	`TY_022`	AppendValuesResponse
`EV_RET_CODE`	EXPORTING	`I`	Code renvoyé
`EV_ERR_TEXT`	EXPORTING	`STRING`	Texte de l'erreur
`ES_ERR_RESP`	EXPORTING	`/GOOG/ERR_RESP`	Réponse d'erreur

Exception

Nom	Description
`/GOOG/CX_SDK`	SDK ABAP pour Google Cloud : classe d'exception

BATCH_CLEAR_BY_DATA_FILTER

Description : sheets.spreadsheets.values.batchClearByDataFilter
Visibility: Public

Paramètres

Nom	Catégorie	Type	Description
`IV_P_SPREADSHEET_ID`	IMPORTING	`STRING`	spreadsheetId
`IS_INPUT`	IMPORTING	`TY_034`	BatchClearValuesByDataFilterRequest
`ES_RAW`	EXPORTING	`DATA`	Données brutes de sortie
`ES_OUTPUT`	EXPORTING	`TY_035`	BatchClearValuesByDataFilterResponse
`EV_RET_CODE`	EXPORTING	`I`	Code renvoyé
`EV_ERR_TEXT`	EXPORTING	`STRING`	Texte de l'erreur
`ES_ERR_RESP`	EXPORTING	`/GOOG/ERR_RESP`	Réponse d'erreur

Exception

Nom	Description
`/GOOG/CX_SDK`	SDK ABAP pour Google Cloud : classe d'exception

BATCH_CLEAR_VALUES

Description : sheets.spreadsheets.values.batchClear
Visibility: Public

Paramètres

Nom	Catégorie	Type	Description
`IV_P_SPREADSHEET_ID`	IMPORTING	`STRING`	spreadsheetId
`IS_INPUT`	IMPORTING	`TY_036`	BatchClearValuesRequest
`ES_RAW`	EXPORTING	`DATA`	Données brutes de sortie
`ES_OUTPUT`	EXPORTING	`TY_037`	BatchClearValuesResponse
`EV_RET_CODE`	EXPORTING	`I`	Code renvoyé
`EV_ERR_TEXT`	EXPORTING	`STRING`	Texte de l'erreur
`ES_ERR_RESP`	EXPORTING	`/GOOG/ERR_RESP`	Réponse d'erreur

Exception

Nom	Description
`/GOOG/CX_SDK`	SDK ABAP pour Google Cloud : classe d'exception

BATCH_GET_BY_DATA_FILTER_VA

Description : sheets.spreadsheets.values.batchGetByDataFilter
Visibility: Public

Paramètres

Nom	Catégorie	Type	Description
`IV_P_SPREADSHEET_ID`	IMPORTING	`STRING`	spreadsheetId
`IS_INPUT`	IMPORTING	`TY_038`	BatchGetValuesByDataFilterRequest
`ES_RAW`	EXPORTING	`DATA`	Données brutes de sortie
`ES_OUTPUT`	EXPORTING	`TY_039`	BatchGetValuesByDataFilterResponse
`EV_RET_CODE`	EXPORTING	`I`	Code renvoyé
`EV_ERR_TEXT`	EXPORTING	`STRING`	Texte de l'erreur
`ES_ERR_RESP`	EXPORTING	`/GOOG/ERR_RESP`	Réponse d'erreur

Exception

Nom	Description
`/GOOG/CX_SDK`	SDK ABAP pour Google Cloud : classe d'exception

BATCH_GET_VALUES

Description : sheets.spreadsheets.values.batchGet
Visibility: Public

Paramètres

Nom	Catégorie	Type	Description
`IV_Q_DATETIMERENDEROPTION`	IMPORTING	`STRING`	dateTimeRenderOption
`IV_Q_MAJORDIMENSION`	IMPORTING	`STRING`	majorDimension
`IV_Q_RANGES`	IMPORTING	`STRING`	Plages
`IV_Q_VALUERENDEROPTION`	IMPORTING	`STRING`	valueRenderOption
`IV_P_SPREADSHEET_ID`	IMPORTING	`STRING`	spreadsheetId
`ES_RAW`	EXPORTING	`DATA`	Données brutes de sortie
`ES_OUTPUT`	EXPORTING	`TY_040`	BatchGetValuesResponse
`EV_RET_CODE`	EXPORTING	`I`	Code renvoyé
`EV_ERR_TEXT`	EXPORTING	`STRING`	Texte de l'erreur
`ES_ERR_RESP`	EXPORTING	`/GOOG/ERR_RESP`	Réponse d'erreur

Exception

Nom	Description
`/GOOG/CX_SDK`	SDK ABAP pour Google Cloud : classe d'exception

BATCH_UPDATE_BY_DATA_FILTER

Description : sheets.spreadsheets.values.batchUpdateByDataFilter
Visibility: Public

Paramètres

Nom	Catégorie	Type	Description
`IV_P_SPREADSHEET_ID`	IMPORTING	`STRING`	spreadsheetId
`IS_INPUT`	IMPORTING	`TY_043`	BatchUpdateValuesByDataFilterRequest
`ES_RAW`	EXPORTING	`DATA`	Données brutes de sortie
`ES_OUTPUT`	EXPORTING	`TY_044`	BatchUpdateValuesByDataFilterResponse
`EV_RET_CODE`	EXPORTING	`I`	Code renvoyé
`EV_ERR_TEXT`	EXPORTING	`STRING`	Texte de l'erreur
`ES_ERR_RESP`	EXPORTING	`/GOOG/ERR_RESP`	Réponse d'erreur

Exception

Nom	Description
`/GOOG/CX_SDK`	SDK ABAP pour Google Cloud : classe d'exception

BATCH_UPDATE_SPREADSHEETS

Description : sheets.spreadsheets.batchUpdate
Visibility: Public

Paramètres

Nom	Catégorie	Type	Description
`IV_P_SPREADSHEET_ID`	IMPORTING	`STRING`	spreadsheetId
`IS_INPUT`	IMPORTING	`TY_041`	BatchUpdateSpreadsheetRequest
`ES_RAW`	EXPORTING	`DATA`	Données brutes de sortie
`ES_OUTPUT`	EXPORTING	`TY_042`	BatchUpdateSpreadsheetResponse
`EV_RET_CODE`	EXPORTING	`I`	Code renvoyé
`EV_ERR_TEXT`	EXPORTING	`STRING`	Texte de l'erreur
`ES_ERR_RESP`	EXPORTING	`/GOOG/ERR_RESP`	Réponse d'erreur

Exception

Nom	Description
`/GOOG/CX_SDK`	SDK ABAP pour Google Cloud : classe d'exception

BATCH_UPDATE_VALUES

Description : sheets.spreadsheets.values.batchUpdate
Visibility: Public

Paramètres

Nom	Catégorie	Type	Description
`IV_P_SPREADSHEET_ID`	IMPORTING	`STRING`	spreadsheetId
`IS_INPUT`	IMPORTING	`TY_045`	BatchUpdateValuesRequest
`ES_RAW`	EXPORTING	`DATA`	Données brutes de sortie
`ES_OUTPUT`	EXPORTING	`TY_046`	BatchUpdateValuesResponse
`EV_RET_CODE`	EXPORTING	`I`	Code renvoyé
`EV_ERR_TEXT`	EXPORTING	`STRING`	Texte de l'erreur
`ES_ERR_RESP`	EXPORTING	`/GOOG/ERR_RESP`	Réponse d'erreur

Exception

Nom	Description
`/GOOG/CX_SDK`	SDK ABAP pour Google Cloud : classe d'exception

CLEAR_VALUES

Description : sheets.spreadsheets.values.clear
Visibility: Public

Paramètres

Nom	Catégorie	Type	Description
`IV_P_RANGE`	IMPORTING	`STRING`	range
`IV_P_SPREADSHEET_ID`	IMPORTING	`STRING`	spreadsheetId
`IS_INPUT`	IMPORTING	`DATA`	Données d'entrée
`ES_RAW`	EXPORTING	`DATA`	Données brutes de sortie
`ES_OUTPUT`	EXPORTING	`TY_071`	ClearValuesResponse
`EV_RET_CODE`	EXPORTING	`I`	Code renvoyé
`EV_ERR_TEXT`	EXPORTING	`STRING`	Texte de l'erreur
`ES_ERR_RESP`	EXPORTING	`/GOOG/ERR_RESP`	Réponse d'erreur

Exception

Nom	Description
`/GOOG/CX_SDK`	SDK ABAP pour Google Cloud : classe d'exception

COPY_TO_SHEETS

Description : sheets.spreadsheets.sheets.copyTo
Visibility: Public

Paramètres

Nom	Catégorie	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`	Données brutes de sortie
`ES_OUTPUT`	EXPORTING	`TY_196`	SheetProperties
`EV_RET_CODE`	EXPORTING	`I`	Code renvoyé
`EV_ERR_TEXT`	EXPORTING	`STRING`	Texte de l'erreur
`ES_ERR_RESP`	EXPORTING	`/GOOG/ERR_RESP`	Réponse d'erreur

Exception

Nom	Description
`/GOOG/CX_SDK`	SDK ABAP pour Google Cloud : classe d'exception

CREATE_SPREADSHEETS

Description : sheets.spreadsheets.create
Visibility: Public

Paramètres

Nom	Catégorie	Type	Description
`IS_INPUT`	IMPORTING	`TY_202`	Feuille de calcul
`ES_RAW`	EXPORTING	`DATA`	Données brutes de sortie
`ES_OUTPUT`	EXPORTING	`TY_202`	Feuille de calcul
`EV_RET_CODE`	EXPORTING	`I`	Code renvoyé
`EV_ERR_TEXT`	EXPORTING	`STRING`	Texte de l'erreur
`ES_ERR_RESP`	EXPORTING	`/GOOG/ERR_RESP`	Réponse d'erreur

Exception

Nom	Description
`/GOOG/CX_SDK`	SDK ABAP pour Google Cloud : classe d'exception

GET_BY_DATA_FILTER_SPREADSH

Description : sheets.spreadsheets.getByDataFilter
Visibility: Public

Paramètres

Nom	Catégorie	Type	Description
`IV_P_SPREADSHEET_ID`	IMPORTING	`STRING`	spreadsheetId
`IS_INPUT`	IMPORTING	`TY_141`	GetSpreadsheetByDataFilterRequest
`ES_RAW`	EXPORTING	`DATA`	Données brutes de sortie
`ES_OUTPUT`	EXPORTING	`TY_202`	Feuille de calcul
`EV_RET_CODE`	EXPORTING	`I`	Code renvoyé
`EV_ERR_TEXT`	EXPORTING	`STRING`	Texte de l'erreur
`ES_ERR_RESP`	EXPORTING	`/GOOG/ERR_RESP`	Réponse d'erreur

Exception

Nom	Description
`/GOOG/CX_SDK`	SDK ABAP pour Google Cloud : classe d'exception

GET_DEVELOPER_METADATA

Description : sheets.spreadsheets.developerMetadata.get
Visibility: Public

Paramètres

Nom	Catégorie	Type	Description
`IV_P_METADATA_ID`	IMPORTING	`STRING`	metadataId
`IV_P_SPREADSHEET_ID`	IMPORTING	`STRING`	spreadsheetId
`ES_RAW`	EXPORTING	`DATA`	Données brutes de sortie
`ES_OUTPUT`	EXPORTING	`TY_120`	DeveloperMetadata
`EV_RET_CODE`	EXPORTING	`I`	Code renvoyé
`EV_ERR_TEXT`	EXPORTING	`STRING`	Texte de l'erreur
`ES_ERR_RESP`	EXPORTING	`/GOOG/ERR_RESP`	Réponse d'erreur

Exception

Nom	Description
`/GOOG/CX_SDK`	SDK ABAP pour Google Cloud : classe d'exception

GET_SPREADSHEETS

Description : sheets.spreadsheets.get
Visibility: Public

Paramètres

Nom	Catégorie	Type	Description
`IV_Q_INCLUDEGRIDDATA`	IMPORTING	`STRING`	includeGridData
`IV_Q_RANGES`	IMPORTING	`STRING`	Plages
`IV_P_SPREADSHEET_ID`	IMPORTING	`STRING`	spreadsheetId
`ES_RAW`	EXPORTING	`DATA`	Données brutes de sortie
`ES_OUTPUT`	EXPORTING	`TY_202`	Feuille de calcul
`EV_RET_CODE`	EXPORTING	`I`	Code renvoyé
`EV_ERR_TEXT`	EXPORTING	`STRING`	Texte de l'erreur
`ES_ERR_RESP`	EXPORTING	`/GOOG/ERR_RESP`	Réponse d'erreur

Exception

Nom	Description
`/GOOG/CX_SDK`	SDK ABAP pour Google Cloud : classe d'exception

GET_VALUES

Description : sheets.spreadsheets.values.get
Visibility: Public

Paramètres

Nom	Catégorie	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`	Données brutes de sortie
`ES_OUTPUT`	EXPORTING	`TY_240`	ValueRange
`EV_RET_CODE`	EXPORTING	`I`	Code renvoyé
`EV_ERR_TEXT`	EXPORTING	`STRING`	Texte de l'erreur
`ES_ERR_RESP`	EXPORTING	`/GOOG/ERR_RESP`	Réponse d'erreur

Exception

Nom	Description
`/GOOG/CX_SDK`	SDK ABAP pour Google Cloud : classe d'exception

SEARCH_DEVELOPER_METADATA

Description : sheets.spreadsheets.developerMetadata.search
Visibility: Public

Paramètres

Nom	Catégorie	Type	Description
`IV_P_SPREADSHEET_ID`	IMPORTING	`STRING`	spreadsheetId
`IS_INPUT`	IMPORTING	`TY_191`	SearchDeveloperMetadataRequest
`ES_RAW`	EXPORTING	`DATA`	Données brutes de sortie
`ES_OUTPUT`	EXPORTING	`TY_192`	SearchDeveloperMetadataResponse
`EV_RET_CODE`	EXPORTING	`I`	Code renvoyé
`EV_ERR_TEXT`	EXPORTING	`STRING`	Texte de l'erreur
`ES_ERR_RESP`	EXPORTING	`/GOOG/ERR_RESP`	Réponse d'erreur

Exception

Nom	Description
`/GOOG/CX_SDK`	SDK ABAP pour Google Cloud : classe d'exception

UPDATE_VALUES

Description : sheets.spreadsheets.values.update
Visibility: Public

Paramètres

Nom	Catégorie	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`	Données brutes de sortie
`ES_OUTPUT`	EXPORTING	`TY_239`	UpdateValuesResponse
`EV_RET_CODE`	EXPORTING	`I`	Code renvoyé
`EV_ERR_TEXT`	EXPORTING	`STRING`	Texte de l'erreur
`ES_ERR_RESP`	EXPORTING	`/GOOG/ERR_RESP`	Réponse d'erreur

Exception

Nom	Description
`/GOOG/CX_SDK`	SDK ABAP pour Google Cloud : classe d'exception

FERMER

Description : Fermer la connexion
Visibilité : PUBLIQUE