Class: Google::Apis::SheetsV4::DataFilter
- Inherits:
-
Object
- Object
- Google::Apis::SheetsV4::DataFilter
- 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
-
#a1_range ⇒ String
Selects data that matches the specified A1 range.
-
#developer_metadata_lookup ⇒ Google::Apis::SheetsV4::DeveloperMetadataLookup
Selects DeveloperMetadata that matches all of the specified fields.
-
#grid_range ⇒ Google::Apis::SheetsV4::GridRange
A range on a sheet.
Instance Method Summary collapse
-
#initialize(**args) ⇒ DataFilter
constructor
A new instance of DataFilter.
-
#update!(**args) ⇒ Object
Update properties of this object.
Methods included from Core::JsonObjectSupport
Methods included from Core::Hashable
Constructor Details
#initialize(**args) ⇒ DataFilter
Returns a new instance of DataFilter
3322 3323 3324 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 3322 def initialize(**args) update!(**args) end |
Instance Attribute Details
#a1_range ⇒ String
Selects data that matches the specified A1 range.
Corresponds to the JSON property a1Range
3281 3282 3283 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 3281 def a1_range @a1_range end |
#developer_metadata_lookup ⇒ Google::Apis::SheetsV4::DeveloperMetadataLookup
Selects DeveloperMetadata that matches all of the specified fields. For
example, if only a metadata ID is specified this considers the
DeveloperMetadata with that particular unique ID. If a metadata key is
specified, this considers all developer metadata with that key. If a
key, visibility, and location type are all specified, this considers all
developer metadata with that key and visibility that are associated with a
location of that type. 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
3294 3295 3296 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 3294 def @developer_metadata_lookup end |
#grid_range ⇒ Google::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
3320 3321 3322 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 3320 def grid_range @grid_range end |
Instance Method Details
#update!(**args) ⇒ Object
Update properties of this object
3327 3328 3329 3330 3331 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 3327 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 |