class Google::Apis::SheetsV4::Sheet
A sheet in a spreadsheet.
Attributes
The banded (alternating colors) ranges on this sheet. Corresponds to the JSON property `bandedRanges` @return [Array<Google::Apis::SheetsV4::BandedRange>]
The default filter associated with a sheet. Corresponds to the JSON property `basicFilter` @return [Google::Apis::SheetsV4::BasicFilter]
The specifications of every chart on this sheet. Corresponds to the JSON property `charts` @return [Array<Google::Apis::SheetsV4::EmbeddedChart>]
All column groups on this sheet, ordered by increasing range start index, then by group depth. Corresponds to the JSON property `columnGroups` @return [Array<Google::Apis::SheetsV4::DimensionGroup>]
The conditional format rules in this sheet. Corresponds to the JSON property `conditionalFormats` @return [Array<Google::Apis::SheetsV4::ConditionalFormatRule>]
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. Corresponds to the JSON property `data` @return [Array<Google::Apis::SheetsV4::GridData>]
The developer metadata associated with a sheet. Corresponds to the JSON property `developerMetadata` @return [Array<Google::Apis::SheetsV4::DeveloperMetadata>]
The filter views in this sheet. Corresponds to the JSON property `filterViews` @return [Array<Google::Apis::SheetsV4::FilterView>]
The ranges that are merged together. Corresponds to the JSON property `merges` @return [Array<Google::Apis::SheetsV4::GridRange>]
Properties of a sheet. Corresponds to the JSON property `properties` @return [Google::Apis::SheetsV4::SheetProperties]
The protected ranges in this sheet. Corresponds to the JSON property `protectedRanges` @return [Array<Google::Apis::SheetsV4::ProtectedRange>]
All row groups on this sheet, ordered by increasing range start index, then by group depth. Corresponds to the JSON property `rowGroups` @return [Array<Google::Apis::SheetsV4::DimensionGroup>]
The slicers on this sheet. Corresponds to the JSON property `slicers` @return [Array<Google::Apis::SheetsV4::Slicer>]
Public Class Methods
# File lib/google/apis/sheets_v4/classes.rb, line 8753 def initialize(**args) update!(**args) end
Public Instance Methods
Update properties of this object
# File lib/google/apis/sheets_v4/classes.rb, line 8758 def update!(**args) @banded_ranges = args[:banded_ranges] if args.key?(:banded_ranges) @basic_filter = args[:basic_filter] if args.key?(:basic_filter) @charts = args[:charts] if args.key?(:charts) @column_groups = args[:column_groups] if args.key?(:column_groups) @conditional_formats = args[:conditional_formats] if args.key?(:conditional_formats) @data = args[:data] if args.key?(:data) @developer_metadata = args[:developer_metadata] if args.key?(:developer_metadata) @filter_views = args[:filter_views] if args.key?(:filter_views) @merges = args[:merges] if args.key?(:merges) @properties = args[:properties] if args.key?(:properties) @protected_ranges = args[:protected_ranges] if args.key?(:protected_ranges) @row_groups = args[:row_groups] if args.key?(:row_groups) @slicers = args[:slicers] if args.key?(:slicers) end