• Home
• com.google.apis
• google-api-services-sheets
• v4-rev20240319-2.0.0
• source code
• Request.html

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

target.apidocs.com.google.api.services.sheets.v4.model.Request.html Maven / Gradle / Ivy

Skip navigation links




Overview
Package
Class
Use
Tree
Deprecated
Index
Help




Prev Class
Next Class


Frames
No Frames


All Classes






Summary: 
Nested | 
Field | 
Constr | 
Method


Detail: 
Field | 
Constr | 
Method








com.google.api.services.sheets.v4.model
Class Request



java.lang.Object


java.util.AbstractMap<String,Object>


com.google.api.client.util.GenericData


com.google.api.client.json.GenericJson


com.google.api.services.sheets.v4.model.Request













All Implemented Interfaces:
Cloneable, Map<String,Object>




public final class Request
extends com.google.api.client.json.GenericJson
A single kind of update to apply to a spreadsheet.

 
 This is the Java data model class that specifies how to parse/serialize into the JSON that is
 transmitted over HTTP when working with the Google Sheets API. For a detailed explanation see:
 https://developers.google.com/api-client-library/java/google-http-java-client/json
 

Author:
Google, Inc.












Nested Class Summary




Nested classes/interfaces inherited from class com.google.api.client.util.GenericData
com.google.api.client.util.GenericData.Flags





Nested classes/interfaces inherited from class java.util.AbstractMap
AbstractMap.SimpleEntry<K,V>, AbstractMap.SimpleImmutableEntry<K,V>





Nested classes/interfaces inherited from interface java.util.Map
Map.Entry<K,V>








Constructor Summary

Constructors 

Constructor and Description


Request() 









Method Summary

All Methods Instance Methods Concrete Methods 

Modifier and Type
Method and Description


Request
clone() 


AddBandingRequest
getAddBanding()
Adds a new banded range



AddChartRequest
getAddChart()
Adds a chart.



AddConditionalFormatRuleRequest
getAddConditionalFormatRule()
Adds a new conditional format rule.



AddDataSourceRequest
getAddDataSource()
Adds a data source.



AddDimensionGroupRequest
getAddDimensionGroup()
Creates a group over the specified range.



AddFilterViewRequest
getAddFilterView()
Adds a filter view.



AddNamedRangeRequest
getAddNamedRange()
Adds a named range.



AddProtectedRangeRequest
getAddProtectedRange()
Adds a protected range.



AddSheetRequest
getAddSheet()
Adds a sheet.



AddSlicerRequest
getAddSlicer()
Adds a slicer.



AppendCellsRequest
getAppendCells()
Appends cells after the last row with data in a sheet.



AppendDimensionRequest
getAppendDimension()
Appends dimensions to the end of a sheet.



AutoFillRequest
getAutoFill()
Automatically fills in more data based on existing data.



AutoResizeDimensionsRequest
getAutoResizeDimensions()
Automatically resizes one or more dimensions based on the contents of the cells in that
 dimension.



ClearBasicFilterRequest
getClearBasicFilter()
Clears the basic filter on a sheet.



CopyPasteRequest
getCopyPaste()
Copies data from one area and pastes it to another.



CreateDeveloperMetadataRequest
getCreateDeveloperMetadata()
Creates new developer metadata



CutPasteRequest
getCutPaste()
Cuts data from one area and pastes it to another.



DeleteBandingRequest
getDeleteBanding()
Removes a banded range



DeleteConditionalFormatRuleRequest
getDeleteConditionalFormatRule()
Deletes an existing conditional format rule.



DeleteDataSourceRequest
getDeleteDataSource()
Deletes a data source.



DeleteDeveloperMetadataRequest
getDeleteDeveloperMetadata()
Deletes developer metadata



DeleteDimensionRequest
getDeleteDimension()
Deletes rows or columns in a sheet.



DeleteDimensionGroupRequest
getDeleteDimensionGroup()
Deletes a group over the specified range.



DeleteDuplicatesRequest
getDeleteDuplicates()
Removes rows containing duplicate values in specified columns of a cell range.



DeleteEmbeddedObjectRequest
getDeleteEmbeddedObject()
Deletes an embedded object (e.g, chart, image) in a sheet.



DeleteFilterViewRequest
getDeleteFilterView()
Deletes a filter view from a sheet.



DeleteNamedRangeRequest
getDeleteNamedRange()
Deletes a named range.



DeleteProtectedRangeRequest
getDeleteProtectedRange()
Deletes a protected range.



DeleteRangeRequest
getDeleteRange()
Deletes a range of cells from a sheet, shifting the remaining cells.



DeleteSheetRequest
getDeleteSheet()
Deletes a sheet.



DuplicateFilterViewRequest
getDuplicateFilterView()
Duplicates a filter view.



DuplicateSheetRequest
getDuplicateSheet()
Duplicates a sheet.



FindReplaceRequest
getFindReplace()
Finds and replaces occurrences of some text with other text.



InsertDimensionRequest
getInsertDimension()
Inserts new rows or columns in a sheet.



InsertRangeRequest
getInsertRange()
Inserts new cells in a sheet, shifting the existing cells.



MergeCellsRequest
getMergeCells()
Merges cells together.



MoveDimensionRequest
getMoveDimension()
Moves rows or columns to another location in a sheet.



PasteDataRequest
getPasteData()
Pastes data (HTML or delimited) into a sheet.



RandomizeRangeRequest
getRandomizeRange()
Randomizes the order of the rows in a range.



RefreshDataSourceRequest
getRefreshDataSource()
Refreshes one or multiple data sources and associated dbobjects.



RepeatCellRequest
getRepeatCell()
Repeats a single cell across a range.



SetBasicFilterRequest
getSetBasicFilter()
Sets the basic filter on a sheet.



SetDataValidationRequest
getSetDataValidation()
Sets data validation for one or more cells.



SortRangeRequest
getSortRange()
Sorts data in a range.



TextToColumnsRequest
getTextToColumns()
Converts a column of text into many columns of text.



TrimWhitespaceRequest
getTrimWhitespace()
Trims cells of whitespace (such as spaces, tabs, or new lines).



UnmergeCellsRequest
getUnmergeCells()
Unmerges merged cells.



UpdateBandingRequest
getUpdateBanding()
Updates a banded range



UpdateBordersRequest
getUpdateBorders()
Updates the borders in a range of cells.



UpdateCellsRequest
getUpdateCells()
Updates many cells at once.



UpdateChartSpecRequest
getUpdateChartSpec()
Updates a chart's specifications.



UpdateConditionalFormatRuleRequest
getUpdateConditionalFormatRule()
Updates an existing conditional format rule.



UpdateDataSourceRequest
getUpdateDataSource()
Updates a data source.



UpdateDeveloperMetadataRequest
getUpdateDeveloperMetadata()
Updates an existing developer metadata entry



UpdateDimensionGroupRequest
getUpdateDimensionGroup()
Updates the state of the specified group.



UpdateDimensionPropertiesRequest
getUpdateDimensionProperties()
Updates dimensions' properties.



UpdateEmbeddedObjectBorderRequest
getUpdateEmbeddedObjectBorder()
Updates an embedded object's border.



UpdateEmbeddedObjectPositionRequest
getUpdateEmbeddedObjectPosition()
Updates an embedded object's (e.g.



UpdateFilterViewRequest
getUpdateFilterView()
Updates the properties of a filter view.



UpdateNamedRangeRequest
getUpdateNamedRange()
Updates a named range.



UpdateProtectedRangeRequest
getUpdateProtectedRange()
Updates a protected range.



UpdateSheetPropertiesRequest
getUpdateSheetProperties()
Updates a sheet's properties.



UpdateSlicerSpecRequest
getUpdateSlicerSpec()
Updates a slicer's specifications.



UpdateSpreadsheetPropertiesRequest
getUpdateSpreadsheetProperties()
Updates the spreadsheet's properties.



Request
set(String fieldName,
   Object value) 


Request
setAddBanding(AddBandingRequest addBanding)
Adds a new banded range



Request
setAddChart(AddChartRequest addChart)
Adds a chart.



Request
setAddConditionalFormatRule(AddConditionalFormatRuleRequest addConditionalFormatRule)
Adds a new conditional format rule.



Request
setAddDataSource(AddDataSourceRequest addDataSource)
Adds a data source.



Request
setAddDimensionGroup(AddDimensionGroupRequest addDimensionGroup)
Creates a group over the specified range.



Request
setAddFilterView(AddFilterViewRequest addFilterView)
Adds a filter view.



Request
setAddNamedRange(AddNamedRangeRequest addNamedRange)
Adds a named range.



Request
setAddProtectedRange(AddProtectedRangeRequest addProtectedRange)
Adds a protected range.



Request
setAddSheet(AddSheetRequest addSheet)
Adds a sheet.



Request
setAddSlicer(AddSlicerRequest addSlicer)
Adds a slicer.



Request
setAppendCells(AppendCellsRequest appendCells)
Appends cells after the last row with data in a sheet.



Request
setAppendDimension(AppendDimensionRequest appendDimension)
Appends dimensions to the end of a sheet.



Request
setAutoFill(AutoFillRequest autoFill)
Automatically fills in more data based on existing data.



Request
setAutoResizeDimensions(AutoResizeDimensionsRequest autoResizeDimensions)
Automatically resizes one or more dimensions based on the contents of the cells in that
 dimension.



Request
setClearBasicFilter(ClearBasicFilterRequest clearBasicFilter)
Clears the basic filter on a sheet.



Request
setCopyPaste(CopyPasteRequest copyPaste)
Copies data from one area and pastes it to another.



Request
setCreateDeveloperMetadata(CreateDeveloperMetadataRequest createDeveloperMetadata)
Creates new developer metadata



Request
setCutPaste(CutPasteRequest cutPaste)
Cuts data from one area and pastes it to another.



Request
setDeleteBanding(DeleteBandingRequest deleteBanding)
Removes a banded range



Request
setDeleteConditionalFormatRule(DeleteConditionalFormatRuleRequest deleteConditionalFormatRule)
Deletes an existing conditional format rule.



Request
setDeleteDataSource(DeleteDataSourceRequest deleteDataSource)
Deletes a data source.



Request
setDeleteDeveloperMetadata(DeleteDeveloperMetadataRequest deleteDeveloperMetadata)
Deletes developer metadata



Request
setDeleteDimension(DeleteDimensionRequest deleteDimension)
Deletes rows or columns in a sheet.



Request
setDeleteDimensionGroup(DeleteDimensionGroupRequest deleteDimensionGroup)
Deletes a group over the specified range.



Request
setDeleteDuplicates(DeleteDuplicatesRequest deleteDuplicates)
Removes rows containing duplicate values in specified columns of a cell range.



Request
setDeleteEmbeddedObject(DeleteEmbeddedObjectRequest deleteEmbeddedObject)
Deletes an embedded object (e.g, chart, image) in a sheet.



Request
setDeleteFilterView(DeleteFilterViewRequest deleteFilterView)
Deletes a filter view from a sheet.



Request
setDeleteNamedRange(DeleteNamedRangeRequest deleteNamedRange)
Deletes a named range.



Request
setDeleteProtectedRange(DeleteProtectedRangeRequest deleteProtectedRange)
Deletes a protected range.



Request
setDeleteRange(DeleteRangeRequest deleteRange)
Deletes a range of cells from a sheet, shifting the remaining cells.



Request
setDeleteSheet(DeleteSheetRequest deleteSheet)
Deletes a sheet.



Request
setDuplicateFilterView(DuplicateFilterViewRequest duplicateFilterView)
Duplicates a filter view.



Request
setDuplicateSheet(DuplicateSheetRequest duplicateSheet)
Duplicates a sheet.



Request
setFindReplace(FindReplaceRequest findReplace)
Finds and replaces occurrences of some text with other text.



Request
setInsertDimension(InsertDimensionRequest insertDimension)
Inserts new rows or columns in a sheet.



Request
setInsertRange(InsertRangeRequest insertRange)
Inserts new cells in a sheet, shifting the existing cells.



Request
setMergeCells(MergeCellsRequest mergeCells)
Merges cells together.



Request
setMoveDimension(MoveDimensionRequest moveDimension)
Moves rows or columns to another location in a sheet.



Request
setPasteData(PasteDataRequest pasteData)
Pastes data (HTML or delimited) into a sheet.



Request
setRandomizeRange(RandomizeRangeRequest randomizeRange)
Randomizes the order of the rows in a range.



Request
setRefreshDataSource(RefreshDataSourceRequest refreshDataSource)
Refreshes one or multiple data sources and associated dbobjects.



Request
setRepeatCell(RepeatCellRequest repeatCell)
Repeats a single cell across a range.



Request
setSetBasicFilter(SetBasicFilterRequest setBasicFilter)
Sets the basic filter on a sheet.



Request
setSetDataValidation(SetDataValidationRequest setDataValidation)
Sets data validation for one or more cells.



Request
setSortRange(SortRangeRequest sortRange)
Sorts data in a range.



Request
setTextToColumns(TextToColumnsRequest textToColumns)
Converts a column of text into many columns of text.



Request
setTrimWhitespace(TrimWhitespaceRequest trimWhitespace)
Trims cells of whitespace (such as spaces, tabs, or new lines).



Request
setUnmergeCells(UnmergeCellsRequest unmergeCells)
Unmerges merged cells.



Request
setUpdateBanding(UpdateBandingRequest updateBanding)
Updates a banded range



Request
setUpdateBorders(UpdateBordersRequest updateBorders)
Updates the borders in a range of cells.



Request
setUpdateCells(UpdateCellsRequest updateCells)
Updates many cells at once.



Request
setUpdateChartSpec(UpdateChartSpecRequest updateChartSpec)
Updates a chart's specifications.



Request
setUpdateConditionalFormatRule(UpdateConditionalFormatRuleRequest updateConditionalFormatRule)
Updates an existing conditional format rule.



Request
setUpdateDataSource(UpdateDataSourceRequest updateDataSource)
Updates a data source.



Request
setUpdateDeveloperMetadata(UpdateDeveloperMetadataRequest updateDeveloperMetadata)
Updates an existing developer metadata entry



Request
setUpdateDimensionGroup(UpdateDimensionGroupRequest updateDimensionGroup)
Updates the state of the specified group.



Request
setUpdateDimensionProperties(UpdateDimensionPropertiesRequest updateDimensionProperties)
Updates dimensions' properties.



Request
setUpdateEmbeddedObjectBorder(UpdateEmbeddedObjectBorderRequest updateEmbeddedObjectBorder)
Updates an embedded object's border.



Request
setUpdateEmbeddedObjectPosition(UpdateEmbeddedObjectPositionRequest updateEmbeddedObjectPosition)
Updates an embedded object's (e.g.



Request
setUpdateFilterView(UpdateFilterViewRequest updateFilterView)
Updates the properties of a filter view.



Request
setUpdateNamedRange(UpdateNamedRangeRequest updateNamedRange)
Updates a named range.



Request
setUpdateProtectedRange(UpdateProtectedRangeRequest updateProtectedRange)
Updates a protected range.



Request
setUpdateSheetProperties(UpdateSheetPropertiesRequest updateSheetProperties)
Updates a sheet's properties.



Request
setUpdateSlicerSpec(UpdateSlicerSpecRequest updateSlicerSpec)
Updates a slicer's specifications.



Request
setUpdateSpreadsheetProperties(UpdateSpreadsheetPropertiesRequest updateSpreadsheetProperties)
Updates the spreadsheet's properties.







Methods inherited from class com.google.api.client.json.GenericJson
getFactory, setFactory, toPrettyString, toString





Methods inherited from class com.google.api.client.util.GenericData
entrySet, equals, get, getClassInfo, getUnknownKeys, hashCode, put, putAll, remove, setUnknownKeys





Methods inherited from class java.util.AbstractMap
clear, containsKey, containsValue, isEmpty, keySet, size, values





Methods inherited from class java.lang.Object
finalize, getClass, notify, notifyAll, wait, wait, wait





Methods inherited from interface java.util.Map
compute, computeIfAbsent, computeIfPresent, forEach, getOrDefault, merge, putIfAbsent, remove, replace, replace, replaceAll














Constructor Detail





Request
public Request()









Method Detail





getAddBanding
public AddBandingRequest getAddBanding()
Adds a new banded range

Returns:
value or null for none








setAddBanding
public Request setAddBanding(AddBandingRequest addBanding)
Adds a new banded range

Parameters:
addBanding - addBanding or null for none








getAddChart
public AddChartRequest getAddChart()
Adds a chart.

Returns:
value or null for none








setAddChart
public Request setAddChart(AddChartRequest addChart)
Adds a chart.

Parameters:
addChart - addChart or null for none








getAddConditionalFormatRule
public AddConditionalFormatRuleRequest getAddConditionalFormatRule()
Adds a new conditional format rule.

Returns:
value or null for none








setAddConditionalFormatRule
public Request setAddConditionalFormatRule(AddConditionalFormatRuleRequest addConditionalFormatRule)
Adds a new conditional format rule.

Parameters:
addConditionalFormatRule - addConditionalFormatRule or null for none








getAddDataSource
public AddDataSourceRequest getAddDataSource()
Adds a data source.

Returns:
value or null for none








setAddDataSource
public Request setAddDataSource(AddDataSourceRequest addDataSource)
Adds a data source.

Parameters:
addDataSource - addDataSource or null for none








getAddDimensionGroup
public AddDimensionGroupRequest getAddDimensionGroup()
Creates a group over the specified range.

Returns:
value or null for none








setAddDimensionGroup
public Request setAddDimensionGroup(AddDimensionGroupRequest addDimensionGroup)
Creates a group over the specified range.

Parameters:
addDimensionGroup - addDimensionGroup or null for none








getAddFilterView
public AddFilterViewRequest getAddFilterView()
Adds a filter view.

Returns:
value or null for none








setAddFilterView
public Request setAddFilterView(AddFilterViewRequest addFilterView)
Adds a filter view.

Parameters:
addFilterView - addFilterView or null for none








getAddNamedRange
public AddNamedRangeRequest getAddNamedRange()
Adds a named range.

Returns:
value or null for none








setAddNamedRange
public Request setAddNamedRange(AddNamedRangeRequest addNamedRange)
Adds a named range.

Parameters:
addNamedRange - addNamedRange or null for none








getAddProtectedRange
public AddProtectedRangeRequest getAddProtectedRange()
Adds a protected range.

Returns:
value or null for none








setAddProtectedRange
public Request setAddProtectedRange(AddProtectedRangeRequest addProtectedRange)
Adds a protected range.

Parameters:
addProtectedRange - addProtectedRange or null for none








getAddSheet
public AddSheetRequest getAddSheet()
Adds a sheet.

Returns:
value or null for none








setAddSheet
public Request setAddSheet(AddSheetRequest addSheet)
Adds a sheet.

Parameters:
addSheet - addSheet or null for none








getAddSlicer
public AddSlicerRequest getAddSlicer()
Adds a slicer.

Returns:
value or null for none








setAddSlicer
public Request setAddSlicer(AddSlicerRequest addSlicer)
Adds a slicer.

Parameters:
addSlicer - addSlicer or null for none








getAppendCells
public AppendCellsRequest getAppendCells()
Appends cells after the last row with data in a sheet.

Returns:
value or null for none








setAppendCells
public Request setAppendCells(AppendCellsRequest appendCells)
Appends cells after the last row with data in a sheet.

Parameters:
appendCells - appendCells or null for none








getAppendDimension
public AppendDimensionRequest getAppendDimension()
Appends dimensions to the end of a sheet.

Returns:
value or null for none








setAppendDimension
public Request setAppendDimension(AppendDimensionRequest appendDimension)
Appends dimensions to the end of a sheet.

Parameters:
appendDimension - appendDimension or null for none








getAutoFill
public AutoFillRequest getAutoFill()
Automatically fills in more data based on existing data.

Returns:
value or null for none








setAutoFill
public Request setAutoFill(AutoFillRequest autoFill)
Automatically fills in more data based on existing data.

Parameters:
autoFill - autoFill or null for none








getAutoResizeDimensions
public AutoResizeDimensionsRequest getAutoResizeDimensions()
Automatically resizes one or more dimensions based on the contents of the cells in that
 dimension.

Returns:
value or null for none








setAutoResizeDimensions
public Request setAutoResizeDimensions(AutoResizeDimensionsRequest autoResizeDimensions)
Automatically resizes one or more dimensions based on the contents of the cells in that
 dimension.

Parameters:
autoResizeDimensions - autoResizeDimensions or null for none








getClearBasicFilter
public ClearBasicFilterRequest getClearBasicFilter()
Clears the basic filter on a sheet.

Returns:
value or null for none








setClearBasicFilter
public Request setClearBasicFilter(ClearBasicFilterRequest clearBasicFilter)
Clears the basic filter on a sheet.

Parameters:
clearBasicFilter - clearBasicFilter or null for none








getCopyPaste
public CopyPasteRequest getCopyPaste()
Copies data from one area and pastes it to another.

Returns:
value or null for none








setCopyPaste
public Request setCopyPaste(CopyPasteRequest copyPaste)
Copies data from one area and pastes it to another.

Parameters:
copyPaste - copyPaste or null for none








getCreateDeveloperMetadata
public CreateDeveloperMetadataRequest getCreateDeveloperMetadata()
Creates new developer metadata

Returns:
value or null for none








setCreateDeveloperMetadata
public Request setCreateDeveloperMetadata(CreateDeveloperMetadataRequest createDeveloperMetadata)
Creates new developer metadata

Parameters:
createDeveloperMetadata - createDeveloperMetadata or null for none








getCutPaste
public CutPasteRequest getCutPaste()
Cuts data from one area and pastes it to another.

Returns:
value or null for none








setCutPaste
public Request setCutPaste(CutPasteRequest cutPaste)
Cuts data from one area and pastes it to another.

Parameters:
cutPaste - cutPaste or null for none








getDeleteBanding
public DeleteBandingRequest getDeleteBanding()
Removes a banded range

Returns:
value or null for none








setDeleteBanding
public Request setDeleteBanding(DeleteBandingRequest deleteBanding)
Removes a banded range

Parameters:
deleteBanding - deleteBanding or null for none








getDeleteConditionalFormatRule
public DeleteConditionalFormatRuleRequest getDeleteConditionalFormatRule()
Deletes an existing conditional format rule.

Returns:
value or null for none








setDeleteConditionalFormatRule
public Request setDeleteConditionalFormatRule(DeleteConditionalFormatRuleRequest deleteConditionalFormatRule)
Deletes an existing conditional format rule.

Parameters:
deleteConditionalFormatRule - deleteConditionalFormatRule or null for none








getDeleteDataSource
public DeleteDataSourceRequest getDeleteDataSource()
Deletes a data source.

Returns:
value or null for none








setDeleteDataSource
public Request setDeleteDataSource(DeleteDataSourceRequest deleteDataSource)
Deletes a data source.

Parameters:
deleteDataSource - deleteDataSource or null for none








getDeleteDeveloperMetadata
public DeleteDeveloperMetadataRequest getDeleteDeveloperMetadata()
Deletes developer metadata

Returns:
value or null for none








setDeleteDeveloperMetadata
public Request setDeleteDeveloperMetadata(DeleteDeveloperMetadataRequest deleteDeveloperMetadata)
Deletes developer metadata

Parameters:
deleteDeveloperMetadata - deleteDeveloperMetadata or null for none








getDeleteDimension
public DeleteDimensionRequest getDeleteDimension()
Deletes rows or columns in a sheet.

Returns:
value or null for none








setDeleteDimension
public Request setDeleteDimension(DeleteDimensionRequest deleteDimension)
Deletes rows or columns in a sheet.

Parameters:
deleteDimension - deleteDimension or null for none








getDeleteDimensionGroup
public DeleteDimensionGroupRequest getDeleteDimensionGroup()
Deletes a group over the specified range.

Returns:
value or null for none








setDeleteDimensionGroup
public Request setDeleteDimensionGroup(DeleteDimensionGroupRequest deleteDimensionGroup)
Deletes a group over the specified range.

Parameters:
deleteDimensionGroup - deleteDimensionGroup or null for none








getDeleteDuplicates
public DeleteDuplicatesRequest getDeleteDuplicates()
Removes rows containing duplicate values in specified columns of a cell range.

Returns:
value or null for none








setDeleteDuplicates
public Request setDeleteDuplicates(DeleteDuplicatesRequest deleteDuplicates)
Removes rows containing duplicate values in specified columns of a cell range.

Parameters:
deleteDuplicates - deleteDuplicates or null for none








getDeleteEmbeddedObject
public DeleteEmbeddedObjectRequest getDeleteEmbeddedObject()
Deletes an embedded object (e.g, chart, image) in a sheet.

Returns:
value or null for none








setDeleteEmbeddedObject
public Request setDeleteEmbeddedObject(DeleteEmbeddedObjectRequest deleteEmbeddedObject)
Deletes an embedded object (e.g, chart, image) in a sheet.

Parameters:
deleteEmbeddedObject - deleteEmbeddedObject or null for none








getDeleteFilterView
public DeleteFilterViewRequest getDeleteFilterView()
Deletes a filter view from a sheet.

Returns:
value or null for none








setDeleteFilterView
public Request setDeleteFilterView(DeleteFilterViewRequest deleteFilterView)
Deletes a filter view from a sheet.

Parameters:
deleteFilterView - deleteFilterView or null for none








getDeleteNamedRange
public DeleteNamedRangeRequest getDeleteNamedRange()
Deletes a named range.

Returns:
value or null for none








setDeleteNamedRange
public Request setDeleteNamedRange(DeleteNamedRangeRequest deleteNamedRange)
Deletes a named range.

Parameters:
deleteNamedRange - deleteNamedRange or null for none








getDeleteProtectedRange
public DeleteProtectedRangeRequest getDeleteProtectedRange()
Deletes a protected range.

Returns:
value or null for none








setDeleteProtectedRange
public Request setDeleteProtectedRange(DeleteProtectedRangeRequest deleteProtectedRange)
Deletes a protected range.

Parameters:
deleteProtectedRange - deleteProtectedRange or null for none








getDeleteRange
public DeleteRangeRequest getDeleteRange()
Deletes a range of cells from a sheet, shifting the remaining cells.

Returns:
value or null for none








setDeleteRange
public Request setDeleteRange(DeleteRangeRequest deleteRange)
Deletes a range of cells from a sheet, shifting the remaining cells.

Parameters:
deleteRange - deleteRange or null for none








getDeleteSheet
public DeleteSheetRequest getDeleteSheet()
Deletes a sheet.

Returns:
value or null for none








setDeleteSheet
public Request setDeleteSheet(DeleteSheetRequest deleteSheet)
Deletes a sheet.

Parameters:
deleteSheet - deleteSheet or null for none








getDuplicateFilterView
public DuplicateFilterViewRequest getDuplicateFilterView()
Duplicates a filter view.

Returns:
value or null for none








setDuplicateFilterView
public Request setDuplicateFilterView(DuplicateFilterViewRequest duplicateFilterView)
Duplicates a filter view.

Parameters:
duplicateFilterView - duplicateFilterView or null for none








getDuplicateSheet
public DuplicateSheetRequest getDuplicateSheet()
Duplicates a sheet.

Returns:
value or null for none








setDuplicateSheet
public Request setDuplicateSheet(DuplicateSheetRequest duplicateSheet)
Duplicates a sheet.

Parameters:
duplicateSheet - duplicateSheet or null for none








getFindReplace
public FindReplaceRequest getFindReplace()
Finds and replaces occurrences of some text with other text.

Returns:
value or null for none








setFindReplace
public Request setFindReplace(FindReplaceRequest findReplace)
Finds and replaces occurrences of some text with other text.

Parameters:
findReplace - findReplace or null for none








getInsertDimension
public InsertDimensionRequest getInsertDimension()
Inserts new rows or columns in a sheet.

Returns:
value or null for none








setInsertDimension
public Request setInsertDimension(InsertDimensionRequest insertDimension)
Inserts new rows or columns in a sheet.

Parameters:
insertDimension - insertDimension or null for none








getInsertRange
public InsertRangeRequest getInsertRange()
Inserts new cells in a sheet, shifting the existing cells.

Returns:
value or null for none








setInsertRange
public Request setInsertRange(InsertRangeRequest insertRange)
Inserts new cells in a sheet, shifting the existing cells.

Parameters:
insertRange - insertRange or null for none








getMergeCells
public MergeCellsRequest getMergeCells()
Merges cells together.

Returns:
value or null for none








setMergeCells
public Request setMergeCells(MergeCellsRequest mergeCells)
Merges cells together.

Parameters:
mergeCells - mergeCells or null for none








getMoveDimension
public MoveDimensionRequest getMoveDimension()
Moves rows or columns to another location in a sheet.

Returns:
value or null for none








setMoveDimension
public Request setMoveDimension(MoveDimensionRequest moveDimension)
Moves rows or columns to another location in a sheet.

Parameters:
moveDimension - moveDimension or null for none








getPasteData
public PasteDataRequest getPasteData()
Pastes data (HTML or delimited) into a sheet.

Returns:
value or null for none








setPasteData
public Request setPasteData(PasteDataRequest pasteData)
Pastes data (HTML or delimited) into a sheet.

Parameters:
pasteData - pasteData or null for none








getRandomizeRange
public RandomizeRangeRequest getRandomizeRange()
Randomizes the order of the rows in a range.

Returns:
value or null for none








setRandomizeRange
public Request setRandomizeRange(RandomizeRangeRequest randomizeRange)
Randomizes the order of the rows in a range.

Parameters:
randomizeRange - randomizeRange or null for none








getRefreshDataSource
public RefreshDataSourceRequest getRefreshDataSource()
Refreshes one or multiple data sources and associated dbobjects.

Returns:
value or null for none








setRefreshDataSource
public Request setRefreshDataSource(RefreshDataSourceRequest refreshDataSource)
Refreshes one or multiple data sources and associated dbobjects.

Parameters:
refreshDataSource - refreshDataSource or null for none








getRepeatCell
public RepeatCellRequest getRepeatCell()
Repeats a single cell across a range.

Returns:
value or null for none








setRepeatCell
public Request setRepeatCell(RepeatCellRequest repeatCell)
Repeats a single cell across a range.

Parameters:
repeatCell - repeatCell or null for none








getSetBasicFilter
public SetBasicFilterRequest getSetBasicFilter()
Sets the basic filter on a sheet.

Returns:
value or null for none








setSetBasicFilter
public Request setSetBasicFilter(SetBasicFilterRequest setBasicFilter)
Sets the basic filter on a sheet.

Parameters:
setBasicFilter - setBasicFilter or null for none








getSetDataValidation
public SetDataValidationRequest getSetDataValidation()
Sets data validation for one or more cells.

Returns:
value or null for none








setSetDataValidation
public Request setSetDataValidation(SetDataValidationRequest setDataValidation)
Sets data validation for one or more cells.

Parameters:
setDataValidation - setDataValidation or null for none








getSortRange
public SortRangeRequest getSortRange()
Sorts data in a range.

Returns:
value or null for none








setSortRange
public Request setSortRange(SortRangeRequest sortRange)
Sorts data in a range.

Parameters:
sortRange - sortRange or null for none








getTextToColumns
public TextToColumnsRequest getTextToColumns()
Converts a column of text into many columns of text.

Returns:
value or null for none








setTextToColumns
public Request setTextToColumns(TextToColumnsRequest textToColumns)
Converts a column of text into many columns of text.

Parameters:
textToColumns - textToColumns or null for none








getTrimWhitespace
public TrimWhitespaceRequest getTrimWhitespace()
Trims cells of whitespace (such as spaces, tabs, or new lines).

Returns:
value or null for none








setTrimWhitespace
public Request setTrimWhitespace(TrimWhitespaceRequest trimWhitespace)
Trims cells of whitespace (such as spaces, tabs, or new lines).

Parameters:
trimWhitespace - trimWhitespace or null for none








getUnmergeCells
public UnmergeCellsRequest getUnmergeCells()
Unmerges merged cells.

Returns:
value or null for none








setUnmergeCells
public Request setUnmergeCells(UnmergeCellsRequest unmergeCells)
Unmerges merged cells.

Parameters:
unmergeCells - unmergeCells or null for none








getUpdateBanding
public UpdateBandingRequest getUpdateBanding()
Updates a banded range

Returns:
value or null for none








setUpdateBanding
public Request setUpdateBanding(UpdateBandingRequest updateBanding)
Updates a banded range

Parameters:
updateBanding - updateBanding or null for none








getUpdateBorders
public UpdateBordersRequest getUpdateBorders()
Updates the borders in a range of cells.

Returns:
value or null for none








setUpdateBorders
public Request setUpdateBorders(UpdateBordersRequest updateBorders)
Updates the borders in a range of cells.

Parameters:
updateBorders - updateBorders or null for none








getUpdateCells
public UpdateCellsRequest getUpdateCells()
Updates many cells at once.

Returns:
value or null for none








setUpdateCells
public Request setUpdateCells(UpdateCellsRequest updateCells)
Updates many cells at once.

Parameters:
updateCells - updateCells or null for none








getUpdateChartSpec
public UpdateChartSpecRequest getUpdateChartSpec()
Updates a chart's specifications.

Returns:
value or null for none








setUpdateChartSpec
public Request setUpdateChartSpec(UpdateChartSpecRequest updateChartSpec)
Updates a chart's specifications.

Parameters:
updateChartSpec - updateChartSpec or null for none








getUpdateConditionalFormatRule
public UpdateConditionalFormatRuleRequest getUpdateConditionalFormatRule()
Updates an existing conditional format rule.

Returns:
value or null for none








setUpdateConditionalFormatRule
public Request setUpdateConditionalFormatRule(UpdateConditionalFormatRuleRequest updateConditionalFormatRule)
Updates an existing conditional format rule.

Parameters:
updateConditionalFormatRule - updateConditionalFormatRule or null for none








getUpdateDataSource
public UpdateDataSourceRequest getUpdateDataSource()
Updates a data source.

Returns:
value or null for none








setUpdateDataSource
public Request setUpdateDataSource(UpdateDataSourceRequest updateDataSource)
Updates a data source.

Parameters:
updateDataSource - updateDataSource or null for none








getUpdateDeveloperMetadata
public UpdateDeveloperMetadataRequest getUpdateDeveloperMetadata()
Updates an existing developer metadata entry

Returns:
value or null for none








setUpdateDeveloperMetadata
public Request setUpdateDeveloperMetadata(UpdateDeveloperMetadataRequest updateDeveloperMetadata)
Updates an existing developer metadata entry

Parameters:
updateDeveloperMetadata - updateDeveloperMetadata or null for none








getUpdateDimensionGroup
public UpdateDimensionGroupRequest getUpdateDimensionGroup()
Updates the state of the specified group.

Returns:
value or null for none








setUpdateDimensionGroup
public Request setUpdateDimensionGroup(UpdateDimensionGroupRequest updateDimensionGroup)
Updates the state of the specified group.

Parameters:
updateDimensionGroup - updateDimensionGroup or null for none








getUpdateDimensionProperties
public UpdateDimensionPropertiesRequest getUpdateDimensionProperties()
Updates dimensions' properties.

Returns:
value or null for none








setUpdateDimensionProperties
public Request setUpdateDimensionProperties(UpdateDimensionPropertiesRequest updateDimensionProperties)
Updates dimensions' properties.

Parameters:
updateDimensionProperties - updateDimensionProperties or null for none








getUpdateEmbeddedObjectBorder
public UpdateEmbeddedObjectBorderRequest getUpdateEmbeddedObjectBorder()
Updates an embedded object's border.

Returns:
value or null for none








setUpdateEmbeddedObjectBorder
public Request setUpdateEmbeddedObjectBorder(UpdateEmbeddedObjectBorderRequest updateEmbeddedObjectBorder)
Updates an embedded object's border.

Parameters:
updateEmbeddedObjectBorder - updateEmbeddedObjectBorder or null for none








getUpdateEmbeddedObjectPosition
public UpdateEmbeddedObjectPositionRequest getUpdateEmbeddedObjectPosition()
Updates an embedded object's (e.g. chart, image) position.

Returns:
value or null for none








setUpdateEmbeddedObjectPosition
public Request setUpdateEmbeddedObjectPosition(UpdateEmbeddedObjectPositionRequest updateEmbeddedObjectPosition)
Updates an embedded object's (e.g. chart, image) position.

Parameters:
updateEmbeddedObjectPosition - updateEmbeddedObjectPosition or null for none








getUpdateFilterView
public UpdateFilterViewRequest getUpdateFilterView()
Updates the properties of a filter view.

Returns:
value or null for none








setUpdateFilterView
public Request setUpdateFilterView(UpdateFilterViewRequest updateFilterView)
Updates the properties of a filter view.

Parameters:
updateFilterView - updateFilterView or null for none








getUpdateNamedRange
public UpdateNamedRangeRequest getUpdateNamedRange()
Updates a named range.

Returns:
value or null for none








setUpdateNamedRange
public Request setUpdateNamedRange(UpdateNamedRangeRequest updateNamedRange)
Updates a named range.

Parameters:
updateNamedRange - updateNamedRange or null for none








getUpdateProtectedRange
public UpdateProtectedRangeRequest getUpdateProtectedRange()
Updates a protected range.

Returns:
value or null for none








setUpdateProtectedRange
public Request setUpdateProtectedRange(UpdateProtectedRangeRequest updateProtectedRange)
Updates a protected range.

Parameters:
updateProtectedRange - updateProtectedRange or null for none








getUpdateSheetProperties
public UpdateSheetPropertiesRequest getUpdateSheetProperties()
Updates a sheet's properties.

Returns:
value or null for none








setUpdateSheetProperties
public Request setUpdateSheetProperties(UpdateSheetPropertiesRequest updateSheetProperties)
Updates a sheet's properties.

Parameters:
updateSheetProperties - updateSheetProperties or null for none








getUpdateSlicerSpec
public UpdateSlicerSpecRequest getUpdateSlicerSpec()
Updates a slicer's specifications.

Returns:
value or null for none








setUpdateSlicerSpec
public Request setUpdateSlicerSpec(UpdateSlicerSpecRequest updateSlicerSpec)
Updates a slicer's specifications.

Parameters:
updateSlicerSpec - updateSlicerSpec or null for none








getUpdateSpreadsheetProperties
public UpdateSpreadsheetPropertiesRequest getUpdateSpreadsheetProperties()
Updates the spreadsheet's properties.

Returns:
value or null for none








setUpdateSpreadsheetProperties
public Request setUpdateSpreadsheetProperties(UpdateSpreadsheetPropertiesRequest updateSpreadsheetProperties)
Updates the spreadsheet's properties.

Parameters:
updateSpreadsheetProperties - updateSpreadsheetProperties or null for none








set
public Request set(String fieldName,
                   Object value)

Overrides:
set in class com.google.api.client.json.GenericJson








clone
public Request clone()

Overrides:
clone in class com.google.api.client.json.GenericJson














Skip navigation links




Overview
Package
Class
Use
Tree
Deprecated
Index
Help




Prev Class
Next Class


Frames
No Frames


All Classes






Summary: 
Nested | 
Field | 
Constr | 
Method


Detail: 
Field | 
Constr | 
Method






Copyright © 2011–2024 Google. All rights reserved.