Class DeleteDuplicatesRequest

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.

Inheritance

object

DeleteDuplicatesRequest

Implements

IDirectResponseSchema

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: Google.Apis.Sheets.v4.Data

Assembly: Google.Apis.Sheets.v4.dll

Syntax

public class DeleteDuplicatesRequest : IDirectResponseSchema

Properties

ComparisonColumns

The columns in the range to analyze for duplicate values. If no columns are selected then all columns are analyzed for duplicates.

Declaration

[JsonProperty("comparisonColumns")]
public virtual IList<DimensionRange> ComparisonColumns { get; set; }

Property Value

Type	Description
IList<DimensionRange>

ETag

The ETag of the item.

Declaration

public virtual string ETag { get; set; }

Property Value

Type	Description
string

Range

The range to remove duplicates rows from.

Declaration

[JsonProperty("range")]
public virtual GridRange Range { get; set; }

Property Value

Type	Description
GridRange

Implements

IDirectResponseSchema