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

A sheet in a spreadsheet.

Attributes

  • bandedRanges (type: list(GoogleApi.Sheets.V4.Model.BandedRange.t), default: nil) - The banded (alternating colors) ranges on this sheet.
  • basicFilter (type: GoogleApi.Sheets.V4.Model.BasicFilter.t, default: nil) - The filter on this sheet, if any.
  • charts (type: list(GoogleApi.Sheets.V4.Model.EmbeddedChart.t), default: nil) - The specifications of every chart on this sheet.
  • columnGroups (type: list(GoogleApi.Sheets.V4.Model.DimensionGroup.t), default: nil) - All column groups on this sheet, ordered by increasing range start index, then by group depth.
  • conditionalFormats (type: list(GoogleApi.Sheets.V4.Model.ConditionalFormatRule.t), default: nil) - The conditional format rules in this sheet.
  • data (type: list(GoogleApi.Sheets.V4.Model.GridData.t), default: nil) - Data in the grid, if this is a grid sheet. The number of GridData objects returned is dependent on the number of ranges requested on this sheet. For example, if this is representing Sheet1, and the spreadsheet was requested with ranges Sheet1!A1:C10 and Sheet1!D15:E20, then the first GridData will have a startRow/startColumn of 0, while the second one will have startRow 14 (zero-based row 15), and startColumn 3 (zero-based column D). For a DATA_SOURCE sheet, you can not request a specific range, the GridData contains all the values.
  • developerMetadata (type: list(GoogleApi.Sheets.V4.Model.DeveloperMetadata.t), default: nil) - The developer metadata associated with a sheet.
  • filterViews (type: list(GoogleApi.Sheets.V4.Model.FilterView.t), default: nil) - The filter views in this sheet.
  • merges (type: list(GoogleApi.Sheets.V4.Model.GridRange.t), default: nil) - The ranges that are merged together.
  • properties (type: GoogleApi.Sheets.V4.Model.SheetProperties.t, default: nil) - The properties of the sheet.
  • protectedRanges (type: list(GoogleApi.Sheets.V4.Model.ProtectedRange.t), default: nil) - The protected ranges in this sheet.
  • rowGroups (type: list(GoogleApi.Sheets.V4.Model.DimensionGroup.t), default: nil) - All row groups on this sheet, ordered by increasing range start index, then by group depth.
  • slicers (type: list(GoogleApi.Sheets.V4.Model.Slicer.t), default: nil) - The slicers on this sheet.

Summary

Functions

Unwrap a decoded JSON object into its complex fields.

Types

t()

@type t() :: %GoogleApi.Sheets.V4.Model.Sheet{
  bandedRanges: [GoogleApi.Sheets.V4.Model.BandedRange.t()] | nil,
  basicFilter: GoogleApi.Sheets.V4.Model.BasicFilter.t() | nil,
  charts: [GoogleApi.Sheets.V4.Model.EmbeddedChart.t()] | nil,
  columnGroups: [GoogleApi.Sheets.V4.Model.DimensionGroup.t()] | nil,
  conditionalFormats:
    [GoogleApi.Sheets.V4.Model.ConditionalFormatRule.t()] | nil,
  data: [GoogleApi.Sheets.V4.Model.GridData.t()] | nil,
  developerMetadata: [GoogleApi.Sheets.V4.Model.DeveloperMetadata.t()] | nil,
  filterViews: [GoogleApi.Sheets.V4.Model.FilterView.t()] | nil,
  merges: [GoogleApi.Sheets.V4.Model.GridRange.t()] | nil,
  properties: GoogleApi.Sheets.V4.Model.SheetProperties.t() | nil,
  protectedRanges: [GoogleApi.Sheets.V4.Model.ProtectedRange.t()] | nil,
  rowGroups: [GoogleApi.Sheets.V4.Model.DimensionGroup.t()] | nil,
  slicers: [GoogleApi.Sheets.V4.Model.Slicer.t()] | nil
}

Functions

decode(value, options)

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

Unwrap a decoded JSON object into its complex fields.