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, AddTableRequest? addTable, 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, DeleteTableRequest? deleteTable, 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, UpdateTableRequest? updateTable})
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
addTable ↔ AddTableRequest?
Adds a table.
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
deleteTable ↔ DeleteTableRequest?
A request for deleting a table.
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 setterinherited
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 setterinherited
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
updateTable ↔ UpdateTableRequest?
Updates a table.
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