class Google::Apis::SheetsV4::Sheet

A sheet in a spreadsheet.

Attributes

banded_ranges[RW]

The banded (alternating colors) ranges on this sheet. Corresponds to the JSON property `bandedRanges` @return [Array<Google::Apis::SheetsV4::BandedRange>]

basic_filter[RW]

The default filter associated with a sheet. Corresponds to the JSON property `basicFilter` @return [Google::Apis::SheetsV4::BasicFilter]

charts[RW]

The specifications of every chart on this sheet. Corresponds to the JSON property `charts` @return [Array<Google::Apis::SheetsV4::EmbeddedChart>]

column_groups[RW]

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>]

conditional_formats[RW]

The conditional format rules in this sheet. Corresponds to the JSON property `conditionalFormats` @return [Array<Google::Apis::SheetsV4::ConditionalFormatRule>]

data[RW]

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>]

developer_metadata[RW]

The developer metadata associated with a sheet. Corresponds to the JSON property `developerMetadata` @return [Array<Google::Apis::SheetsV4::DeveloperMetadata>]

filter_views[RW]

The filter views in this sheet. Corresponds to the JSON property `filterViews` @return [Array<Google::Apis::SheetsV4::FilterView>]

merges[RW]

The ranges that are merged together. Corresponds to the JSON property `merges` @return [Array<Google::Apis::SheetsV4::GridRange>]

properties[RW]

Properties of a sheet. Corresponds to the JSON property `properties` @return [Google::Apis::SheetsV4::SheetProperties]

protected_ranges[RW]

The protected ranges in this sheet. Corresponds to the JSON property `protectedRanges` @return [Array<Google::Apis::SheetsV4::ProtectedRange>]

row_groups[RW]

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>]

slicers[RW]

The slicers on this sheet. Corresponds to the JSON property `slicers` @return [Array<Google::Apis::SheetsV4::Slicer>]

Public Class Methods

new(**args) click to toggle source
# File lib/google/apis/sheets_v4/classes.rb, line 8753
def initialize(**args)
   update!(**args)
end

Public Instance Methods

update!(**args) click to toggle source

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