Class: Google::Apis::SheetsV4::DataFilter

Inherits:
Object
  • Object
show all
Includes:
Core::Hashable, Core::JsonObjectSupport
Defined in:
generated/google/apis/sheets_v4/classes.rb,
generated/google/apis/sheets_v4/representations.rb,
generated/google/apis/sheets_v4/representations.rb

Overview

Filter that describes what data should be selected or returned from a request.

Instance Attribute Summary collapse

Instance Method Summary collapse

Methods included from Core::JsonObjectSupport

#to_json

Methods included from Core::Hashable

process_value, #to_h

Constructor Details

#initialize(**args) ⇒ DataFilter

Returns a new instance of DataFilter



3284
3285
3286
# File 'generated/google/apis/sheets_v4/classes.rb', line 3284

def initialize(**args)
   update!(**args)
end

Instance Attribute Details

#a1_rangeString

Selects data that matches the specified A1 range. Corresponds to the JSON property a1Range

Returns:

  • (String)


3243
3244
3245
# File 'generated/google/apis/sheets_v4/classes.rb', line 3243

def a1_range
  @a1_range
end

#developer_metadata_lookupGoogle::Apis::SheetsV4::DeveloperMetadataLookup

Selects DeveloperMetadata that matches all of the specified fields. For example, if only a metadata ID is specified this will consider the DeveloperMetadata with that particular unique ID. If a metadata key is specified, all developer metadata with that key will be considered. If a key, visibility, and location type are all specified, then all developer metadata with that key, visibility, and associated with a location of that type will be considered. In general, this selects all DeveloperMetadata that matches the intersection of all the specified fields; any field or combination of fields may be specified. Corresponds to the JSON property developerMetadataLookup



3256
3257
3258
# File 'generated/google/apis/sheets_v4/classes.rb', line 3256

def 
  @developer_metadata_lookup
end

#grid_rangeGoogle::Apis::SheetsV4::GridRange

A range on a sheet. All indexes are zero-based. Indexes are half open, e.g the start index is inclusive and the end index is exclusive -- [start_index, end_index). Missing indexes indicate the range is unbounded on that side. For example, if "Sheet1" is sheet ID 0, then: Sheet1!A1:A1 == sheet_id: 0, start_row_index: 0, end_row_index: 1, start_column_index: 0, end_column_index: 1 Sheet1!A3:B4 == sheet_id: 0, start_row_index: 2, end_row_index: 4, start_column_index: 0, end_column_index: 2 Sheet1!A:B == sheet_id: 0, start_column_index: 0, end_column_index: 2 Sheet1!A5:B == sheet_id: 0, start_row_index: 4, start_column_index: 0, end_column_index: 2 Sheet1 == sheet_id:0 The start index must always be less than or equal to the end index. If the start index equals the end index, then the range is empty. Empty ranges are typically not meaningful and are usually rendered in the UI as #REF!. Corresponds to the JSON property gridRange



3282
3283
3284
# File 'generated/google/apis/sheets_v4/classes.rb', line 3282

def grid_range
  @grid_range
end

Instance Method Details

#update!(**args) ⇒ Object

Update properties of this object



3289
3290
3291
3292
3293
# File 'generated/google/apis/sheets_v4/classes.rb', line 3289

def update!(**args)
  @a1_range = args[:a1_range] if args.key?(:a1_range)
  @developer_metadata_lookup = args[:developer_metadata_lookup] if args.key?(:developer_metadata_lookup)
  @grid_range = args[:grid_range] if args.key?(:grid_range)
end