Class: Google::Apis::SheetsV4::DeleteDuplicatesRequest

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

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

Instance Method Summary collapse

Methods included from Core::JsonObjectSupport

#to_json

Methods included from Core::Hashable

process_value, #to_h

Constructor Details

#initialize(**args) ⇒ DeleteDuplicatesRequest

Returns a new instance of DeleteDuplicatesRequest



4219
4220
4221
 
# File 'generated/google/apis/sheets_v4/classes.rb', line 4219

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

Returns:



4191
4192
4193
 
# File 'generated/google/apis/sheets_v4/classes.rb', line 4191

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

Returns:



4217
4218
4219
 
# File 'generated/google/apis/sheets_v4/classes.rb', line 4217

def range
  @range
end

Instance Method Details

#update!(**args) ⇒ Object

Update properties of this object



4224
4225
4226
4227
 
# File 'generated/google/apis/sheets_v4/classes.rb', line 4224

def update!(**args)
  @comparison_columns = args[:comparison_columns] if args.key?(:comparison_columns)
  @range = args[:range] if args.key?(:range)
end