Request (Google Sheets API v4 (Rev. 542) 1.22.0)

java.lang.Object
- java.util.AbstractMap<java.lang.String,java.lang.Object>
- - com.google.api.client.util.GenericData
  - - com.google.api.client.json.GenericJson
    - - com.google.api.services.sheets.v4.model.Request

All Implemented Interfaces:

java.lang.Cloneable, java.util.Map<java.lang.String,java.lang.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
  java.util.AbstractMap.SimpleEntry<K,V>, java.util.AbstractMap.SimpleImmutableEntry<K,V>
- Nested classes/interfaces inherited from interface java.util.Map
  java.util.Map.Entry<K,V>

Constructor Summary

Constructors
Constructor and Description

Request()

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.
`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.
`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.
`DeleteDeveloperMetadataRequest`	`getDeleteDeveloperMetadata()` Deletes developer metadata
`DeleteDimensionRequest`	`getDeleteDimension()` Deletes rows or columns in a sheet.
`DeleteDimensionGroupRequest`	`getDeleteDimensionGroup()` Deletes a group over the specified 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.
`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.
`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.
`UpdateDeveloperMetadataRequest`	`getUpdateDeveloperMetadata()` Updates an existing developer metadata entry
`UpdateDimensionGroupRequest`	`getUpdateDimensionGroup()` Updates the state of the specified group.
`UpdateDimensionPropertiesRequest`	`getUpdateDimensionProperties()` Updates dimensions' properties.
`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.
`UpdateSpreadsheetPropertiesRequest`	`getUpdateSpreadsheetProperties()` Updates the spreadsheet's properties.
`Request`	`set(java.lang.String fieldName, java.lang.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`	`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`	`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`	`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`	`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`	`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`	`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`	`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`	`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`	`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, get, getClassInfo, getUnknownKeys, put, putAll, remove, setUnknownKeys

Methods inherited from class java.util.AbstractMap
clear, containsKey, containsValue, equals, hashCode, 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
  - 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
  - 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
  - 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
  - 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
  - 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
  - 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
  - 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
  - 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
  - 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(java.lang.String fieldName,
                   java.lang.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

Google Sheets API v4 (revision 542)

Class Request

Nested Class Summary

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

Nested classes/interfaces inherited from class java.util.AbstractMap

Nested classes/interfaces inherited from interface java.util.Map

Constructor Summary

Method Summary

Methods inherited from class com.google.api.client.json.GenericJson

Methods inherited from class com.google.api.client.util.GenericData

Methods inherited from class java.util.AbstractMap

Methods inherited from class java.lang.Object

Methods inherited from interface java.util.Map

Constructor Detail

Request

Method Detail

getAddBanding

setAddBanding

getAddChart

setAddChart

getAddConditionalFormatRule

setAddConditionalFormatRule

getAddDimensionGroup

setAddDimensionGroup

getAddFilterView

setAddFilterView

getAddNamedRange

setAddNamedRange

getAddProtectedRange

setAddProtectedRange

getAddSheet

setAddSheet

getAppendCells

setAppendCells

getAppendDimension

setAppendDimension

getAutoFill

setAutoFill

getAutoResizeDimensions

setAutoResizeDimensions

getClearBasicFilter

setClearBasicFilter

getCopyPaste

setCopyPaste

getCreateDeveloperMetadata

setCreateDeveloperMetadata

getCutPaste

setCutPaste

getDeleteBanding

setDeleteBanding

getDeleteConditionalFormatRule

setDeleteConditionalFormatRule

getDeleteDeveloperMetadata

setDeleteDeveloperMetadata

getDeleteDimension

setDeleteDimension

getDeleteDimensionGroup

setDeleteDimensionGroup

getDeleteEmbeddedObject

setDeleteEmbeddedObject

getDeleteFilterView

setDeleteFilterView

getDeleteNamedRange

setDeleteNamedRange

getDeleteProtectedRange

setDeleteProtectedRange

getDeleteRange

setDeleteRange

getDeleteSheet

setDeleteSheet

getDuplicateFilterView

setDuplicateFilterView

getDuplicateSheet

setDuplicateSheet

getFindReplace

setFindReplace

getInsertDimension

setInsertDimension

getInsertRange

setInsertRange