View Source GoogleApi.Sheets.V4.Model.Request (google_api_sheets v0.34.0)

A single kind of update to apply to a spreadsheet.

Attributes

appendCells (type: GoogleApi.Sheets.V4.Model.AppendCellsRequest.t, default: nil) - Appends cells after the last row with data in a sheet.
autoFill (type: GoogleApi.Sheets.V4.Model.AutoFillRequest.t, default: nil) - Automatically fills in more data based on existing data.
trimWhitespace (type: GoogleApi.Sheets.V4.Model.TrimWhitespaceRequest.t, default: nil) - Trims cells of whitespace (such as spaces, tabs, or new lines).
moveDimension (type: GoogleApi.Sheets.V4.Model.MoveDimensionRequest.t, default: nil) - Moves rows or columns to another location in a sheet.
insertRange (type: GoogleApi.Sheets.V4.Model.InsertRangeRequest.t, default: nil) - Inserts new cells in a sheet, shifting the existing cells.
deleteDeveloperMetadata (type: GoogleApi.Sheets.V4.Model.DeleteDeveloperMetadataRequest.t, default: nil) - Deletes developer metadata
addSheet (type: GoogleApi.Sheets.V4.Model.AddSheetRequest.t, default: nil) - Adds a sheet.
addConditionalFormatRule (type: GoogleApi.Sheets.V4.Model.AddConditionalFormatRuleRequest.t, default: nil) - Adds a new conditional format rule.
unmergeCells (type: GoogleApi.Sheets.V4.Model.UnmergeCellsRequest.t, default: nil) - Unmerges merged cells.
addChart (type: GoogleApi.Sheets.V4.Model.AddChartRequest.t, default: nil) - Adds a chart.
deleteDuplicates (type: GoogleApi.Sheets.V4.Model.DeleteDuplicatesRequest.t, default: nil) - Removes rows containing duplicate values in specified columns of a cell range.
randomizeRange (type: GoogleApi.Sheets.V4.Model.RandomizeRangeRequest.t, default: nil) - Randomizes the order of the rows in a range.
deleteSheet (type: GoogleApi.Sheets.V4.Model.DeleteSheetRequest.t, default: nil) - Deletes a sheet.
repeatCell (type: GoogleApi.Sheets.V4.Model.RepeatCellRequest.t, default: nil) - Repeats a single cell across a range.
textToColumns (type: GoogleApi.Sheets.V4.Model.TextToColumnsRequest.t, default: nil) - Converts a column of text into many columns of text.
updateDataSource (type: GoogleApi.Sheets.V4.Model.UpdateDataSourceRequest.t, default: nil) - Updates a data source.
updateChartSpec (type: GoogleApi.Sheets.V4.Model.UpdateChartSpecRequest.t, default: nil) - Updates a chart's specifications.
insertDimension (type: GoogleApi.Sheets.V4.Model.InsertDimensionRequest.t, default: nil) - Inserts new rows or columns in a sheet.
deleteDimension (type: GoogleApi.Sheets.V4.Model.DeleteDimensionRequest.t, default: nil) - Deletes rows or columns in a sheet.
updateBanding (type: GoogleApi.Sheets.V4.Model.UpdateBandingRequest.t, default: nil) - Updates a banded range
updateSpreadsheetProperties (type: GoogleApi.Sheets.V4.Model.UpdateSpreadsheetPropertiesRequest.t, default: nil) - Updates the spreadsheet's properties.
findReplace (type: GoogleApi.Sheets.V4.Model.FindReplaceRequest.t, default: nil) - Finds and replaces occurrences of some text with other text.
updateNamedRange (type: GoogleApi.Sheets.V4.Model.UpdateNamedRangeRequest.t, default: nil) - Updates a named range.
setBasicFilter (type: GoogleApi.Sheets.V4.Model.SetBasicFilterRequest.t, default: nil) - Sets the basic filter on a sheet.
autoResizeDimensions (type: GoogleApi.Sheets.V4.Model.AutoResizeDimensionsRequest.t, default: nil) - Automatically resizes one or more dimensions based on the contents of the cells in that dimension.
deleteConditionalFormatRule (type: GoogleApi.Sheets.V4.Model.DeleteConditionalFormatRuleRequest.t, default: nil) - Deletes an existing conditional format rule.
updateSheetProperties (type: GoogleApi.Sheets.V4.Model.UpdateSheetPropertiesRequest.t, default: nil) - Updates a sheet's properties.
pasteData (type: GoogleApi.Sheets.V4.Model.PasteDataRequest.t, default: nil) - Pastes data (HTML or delimited) into a sheet.
updateEmbeddedObjectBorder (type: GoogleApi.Sheets.V4.Model.UpdateEmbeddedObjectBorderRequest.t, default: nil) - Updates an embedded object's border.
sortRange (type: GoogleApi.Sheets.V4.Model.SortRangeRequest.t, default: nil) - Sorts data in a range.
duplicateFilterView (type: GoogleApi.Sheets.V4.Model.DuplicateFilterViewRequest.t, default: nil) - Duplicates a filter view.
cutPaste (type: GoogleApi.Sheets.V4.Model.CutPasteRequest.t, default: nil) - Cuts data from one area and pastes it to another.
deleteBanding (type: GoogleApi.Sheets.V4.Model.DeleteBandingRequest.t, default: nil) - Removes a banded range
deleteEmbeddedObject (type: GoogleApi.Sheets.V4.Model.DeleteEmbeddedObjectRequest.t, default: nil) - Deletes an embedded object (e.g, chart, image) in a sheet.
refreshDataSource (type: GoogleApi.Sheets.V4.Model.RefreshDataSourceRequest.t, default: nil) - Refreshes one or multiple data sources and associated dbobjects.
clearBasicFilter (type: GoogleApi.Sheets.V4.Model.ClearBasicFilterRequest.t, default: nil) - Clears the basic filter on a sheet.
copyPaste (type: GoogleApi.Sheets.V4.Model.CopyPasteRequest.t, default: nil) - Copies data from one area and pastes it to another.
updateFilterView (type: GoogleApi.Sheets.V4.Model.UpdateFilterViewRequest.t, default: nil) - Updates the properties of a filter view.
updateDimensionGroup (type: GoogleApi.Sheets.V4.Model.UpdateDimensionGroupRequest.t, default: nil) - Updates the state of the specified group.
addSlicer (type: GoogleApi.Sheets.V4.Model.AddSlicerRequest.t, default: nil) - Adds a slicer.
deleteFilterView (type: GoogleApi.Sheets.V4.Model.DeleteFilterViewRequest.t, default: nil) - Deletes a filter view from a sheet.
setDataValidation (type: GoogleApi.Sheets.V4.Model.SetDataValidationRequest.t, default: nil) - Sets data validation for one or more cells.
updateEmbeddedObjectPosition (type: GoogleApi.Sheets.V4.Model.UpdateEmbeddedObjectPositionRequest.t, default: nil) - Updates an embedded object's (e.g. chart, image) position.
updateConditionalFormatRule (type: GoogleApi.Sheets.V4.Model.UpdateConditionalFormatRuleRequest.t, default: nil) - Updates an existing conditional format rule.
deleteRange (type: GoogleApi.Sheets.V4.Model.DeleteRangeRequest.t, default: nil) - Deletes a range of cells from a sheet, shifting the remaining cells.
deleteDimensionGroup (type: GoogleApi.Sheets.V4.Model.DeleteDimensionGroupRequest.t, default: nil) - Deletes a group over the specified range.
appendDimension (type: GoogleApi.Sheets.V4.Model.AppendDimensionRequest.t, default: nil) - Appends dimensions to the end of a sheet.
updateSlicerSpec (type: GoogleApi.Sheets.V4.Model.UpdateSlicerSpecRequest.t, default: nil) - Updates a slicer's specifications.
deleteDataSource (type: GoogleApi.Sheets.V4.Model.DeleteDataSourceRequest.t, default: nil) - Deletes a data source.
createDeveloperMetadata (type: GoogleApi.Sheets.V4.Model.CreateDeveloperMetadataRequest.t, default: nil) - Creates new developer metadata
addFilterView (type: GoogleApi.Sheets.V4.Model.AddFilterViewRequest.t, default: nil) - Adds a filter view.
addBanding (type: GoogleApi.Sheets.V4.Model.AddBandingRequest.t, default: nil) - Adds a new banded range
deleteProtectedRange (type: GoogleApi.Sheets.V4.Model.DeleteProtectedRangeRequest.t, default: nil) - Deletes a protected range.
updateDimensionProperties (type: GoogleApi.Sheets.V4.Model.UpdateDimensionPropertiesRequest.t, default: nil) - Updates dimensions' properties.
updateProtectedRange (type: GoogleApi.Sheets.V4.Model.UpdateProtectedRangeRequest.t, default: nil) - Updates a protected range.
addDimensionGroup (type: GoogleApi.Sheets.V4.Model.AddDimensionGroupRequest.t, default: nil) - Creates a group over the specified range.
updateCells (type: GoogleApi.Sheets.V4.Model.UpdateCellsRequest.t, default: nil) - Updates many cells at once.
cancelDataSourceRefresh (type: GoogleApi.Sheets.V4.Model.CancelDataSourceRefreshRequest.t, default: nil) - Cancels refreshes of one or multiple data sources and associated dbobjects.
addProtectedRange (type: GoogleApi.Sheets.V4.Model.AddProtectedRangeRequest.t, default: nil) - Adds a protected range.
addDataSource (type: GoogleApi.Sheets.V4.Model.AddDataSourceRequest.t, default: nil) - Adds a data source.
addNamedRange (type: GoogleApi.Sheets.V4.Model.AddNamedRangeRequest.t, default: nil) - Adds a named range.
updateDeveloperMetadata (type: GoogleApi.Sheets.V4.Model.UpdateDeveloperMetadataRequest.t, default: nil) - Updates an existing developer metadata entry
deleteNamedRange (type: GoogleApi.Sheets.V4.Model.DeleteNamedRangeRequest.t, default: nil) - Deletes a named range.
duplicateSheet (type: GoogleApi.Sheets.V4.Model.DuplicateSheetRequest.t, default: nil) - Duplicates a sheet.
updateBorders (type: GoogleApi.Sheets.V4.Model.UpdateBordersRequest.t, default: nil) - Updates the borders in a range of cells.
mergeCells (type: GoogleApi.Sheets.V4.Model.MergeCellsRequest.t, default: nil) - Merges cells together.

Summary

Types

t()

Functions

decode(value, options)

Unwrap a decoded JSON object into its complex fields.

Types

t()

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

Functions

decode(value, options)

@spec decode(struct(), keyword()) :: struct()

Unwrap a decoded JSON object into its complex fields.