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 representingSheet1
, and the spreadsheet was requested with rangesSheet1!A1:C10
andSheet1!D15:E20
, then the first GridData will have a startRow/startColumn of0
, while the second one will havestartRow 14
(zero-based row 15), andstartColumn 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
@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 }