Class: Google::Apis::SheetsV4::DeleteDuplicatesRequest
- Inherits:
-
Object
- Object
- Google::Apis::SheetsV4::DeleteDuplicatesRequest
- 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
Removes rows within this range that contain values in the specified columns that are duplicates of values in any previous row. Rows with identical values but different letter cases, formatting, or formulas are considered to be duplicates. This request also removes duplicate rows hidden from view (for example, due to a filter). When removing duplicates, the first instance of each duplicate row scanning from the top downwards is kept in the resulting range. Content outside of the specified range isn't removed, and rows considered duplicates do not have to be adjacent to each other in the range.
Instance Attribute Summary collapse
-
#comparison_columns ⇒ Array<Google::Apis::SheetsV4::DimensionRange>
The columns in the range to analyze for duplicate values.
-
#range ⇒ Google::Apis::SheetsV4::GridRange
A range on a sheet.
Instance Method Summary collapse
-
#initialize(**args) ⇒ DeleteDuplicatesRequest
constructor
A new instance of DeleteDuplicatesRequest.
-
#update!(**args) ⇒ Object
Update properties of this object.
Methods included from Core::JsonObjectSupport
Methods included from Core::Hashable
Constructor Details
#initialize(**args) ⇒ DeleteDuplicatesRequest
Returns a new instance of DeleteDuplicatesRequest.
4446 4447 4448 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 4446 def initialize(**args) update!(**args) end |
Instance Attribute Details
#comparison_columns ⇒ Array<Google::Apis::SheetsV4::DimensionRange>
The columns in the range to analyze for duplicate values. If no columns are
selected then all columns are analyzed for duplicates.
Corresponds to the JSON property comparisonColumns
4418 4419 4420 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 4418 def comparison_columns @comparison_columns end |
#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 range
4444 4445 4446 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 4444 def range @range end |
Instance Method Details
#update!(**args) ⇒ Object
Update properties of this object
4451 4452 4453 4454 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 4451 def update!(**args) @comparison_columns = args[:comparison_columns] if args.key?(:comparison_columns) @range = args[:range] if args.key?(:range) end |