sheets  v4
Properties | List of all members
Google.Apis.Sheets.v4.Data.Request Class Reference

A single kind of update to apply to a spreadsheet. More...

Inheritance diagram for Google.Apis.Sheets.v4.Data.Request:
Google::Apis::Requests::IDirectResponseSchema

Properties

virtual AddBandingRequest AddBanding [get, set]
 Adds a new banded range More...
 
virtual AddChartRequest AddChart [get, set]
 Adds a chart. More...
 
virtual AddConditionalFormatRuleRequest AddConditionalFormatRule [get, set]
 Adds a new conditional format rule. More...
 
virtual AddDimensionGroupRequest AddDimensionGroup [get, set]
 Creates a group over the specified range. More...
 
virtual AddFilterViewRequest AddFilterView [get, set]
 Adds a filter view. More...
 
virtual AddNamedRangeRequest AddNamedRange [get, set]
 Adds a named range. More...
 
virtual AddProtectedRangeRequest AddProtectedRange [get, set]
 Adds a protected range. More...
 
virtual AddSheetRequest AddSheet [get, set]
 Adds a sheet. More...
 
virtual AddSlicerRequest AddSlicer [get, set]
 Adds a slicer. More...
 
virtual AppendCellsRequest AppendCells [get, set]
 Appends cells after the last row with data in a sheet. More...
 
virtual AppendDimensionRequest AppendDimension [get, set]
 Appends dimensions to the end of a sheet. More...
 
virtual AutoFillRequest AutoFill [get, set]
 Automatically fills in more data based on existing data. More...
 
virtual AutoResizeDimensionsRequest AutoResizeDimensions [get, set]
 Automatically resizes one or more dimensions based on the contents of the cells in that dimension. More...
 
virtual ClearBasicFilterRequest ClearBasicFilter [get, set]
 Clears the basic filter on a sheet. More...
 
virtual CopyPasteRequest CopyPaste [get, set]
 Copies data from one area and pastes it to another. More...
 
virtual CreateDeveloperMetadataRequest CreateDeveloperMetadata [get, set]
 Creates new developer metadata More...
 
virtual CutPasteRequest CutPaste [get, set]
 Cuts data from one area and pastes it to another. More...
 
virtual DeleteBandingRequest DeleteBanding [get, set]
 Removes a banded range More...
 
virtual DeleteConditionalFormatRuleRequest DeleteConditionalFormatRule [get, set]
 Deletes an existing conditional format rule. More...
 
virtual DeleteDeveloperMetadataRequest DeleteDeveloperMetadata [get, set]
 Deletes developer metadata More...
 
virtual DeleteDimensionRequest DeleteDimension [get, set]
 Deletes rows or columns in a sheet. More...
 
virtual DeleteDimensionGroupRequest DeleteDimensionGroup [get, set]
 Deletes a group over the specified range. More...
 
virtual DeleteDuplicatesRequest DeleteDuplicates [get, set]
 Removes rows containing duplicate values in specified columns of a cell range. More...
 
virtual DeleteEmbeddedObjectRequest DeleteEmbeddedObject [get, set]
 Deletes an embedded object (e.g, chart, image) in a sheet. More...
 
virtual DeleteFilterViewRequest DeleteFilterView [get, set]
 Deletes a filter view from a sheet. More...
 
virtual DeleteNamedRangeRequest DeleteNamedRange [get, set]
 Deletes a named range. More...
 
virtual DeleteProtectedRangeRequest DeleteProtectedRange [get, set]
 Deletes a protected range. More...
 
virtual DeleteRangeRequest DeleteRange [get, set]
 Deletes a range of cells from a sheet, shifting the remaining cells. More...
 
virtual DeleteSheetRequest DeleteSheet [get, set]
 Deletes a sheet. More...
 
virtual DuplicateFilterViewRequest DuplicateFilterView [get, set]
 Duplicates a filter view. More...
 
virtual DuplicateSheetRequest DuplicateSheet [get, set]
 Duplicates a sheet. More...
 
virtual FindReplaceRequest FindReplace [get, set]
 Finds and replaces occurrences of some text with other text. More...
 
virtual InsertDimensionRequest InsertDimension [get, set]
 Inserts new rows or columns in a sheet. More...
 
virtual InsertRangeRequest InsertRange [get, set]
 Inserts new cells in a sheet, shifting the existing cells. More...
 
virtual MergeCellsRequest MergeCells [get, set]
 Merges cells together. More...
 
virtual MoveDimensionRequest MoveDimension [get, set]
 Moves rows or columns to another location in a sheet. More...
 
virtual PasteDataRequest PasteData [get, set]
 Pastes data (HTML or delimited) into a sheet. More...
 
virtual RandomizeRangeRequest RandomizeRange [get, set]
 Randomizes the order of the rows in a range. More...
 
virtual RepeatCellRequest RepeatCell [get, set]
 Repeats a single cell across a range. More...
 
virtual SetBasicFilterRequest SetBasicFilter [get, set]
 Sets the basic filter on a sheet. More...
 
virtual SetDataValidationRequest SetDataValidation [get, set]
 Sets data validation for one or more cells. More...
 
virtual SortRangeRequest SortRange [get, set]
 Sorts data in a range. More...
 
virtual TextToColumnsRequest TextToColumns [get, set]
 Converts a column of text into many columns of text. More...
 
virtual TrimWhitespaceRequest TrimWhitespace [get, set]
 Trims cells of whitespace (such as spaces, tabs, or new lines). More...
 
virtual UnmergeCellsRequest UnmergeCells [get, set]
 Unmerges merged cells. More...
 
virtual UpdateBandingRequest UpdateBanding [get, set]
 Updates a banded range More...
 
virtual UpdateBordersRequest UpdateBorders [get, set]
 Updates the borders in a range of cells. More...
 
virtual UpdateCellsRequest UpdateCells [get, set]
 Updates many cells at once. More...
 
virtual UpdateChartSpecRequest UpdateChartSpec [get, set]
 Updates a chart's specifications. More...
 
virtual UpdateConditionalFormatRuleRequest UpdateConditionalFormatRule [get, set]
 Updates an existing conditional format rule. More...
 
virtual UpdateDeveloperMetadataRequest UpdateDeveloperMetadata [get, set]
 Updates an existing developer metadata entry More...
 
virtual UpdateDimensionGroupRequest UpdateDimensionGroup [get, set]
 Updates the state of the specified group. More...
 
virtual UpdateDimensionPropertiesRequest UpdateDimensionProperties [get, set]
 Updates dimensions' properties. More...
 
virtual UpdateEmbeddedObjectPositionRequest UpdateEmbeddedObjectPosition [get, set]
 Updates an embedded object's (e.g. chart, image) position. More...
 
virtual UpdateFilterViewRequest UpdateFilterView [get, set]
 Updates the properties of a filter view. More...
 
virtual UpdateNamedRangeRequest UpdateNamedRange [get, set]
 Updates a named range. More...
 
virtual UpdateProtectedRangeRequest UpdateProtectedRange [get, set]
 Updates a protected range. More...
 
virtual UpdateSheetPropertiesRequest UpdateSheetProperties [get, set]
 Updates a sheet's properties. More...
 
virtual UpdateSlicerSpecRequest UpdateSlicerSpec [get, set]
 Updates a slicer's specifications. More...
 
virtual UpdateSpreadsheetPropertiesRequest UpdateSpreadsheetProperties [get, set]
 Updates the spreadsheet's properties. More...
 
virtual string ETag [get, set]
 The ETag of the item. More...
 
- Properties inherited from Google::Apis::Requests::IDirectResponseSchema
string ETag
 

Detailed Description

A single kind of update to apply to a spreadsheet.

Property Documentation

◆ AddBanding

virtual AddBandingRequest Google.Apis.Sheets.v4.Data.Request.AddBanding
getset

Adds a new banded range

◆ AddChart

virtual AddChartRequest Google.Apis.Sheets.v4.Data.Request.AddChart
getset

Adds a chart.

◆ AddConditionalFormatRule

virtual AddConditionalFormatRuleRequest Google.Apis.Sheets.v4.Data.Request.AddConditionalFormatRule
getset

Adds a new conditional format rule.

◆ AddDimensionGroup

virtual AddDimensionGroupRequest Google.Apis.Sheets.v4.Data.Request.AddDimensionGroup
getset

Creates a group over the specified range.

◆ AddFilterView

virtual AddFilterViewRequest Google.Apis.Sheets.v4.Data.Request.AddFilterView
getset

Adds a filter view.

◆ AddNamedRange

virtual AddNamedRangeRequest Google.Apis.Sheets.v4.Data.Request.AddNamedRange
getset

Adds a named range.

◆ AddProtectedRange

virtual AddProtectedRangeRequest Google.Apis.Sheets.v4.Data.Request.AddProtectedRange
getset

Adds a protected range.

◆ AddSheet

virtual AddSheetRequest Google.Apis.Sheets.v4.Data.Request.AddSheet
getset

Adds a sheet.

◆ AddSlicer

virtual AddSlicerRequest Google.Apis.Sheets.v4.Data.Request.AddSlicer
getset

Adds a slicer.

◆ AppendCells

virtual AppendCellsRequest Google.Apis.Sheets.v4.Data.Request.AppendCells
getset

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

◆ AppendDimension

virtual AppendDimensionRequest Google.Apis.Sheets.v4.Data.Request.AppendDimension
getset

Appends dimensions to the end of a sheet.

◆ AutoFill

virtual AutoFillRequest Google.Apis.Sheets.v4.Data.Request.AutoFill
getset

Automatically fills in more data based on existing data.

◆ AutoResizeDimensions

virtual AutoResizeDimensionsRequest Google.Apis.Sheets.v4.Data.Request.AutoResizeDimensions
getset

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

◆ ClearBasicFilter

virtual ClearBasicFilterRequest Google.Apis.Sheets.v4.Data.Request.ClearBasicFilter
getset

Clears the basic filter on a sheet.

◆ CopyPaste

virtual CopyPasteRequest Google.Apis.Sheets.v4.Data.Request.CopyPaste
getset

Copies data from one area and pastes it to another.

◆ CreateDeveloperMetadata

virtual CreateDeveloperMetadataRequest Google.Apis.Sheets.v4.Data.Request.CreateDeveloperMetadata
getset

Creates new developer metadata

◆ CutPaste

virtual CutPasteRequest Google.Apis.Sheets.v4.Data.Request.CutPaste
getset

Cuts data from one area and pastes it to another.

◆ DeleteBanding

virtual DeleteBandingRequest Google.Apis.Sheets.v4.Data.Request.DeleteBanding
getset

Removes a banded range

◆ DeleteConditionalFormatRule

virtual DeleteConditionalFormatRuleRequest Google.Apis.Sheets.v4.Data.Request.DeleteConditionalFormatRule
getset

Deletes an existing conditional format rule.

◆ DeleteDeveloperMetadata

virtual DeleteDeveloperMetadataRequest Google.Apis.Sheets.v4.Data.Request.DeleteDeveloperMetadata
getset

Deletes developer metadata

◆ DeleteDimension

virtual DeleteDimensionRequest Google.Apis.Sheets.v4.Data.Request.DeleteDimension
getset

Deletes rows or columns in a sheet.

◆ DeleteDimensionGroup

virtual DeleteDimensionGroupRequest Google.Apis.Sheets.v4.Data.Request.DeleteDimensionGroup
getset

Deletes a group over the specified range.

◆ DeleteDuplicates

virtual DeleteDuplicatesRequest Google.Apis.Sheets.v4.Data.Request.DeleteDuplicates
getset

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

◆ DeleteEmbeddedObject

virtual DeleteEmbeddedObjectRequest Google.Apis.Sheets.v4.Data.Request.DeleteEmbeddedObject
getset

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

◆ DeleteFilterView

virtual DeleteFilterViewRequest Google.Apis.Sheets.v4.Data.Request.DeleteFilterView
getset

Deletes a filter view from a sheet.

◆ DeleteNamedRange

virtual DeleteNamedRangeRequest Google.Apis.Sheets.v4.Data.Request.DeleteNamedRange
getset

Deletes a named range.

◆ DeleteProtectedRange

virtual DeleteProtectedRangeRequest Google.Apis.Sheets.v4.Data.Request.DeleteProtectedRange
getset

Deletes a protected range.

◆ DeleteRange

virtual DeleteRangeRequest Google.Apis.Sheets.v4.Data.Request.DeleteRange
getset

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

◆ DeleteSheet

virtual DeleteSheetRequest Google.Apis.Sheets.v4.Data.Request.DeleteSheet
getset

Deletes a sheet.

◆ DuplicateFilterView

virtual DuplicateFilterViewRequest Google.Apis.Sheets.v4.Data.Request.DuplicateFilterView
getset

Duplicates a filter view.

◆ DuplicateSheet

virtual DuplicateSheetRequest Google.Apis.Sheets.v4.Data.Request.DuplicateSheet
getset

Duplicates a sheet.

◆ ETag

virtual string Google.Apis.Sheets.v4.Data.Request.ETag
getset

The ETag of the item.

◆ FindReplace

virtual FindReplaceRequest Google.Apis.Sheets.v4.Data.Request.FindReplace
getset

Finds and replaces occurrences of some text with other text.

◆ InsertDimension

virtual InsertDimensionRequest Google.Apis.Sheets.v4.Data.Request.InsertDimension
getset

Inserts new rows or columns in a sheet.

◆ InsertRange

virtual InsertRangeRequest Google.Apis.Sheets.v4.Data.Request.InsertRange
getset

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

◆ MergeCells

virtual MergeCellsRequest Google.Apis.Sheets.v4.Data.Request.MergeCells
getset

Merges cells together.

◆ MoveDimension

virtual MoveDimensionRequest Google.Apis.Sheets.v4.Data.Request.MoveDimension
getset

Moves rows or columns to another location in a sheet.

◆ PasteData

virtual PasteDataRequest Google.Apis.Sheets.v4.Data.Request.PasteData
getset

Pastes data (HTML or delimited) into a sheet.

◆ RandomizeRange

virtual RandomizeRangeRequest Google.Apis.Sheets.v4.Data.Request.RandomizeRange
getset

Randomizes the order of the rows in a range.

◆ RepeatCell

virtual RepeatCellRequest Google.Apis.Sheets.v4.Data.Request.RepeatCell
getset

Repeats a single cell across a range.

◆ SetBasicFilter

virtual SetBasicFilterRequest Google.Apis.Sheets.v4.Data.Request.SetBasicFilter
getset

Sets the basic filter on a sheet.

◆ SetDataValidation

virtual SetDataValidationRequest Google.Apis.Sheets.v4.Data.Request.SetDataValidation
getset

Sets data validation for one or more cells.

◆ SortRange

virtual SortRangeRequest Google.Apis.Sheets.v4.Data.Request.SortRange
getset

Sorts data in a range.

◆ TextToColumns

virtual TextToColumnsRequest Google.Apis.Sheets.v4.Data.Request.TextToColumns
getset

Converts a column of text into many columns of text.

◆ TrimWhitespace

virtual TrimWhitespaceRequest Google.Apis.Sheets.v4.Data.Request.TrimWhitespace
getset

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

◆ UnmergeCells

virtual UnmergeCellsRequest Google.Apis.Sheets.v4.Data.Request.UnmergeCells
getset

Unmerges merged cells.

◆ UpdateBanding

virtual UpdateBandingRequest Google.Apis.Sheets.v4.Data.Request.UpdateBanding
getset

Updates a banded range

◆ UpdateBorders

virtual UpdateBordersRequest Google.Apis.Sheets.v4.Data.Request.UpdateBorders
getset

Updates the borders in a range of cells.

◆ UpdateCells

virtual UpdateCellsRequest Google.Apis.Sheets.v4.Data.Request.UpdateCells
getset

Updates many cells at once.

◆ UpdateChartSpec

virtual UpdateChartSpecRequest Google.Apis.Sheets.v4.Data.Request.UpdateChartSpec
getset

Updates a chart's specifications.

◆ UpdateConditionalFormatRule

virtual UpdateConditionalFormatRuleRequest Google.Apis.Sheets.v4.Data.Request.UpdateConditionalFormatRule
getset

Updates an existing conditional format rule.

◆ UpdateDeveloperMetadata

virtual UpdateDeveloperMetadataRequest Google.Apis.Sheets.v4.Data.Request.UpdateDeveloperMetadata
getset

Updates an existing developer metadata entry

◆ UpdateDimensionGroup

virtual UpdateDimensionGroupRequest Google.Apis.Sheets.v4.Data.Request.UpdateDimensionGroup
getset

Updates the state of the specified group.

◆ UpdateDimensionProperties

virtual UpdateDimensionPropertiesRequest Google.Apis.Sheets.v4.Data.Request.UpdateDimensionProperties
getset

Updates dimensions' properties.

◆ UpdateEmbeddedObjectPosition

virtual UpdateEmbeddedObjectPositionRequest Google.Apis.Sheets.v4.Data.Request.UpdateEmbeddedObjectPosition
getset

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

◆ UpdateFilterView

virtual UpdateFilterViewRequest Google.Apis.Sheets.v4.Data.Request.UpdateFilterView
getset

Updates the properties of a filter view.

◆ UpdateNamedRange

virtual UpdateNamedRangeRequest Google.Apis.Sheets.v4.Data.Request.UpdateNamedRange
getset

Updates a named range.

◆ UpdateProtectedRange

virtual UpdateProtectedRangeRequest Google.Apis.Sheets.v4.Data.Request.UpdateProtectedRange
getset

Updates a protected range.

◆ UpdateSheetProperties

virtual UpdateSheetPropertiesRequest Google.Apis.Sheets.v4.Data.Request.UpdateSheetProperties
getset

Updates a sheet's properties.

◆ UpdateSlicerSpec

virtual UpdateSlicerSpecRequest Google.Apis.Sheets.v4.Data.Request.UpdateSlicerSpec
getset

Updates a slicer's specifications.

◆ UpdateSpreadsheetProperties

virtual UpdateSpreadsheetPropertiesRequest Google.Apis.Sheets.v4.Data.Request.UpdateSpreadsheetProperties
getset

Updates the spreadsheet's properties.


The documentation for this class was generated from the following file: