Request class

A single kind of update to apply to a spreadsheet.

Constructors

Request({AddBandingRequest? addBanding, AddChartRequest? addChart, AddConditionalFormatRuleRequest? addConditionalFormatRule, AddDataSourceRequest? addDataSource, AddDimensionGroupRequest? addDimensionGroup, AddFilterViewRequest? addFilterView, AddNamedRangeRequest? addNamedRange, AddProtectedRangeRequest? addProtectedRange, AddSheetRequest? addSheet, AddSlicerRequest? addSlicer, AppendCellsRequest? appendCells, AppendDimensionRequest? appendDimension, AutoFillRequest? autoFill, AutoResizeDimensionsRequest? autoResizeDimensions, CancelDataSourceRefreshRequest? cancelDataSourceRefresh, ClearBasicFilterRequest? clearBasicFilter, CopyPasteRequest? copyPaste, CreateDeveloperMetadataRequest? createDeveloperMetadata, CutPasteRequest? cutPaste, DeleteBandingRequest? deleteBanding, DeleteConditionalFormatRuleRequest? deleteConditionalFormatRule, DeleteDataSourceRequest? deleteDataSource, DeleteDeveloperMetadataRequest? deleteDeveloperMetadata, DeleteDimensionRequest? deleteDimension, DeleteDimensionGroupRequest? deleteDimensionGroup, DeleteDuplicatesRequest? deleteDuplicates, DeleteEmbeddedObjectRequest? deleteEmbeddedObject, DeleteFilterViewRequest? deleteFilterView, DeleteNamedRangeRequest? deleteNamedRange, DeleteProtectedRangeRequest? deleteProtectedRange, DeleteRangeRequest? deleteRange, DeleteSheetRequest? deleteSheet, DuplicateFilterViewRequest? duplicateFilterView, DuplicateSheetRequest? duplicateSheet, FindReplaceRequest? findReplace, InsertDimensionRequest? insertDimension, InsertRangeRequest? insertRange, MergeCellsRequest? mergeCells, MoveDimensionRequest? moveDimension, PasteDataRequest? pasteData, RandomizeRangeRequest? randomizeRange, RefreshDataSourceRequest? refreshDataSource, RepeatCellRequest? repeatCell, SetBasicFilterRequest? setBasicFilter, SetDataValidationRequest? setDataValidation, SortRangeRequest? sortRange, TextToColumnsRequest? textToColumns, TrimWhitespaceRequest? trimWhitespace, UnmergeCellsRequest? unmergeCells, UpdateBandingRequest? updateBanding, UpdateBordersRequest? updateBorders, UpdateCellsRequest? updateCells, UpdateChartSpecRequest? updateChartSpec, UpdateConditionalFormatRuleRequest? updateConditionalFormatRule, UpdateDataSourceRequest? updateDataSource, UpdateDeveloperMetadataRequest? updateDeveloperMetadata, UpdateDimensionGroupRequest? updateDimensionGroup, UpdateDimensionPropertiesRequest? updateDimensionProperties, UpdateEmbeddedObjectBorderRequest? updateEmbeddedObjectBorder, UpdateEmbeddedObjectPositionRequest? updateEmbeddedObjectPosition, UpdateFilterViewRequest? updateFilterView, UpdateNamedRangeRequest? updateNamedRange, UpdateProtectedRangeRequest? updateProtectedRange, UpdateSheetPropertiesRequest? updateSheetProperties, UpdateSlicerSpecRequest? updateSlicerSpec, UpdateSpreadsheetPropertiesRequest? updateSpreadsheetProperties})

Request.fromJson(Map json_)

Properties

addBanding ↔ AddBandingRequest?

Adds a new banded range

getter/setter pair

addChart ↔ AddChartRequest?

Adds a chart.

getter/setter pair

addConditionalFormatRule ↔ AddConditionalFormatRuleRequest?

Adds a new conditional format rule.

getter/setter pair

addDataSource ↔ AddDataSourceRequest?

Adds a data source.

getter/setter pair

addDimensionGroup ↔ AddDimensionGroupRequest?

Creates a group over the specified range.

getter/setter pair

addFilterView ↔ AddFilterViewRequest?

Adds a filter view.

getter/setter pair

addNamedRange ↔ AddNamedRangeRequest?

Adds a named range.

getter/setter pair

addProtectedRange ↔ AddProtectedRangeRequest?

Adds a protected range.

getter/setter pair

addSheet ↔ AddSheetRequest?

Adds a sheet.

getter/setter pair

addSlicer ↔ AddSlicerRequest?

Adds a slicer.

getter/setter pair

appendCells ↔ AppendCellsRequest?

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

getter/setter pair

appendDimension ↔ AppendDimensionRequest?

Appends dimensions to the end of a sheet.

getter/setter pair

autoFill ↔ AutoFillRequest?

Automatically fills in more data based on existing data.

getter/setter pair

autoResizeDimensions ↔ AutoResizeDimensionsRequest?

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

getter/setter pair

cancelDataSourceRefresh ↔ CancelDataSourceRefreshRequest?

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

getter/setter pair

clearBasicFilter ↔ ClearBasicFilterRequest?

Clears the basic filter on a sheet.

getter/setter pair

copyPaste ↔ CopyPasteRequest?

Copies data from one area and pastes it to another.

getter/setter pair

createDeveloperMetadata ↔ CreateDeveloperMetadataRequest?

Creates new developer metadata

getter/setter pair

cutPaste ↔ CutPasteRequest?

Cuts data from one area and pastes it to another.

getter/setter pair

deleteBanding ↔ DeleteBandingRequest?

Removes a banded range

getter/setter pair

deleteConditionalFormatRule ↔ DeleteConditionalFormatRuleRequest?

Deletes an existing conditional format rule.

getter/setter pair

deleteDataSource ↔ DeleteDataSourceRequest?

Deletes a data source.

getter/setter pair

deleteDeveloperMetadata ↔ DeleteDeveloperMetadataRequest?

Deletes developer metadata

getter/setter pair

deleteDimension ↔ DeleteDimensionRequest?

Deletes rows or columns in a sheet.

getter/setter pair

deleteDimensionGroup ↔ DeleteDimensionGroupRequest?

Deletes a group over the specified range.

getter/setter pair

deleteDuplicates ↔ DeleteDuplicatesRequest?

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

getter/setter pair

deleteEmbeddedObject ↔ DeleteEmbeddedObjectRequest?

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

getter/setter pair

deleteFilterView ↔ DeleteFilterViewRequest?

Deletes a filter view from a sheet.

getter/setter pair

deleteNamedRange ↔ DeleteNamedRangeRequest?

Deletes a named range.

getter/setter pair

deleteProtectedRange ↔ DeleteProtectedRangeRequest?

Deletes a protected range.

getter/setter pair

deleteRange ↔ DeleteRangeRequest?

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

getter/setter pair

deleteSheet ↔ DeleteSheetRequest?

Deletes a sheet.

getter/setter pair

duplicateFilterView ↔ DuplicateFilterViewRequest?

Duplicates a filter view.

getter/setter pair

duplicateSheet ↔ DuplicateSheetRequest?

Duplicates a sheet.

getter/setter pair

findReplace ↔ FindReplaceRequest?

Finds and replaces occurrences of some text with other text.

getter/setter pair

hashCode → int

The hash code for this object.

no setter, inherited

insertDimension ↔ InsertDimensionRequest?

Inserts new rows or columns in a sheet.

getter/setter pair

insertRange ↔ InsertRangeRequest?

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

getter/setter pair

mergeCells ↔ MergeCellsRequest?

Merges cells together.

getter/setter pair

moveDimension ↔ MoveDimensionRequest?

Moves rows or columns to another location in a sheet.

getter/setter pair

pasteData ↔ PasteDataRequest?

Pastes data (HTML or delimited) into a sheet.

getter/setter pair

randomizeRange ↔ RandomizeRangeRequest?

Randomizes the order of the rows in a range.

getter/setter pair

refreshDataSource ↔ RefreshDataSourceRequest?

Refreshes one or multiple data sources and associated dbobjects.

getter/setter pair

repeatCell ↔ RepeatCellRequest?

Repeats a single cell across a range.

getter/setter pair

runtimeType → Type

A representation of the runtime type of the object.

no setter, inherited

setBasicFilter ↔ SetBasicFilterRequest?

Sets the basic filter on a sheet.

getter/setter pair

setDataValidation ↔ SetDataValidationRequest?

Sets data validation for one or more cells.

getter/setter pair

sortRange ↔ SortRangeRequest?

Sorts data in a range.

getter/setter pair

textToColumns ↔ TextToColumnsRequest?

Converts a column of text into many columns of text.

getter/setter pair

trimWhitespace ↔ TrimWhitespaceRequest?

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

getter/setter pair

unmergeCells ↔ UnmergeCellsRequest?

Unmerges merged cells.

getter/setter pair

updateBanding ↔ UpdateBandingRequest?

Updates a banded range

getter/setter pair

updateBorders ↔ UpdateBordersRequest?

Updates the borders in a range of cells.

getter/setter pair

updateCells ↔ UpdateCellsRequest?

Updates many cells at once.

getter/setter pair

updateChartSpec ↔ UpdateChartSpecRequest?

Updates a chart's specifications.

getter/setter pair

updateConditionalFormatRule ↔ UpdateConditionalFormatRuleRequest?

Updates an existing conditional format rule.

getter/setter pair

updateDataSource ↔ UpdateDataSourceRequest?

Updates a data source.

getter/setter pair

updateDeveloperMetadata ↔ UpdateDeveloperMetadataRequest?

Updates an existing developer metadata entry

getter/setter pair

updateDimensionGroup ↔ UpdateDimensionGroupRequest?

Updates the state of the specified group.

getter/setter pair

updateDimensionProperties ↔ UpdateDimensionPropertiesRequest?

Updates dimensions' properties.

getter/setter pair

updateEmbeddedObjectBorder ↔ UpdateEmbeddedObjectBorderRequest?

Updates an embedded object's border.

getter/setter pair

updateEmbeddedObjectPosition ↔ UpdateEmbeddedObjectPositionRequest?

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

getter/setter pair

updateFilterView ↔ UpdateFilterViewRequest?

Updates the properties of a filter view.

getter/setter pair

updateNamedRange ↔ UpdateNamedRangeRequest?

Updates a named range.

getter/setter pair

updateProtectedRange ↔ UpdateProtectedRangeRequest?

Updates a protected range.

getter/setter pair

updateSheetProperties ↔ UpdateSheetPropertiesRequest?

Updates a sheet's properties.

getter/setter pair

updateSlicerSpec ↔ UpdateSlicerSpecRequest?

Updates a slicer's specifications.

getter/setter pair

updateSpreadsheetProperties ↔ UpdateSpreadsheetPropertiesRequest?

Updates the spreadsheet's properties.

getter/setter pair

Methods

noSuchMethod(Invocation invocation) → dynamic

Invoked when a nonexistent method or property is accessed.

inherited

toJson() → Map<String, dynamic>

toString() → String

A string representation of this object.

inherited

Operators

operator ==(Object other) → bool

The equality operator.

inherited