Class Request

A single kind of update to apply to a spreadsheet.

Inheritance

object

Request

Implements

IDirectResponseSchema

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: Google.Apis.Sheets.v4.Data

Assembly: Google.Apis.Sheets.v4.dll

Syntax

public class Request : IDirectResponseSchema

Properties

AddBanding

Adds a new banded range

Declaration

[JsonProperty("addBanding")]
public virtual AddBandingRequest AddBanding { get; set; }

Property Value

Type	Description
AddBandingRequest

AddChart

Adds a chart.

Declaration

[JsonProperty("addChart")]
public virtual AddChartRequest AddChart { get; set; }

Property Value

Type	Description
AddChartRequest

AddConditionalFormatRule

Adds a new conditional format rule.

Declaration

[JsonProperty("addConditionalFormatRule")]
public virtual AddConditionalFormatRuleRequest AddConditionalFormatRule { get; set; }

Property Value

Type	Description
AddConditionalFormatRuleRequest

AddDataSource

Adds a data source.

Declaration

[JsonProperty("addDataSource")]
public virtual AddDataSourceRequest AddDataSource { get; set; }

Property Value

Type	Description
AddDataSourceRequest

AddDimensionGroup

Creates a group over the specified range.

Declaration

[JsonProperty("addDimensionGroup")]
public virtual AddDimensionGroupRequest AddDimensionGroup { get; set; }

Property Value

Type	Description
AddDimensionGroupRequest

AddFilterView

Adds a filter view.

Declaration

[JsonProperty("addFilterView")]
public virtual AddFilterViewRequest AddFilterView { get; set; }

Property Value

Type	Description
AddFilterViewRequest

AddNamedRange

Adds a named range.

Declaration

[JsonProperty("addNamedRange")]
public virtual AddNamedRangeRequest AddNamedRange { get; set; }

Property Value

Type	Description
AddNamedRangeRequest

AddProtectedRange

Adds a protected range.

Declaration

[JsonProperty("addProtectedRange")]
public virtual AddProtectedRangeRequest AddProtectedRange { get; set; }

Property Value

Type	Description
AddProtectedRangeRequest

AddSheet

Adds a sheet.

Declaration

[JsonProperty("addSheet")]
public virtual AddSheetRequest AddSheet { get; set; }

Property Value

Type	Description
AddSheetRequest

AddSlicer

Adds a slicer.

Declaration

[JsonProperty("addSlicer")]
public virtual AddSlicerRequest AddSlicer { get; set; }

Property Value

Type	Description
AddSlicerRequest

AddTable

Adds a table.

Declaration

[JsonProperty("addTable")]
public virtual AddTableRequest AddTable { get; set; }

Property Value

Type	Description
AddTableRequest

AppendCells

Appends cells after the last row with data in a sheet.

Declaration

[JsonProperty("appendCells")]
public virtual AppendCellsRequest AppendCells { get; set; }

Property Value

Type	Description
AppendCellsRequest

AppendDimension

Appends dimensions to the end of a sheet.

Declaration

[JsonProperty("appendDimension")]
public virtual AppendDimensionRequest AppendDimension { get; set; }

Property Value

Type	Description
AppendDimensionRequest

AutoFill

Automatically fills in more data based on existing data.

Declaration

[JsonProperty("autoFill")]
public virtual AutoFillRequest AutoFill { get; set; }

Property Value

Type	Description
AutoFillRequest

AutoResizeDimensions

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

Declaration

[JsonProperty("autoResizeDimensions")]
public virtual AutoResizeDimensionsRequest AutoResizeDimensions { get; set; }

Property Value

Type	Description
AutoResizeDimensionsRequest

CancelDataSourceRefresh

Cancels refreshes of one or multiple data sources and associated dbobjects.

Declaration

[JsonProperty("cancelDataSourceRefresh")]
public virtual CancelDataSourceRefreshRequest CancelDataSourceRefresh { get; set; }

Property Value

Type	Description
CancelDataSourceRefreshRequest

ClearBasicFilter

Clears the basic filter on a sheet.

Declaration

[JsonProperty("clearBasicFilter")]
public virtual ClearBasicFilterRequest ClearBasicFilter { get; set; }

Property Value

Type	Description
ClearBasicFilterRequest

CopyPaste

Copies data from one area and pastes it to another.

Declaration

[JsonProperty("copyPaste")]
public virtual CopyPasteRequest CopyPaste { get; set; }

Property Value

Type	Description
CopyPasteRequest

CreateDeveloperMetadata

Creates new developer metadata

Declaration

[JsonProperty("createDeveloperMetadata")]
public virtual CreateDeveloperMetadataRequest CreateDeveloperMetadata { get; set; }

Property Value

Type	Description
CreateDeveloperMetadataRequest

CutPaste

Cuts data from one area and pastes it to another.

Declaration

[JsonProperty("cutPaste")]
public virtual CutPasteRequest CutPaste { get; set; }

Property Value

Type	Description
CutPasteRequest

DeleteBanding

Removes a banded range

Declaration

[JsonProperty("deleteBanding")]
public virtual DeleteBandingRequest DeleteBanding { get; set; }

Property Value

Type	Description
DeleteBandingRequest

DeleteConditionalFormatRule

Deletes an existing conditional format rule.

Declaration

[JsonProperty("deleteConditionalFormatRule")]
public virtual DeleteConditionalFormatRuleRequest DeleteConditionalFormatRule { get; set; }

Property Value

Type	Description
DeleteConditionalFormatRuleRequest

DeleteDataSource

Deletes a data source.

Declaration

[JsonProperty("deleteDataSource")]
public virtual DeleteDataSourceRequest DeleteDataSource { get; set; }

Property Value

Type	Description
DeleteDataSourceRequest

DeleteDeveloperMetadata

Deletes developer metadata

Declaration

[JsonProperty("deleteDeveloperMetadata")]
public virtual DeleteDeveloperMetadataRequest DeleteDeveloperMetadata { get; set; }

Property Value

Type	Description
DeleteDeveloperMetadataRequest

DeleteDimension

Deletes rows or columns in a sheet.

Declaration

[JsonProperty("deleteDimension")]
public virtual DeleteDimensionRequest DeleteDimension { get; set; }

Property Value

Type	Description
DeleteDimensionRequest

DeleteDimensionGroup

Deletes a group over the specified range.

Declaration

[JsonProperty("deleteDimensionGroup")]
public virtual DeleteDimensionGroupRequest DeleteDimensionGroup { get; set; }

Property Value

Type	Description
DeleteDimensionGroupRequest

DeleteDuplicates

Removes rows containing duplicate values in specified columns of a cell range.

Declaration

[JsonProperty("deleteDuplicates")]
public virtual DeleteDuplicatesRequest DeleteDuplicates { get; set; }

Property Value

Type	Description
DeleteDuplicatesRequest

DeleteEmbeddedObject

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

Declaration

[JsonProperty("deleteEmbeddedObject")]
public virtual DeleteEmbeddedObjectRequest DeleteEmbeddedObject { get; set; }

Property Value

Type	Description
DeleteEmbeddedObjectRequest

DeleteFilterView

Deletes a filter view from a sheet.

Declaration

[JsonProperty("deleteFilterView")]
public virtual DeleteFilterViewRequest DeleteFilterView { get; set; }

Property Value

Type	Description
DeleteFilterViewRequest

DeleteNamedRange

Deletes a named range.

Declaration

[JsonProperty("deleteNamedRange")]
public virtual DeleteNamedRangeRequest DeleteNamedRange { get; set; }

Property Value

Type	Description
DeleteNamedRangeRequest

DeleteProtectedRange

Deletes a protected range.

Declaration

[JsonProperty("deleteProtectedRange")]
public virtual DeleteProtectedRangeRequest DeleteProtectedRange { get; set; }

Property Value

Type	Description
DeleteProtectedRangeRequest

DeleteRange

Deletes a range of cells from a sheet, shifting the remaining cells.

Declaration

[JsonProperty("deleteRange")]
public virtual DeleteRangeRequest DeleteRange { get; set; }

Property Value

Type	Description
DeleteRangeRequest

DeleteSheet

Deletes a sheet.

Declaration

[JsonProperty("deleteSheet")]
public virtual DeleteSheetRequest DeleteSheet { get; set; }

Property Value

Type	Description
DeleteSheetRequest

DeleteTable

A request for deleting a table.

Declaration

[JsonProperty("deleteTable")]
public virtual DeleteTableRequest DeleteTable { get; set; }

Property Value

Type	Description
DeleteTableRequest

DuplicateFilterView

Duplicates a filter view.

Declaration

[JsonProperty("duplicateFilterView")]
public virtual DuplicateFilterViewRequest DuplicateFilterView { get; set; }

Property Value

Type	Description
DuplicateFilterViewRequest

DuplicateSheet

Duplicates a sheet.

Declaration

[JsonProperty("duplicateSheet")]
public virtual DuplicateSheetRequest DuplicateSheet { get; set; }

Property Value

Type	Description
DuplicateSheetRequest

ETag

The ETag of the item.

Declaration

public virtual string ETag { get; set; }

Property Value

Type	Description
string

FindReplace

Finds and replaces occurrences of some text with other text.

Declaration

[JsonProperty("findReplace")]
public virtual FindReplaceRequest FindReplace { get; set; }

Property Value

Type	Description
FindReplaceRequest

InsertDimension

Inserts new rows or columns in a sheet.

Declaration

[JsonProperty("insertDimension")]
public virtual InsertDimensionRequest InsertDimension { get; set; }

Property Value

Type	Description
InsertDimensionRequest

InsertRange

Inserts new cells in a sheet, shifting the existing cells.

Declaration

[JsonProperty("insertRange")]
public virtual InsertRangeRequest InsertRange { get; set; }

Property Value

Type	Description
InsertRangeRequest

MergeCells

Merges cells together.

Declaration

[JsonProperty("mergeCells")]
public virtual MergeCellsRequest MergeCells { get; set; }

Property Value

Type	Description
MergeCellsRequest

MoveDimension

Moves rows or columns to another location in a sheet.

Declaration

[JsonProperty("moveDimension")]
public virtual MoveDimensionRequest MoveDimension { get; set; }

Property Value

Type	Description
MoveDimensionRequest

PasteData

Pastes data (HTML or delimited) into a sheet.

Declaration

[JsonProperty("pasteData")]
public virtual PasteDataRequest PasteData { get; set; }

Property Value

Type	Description
PasteDataRequest

RandomizeRange

Randomizes the order of the rows in a range.

Declaration

[JsonProperty("randomizeRange")]
public virtual RandomizeRangeRequest RandomizeRange { get; set; }

Property Value

Type	Description
RandomizeRangeRequest

RefreshDataSource

Refreshes one or multiple data sources and associated dbobjects.

Declaration

[JsonProperty("refreshDataSource")]
public virtual RefreshDataSourceRequest RefreshDataSource { get; set; }

Property Value

Type	Description
RefreshDataSourceRequest

RepeatCell

Repeats a single cell across a range.

Declaration

[JsonProperty("repeatCell")]
public virtual RepeatCellRequest RepeatCell { get; set; }

Property Value

Type	Description
RepeatCellRequest

SetBasicFilter

Sets the basic filter on a sheet.

Declaration

[JsonProperty("setBasicFilter")]
public virtual SetBasicFilterRequest SetBasicFilter { get; set; }

Property Value

Type	Description
SetBasicFilterRequest

SetDataValidation

Sets data validation for one or more cells.

Declaration

[JsonProperty("setDataValidation")]
public virtual SetDataValidationRequest SetDataValidation { get; set; }

Property Value

Type	Description
SetDataValidationRequest

SortRange

Sorts data in a range.

Declaration

[JsonProperty("sortRange")]
public virtual SortRangeRequest SortRange { get; set; }

Property Value

Type	Description
SortRangeRequest

TextToColumns

Converts a column of text into many columns of text.

Declaration

[JsonProperty("textToColumns")]
public virtual TextToColumnsRequest TextToColumns { get; set; }

Property Value

Type	Description
TextToColumnsRequest

TrimWhitespace

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

Declaration

[JsonProperty("trimWhitespace")]
public virtual TrimWhitespaceRequest TrimWhitespace { get; set; }

Property Value

Type	Description
TrimWhitespaceRequest

UnmergeCells

Unmerges merged cells.

Declaration

[JsonProperty("unmergeCells")]
public virtual UnmergeCellsRequest UnmergeCells { get; set; }

Property Value

Type	Description
UnmergeCellsRequest

UpdateBanding

Updates a banded range

Declaration

[JsonProperty("updateBanding")]
public virtual UpdateBandingRequest UpdateBanding { get; set; }

Property Value

Type	Description
UpdateBandingRequest

UpdateBorders

Updates the borders in a range of cells.

Declaration

[JsonProperty("updateBorders")]
public virtual UpdateBordersRequest UpdateBorders { get; set; }

Property Value

Type	Description
UpdateBordersRequest

UpdateCells

Updates many cells at once.

Declaration

[JsonProperty("updateCells")]
public virtual UpdateCellsRequest UpdateCells { get; set; }

Property Value

Type	Description
UpdateCellsRequest

UpdateChartSpec

Updates a chart's specifications.

Declaration

[JsonProperty("updateChartSpec")]
public virtual UpdateChartSpecRequest UpdateChartSpec { get; set; }

Property Value

Type	Description
UpdateChartSpecRequest

UpdateConditionalFormatRule

Updates an existing conditional format rule.

Declaration

[JsonProperty("updateConditionalFormatRule")]
public virtual UpdateConditionalFormatRuleRequest UpdateConditionalFormatRule { get; set; }

Property Value

Type	Description
UpdateConditionalFormatRuleRequest

UpdateDataSource

Updates a data source.

Declaration

[JsonProperty("updateDataSource")]
public virtual UpdateDataSourceRequest UpdateDataSource { get; set; }

Property Value

Type	Description
UpdateDataSourceRequest

UpdateDeveloperMetadata

Updates an existing developer metadata entry

Declaration

[JsonProperty("updateDeveloperMetadata")]
public virtual UpdateDeveloperMetadataRequest UpdateDeveloperMetadata { get; set; }

Property Value

Type	Description
UpdateDeveloperMetadataRequest

UpdateDimensionGroup

Updates the state of the specified group.

Declaration

[JsonProperty("updateDimensionGroup")]
public virtual UpdateDimensionGroupRequest UpdateDimensionGroup { get; set; }

Property Value

Type	Description
UpdateDimensionGroupRequest

UpdateDimensionProperties

Updates dimensions' properties.

Declaration

[JsonProperty("updateDimensionProperties")]
public virtual UpdateDimensionPropertiesRequest UpdateDimensionProperties { get; set; }

Property Value

Type	Description
UpdateDimensionPropertiesRequest

UpdateEmbeddedObjectBorder

Updates an embedded object's border.

Declaration

[JsonProperty("updateEmbeddedObjectBorder")]
public virtual UpdateEmbeddedObjectBorderRequest UpdateEmbeddedObjectBorder { get; set; }

Property Value

Type	Description
UpdateEmbeddedObjectBorderRequest

UpdateEmbeddedObjectPosition

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

Declaration

[JsonProperty("updateEmbeddedObjectPosition")]
public virtual UpdateEmbeddedObjectPositionRequest UpdateEmbeddedObjectPosition { get; set; }

Property Value

Type	Description
UpdateEmbeddedObjectPositionRequest

UpdateFilterView

Updates the properties of a filter view.

Declaration

[JsonProperty("updateFilterView")]
public virtual UpdateFilterViewRequest UpdateFilterView { get; set; }

Property Value

Type	Description
UpdateFilterViewRequest

UpdateNamedRange

Updates a named range.

Declaration

[JsonProperty("updateNamedRange")]
public virtual UpdateNamedRangeRequest UpdateNamedRange { get; set; }

Property Value

Type	Description
UpdateNamedRangeRequest

UpdateProtectedRange

Updates a protected range.

Declaration

[JsonProperty("updateProtectedRange")]
public virtual UpdateProtectedRangeRequest UpdateProtectedRange { get; set; }

Property Value

Type	Description
UpdateProtectedRangeRequest

UpdateSheetProperties

Updates a sheet's properties.

Declaration

[JsonProperty("updateSheetProperties")]
public virtual UpdateSheetPropertiesRequest UpdateSheetProperties { get; set; }

Property Value

Type	Description
UpdateSheetPropertiesRequest

UpdateSlicerSpec

Updates a slicer's specifications.

Declaration

[JsonProperty("updateSlicerSpec")]
public virtual UpdateSlicerSpecRequest UpdateSlicerSpec { get; set; }

Property Value

Type	Description
UpdateSlicerSpecRequest

UpdateSpreadsheetProperties

Updates the spreadsheet's properties.

Declaration

[JsonProperty("updateSpreadsheetProperties")]
public virtual UpdateSpreadsheetPropertiesRequest UpdateSpreadsheetProperties { get; set; }

Property Value

Type	Description
UpdateSpreadsheetPropertiesRequest

UpdateTable

Updates a table.

Declaration

[JsonProperty("updateTable")]
public virtual UpdateTableRequest UpdateTable { get; set; }

Property Value

Type	Description
UpdateTableRequest

Implements

IDirectResponseSchema