[]
DEMOS DOCS API BLOG SUPPORT PRICING DOWNLOAD
(Showing Draft Content)

GrapeCity.Spreadsheet.IRange.RemoveDuplicates

RemoveDuplicates Method

RemoveDuplicates(int[], YesNoGuess)

Removes duplicate values from a range of values.

Declaration
int RemoveDuplicates(int[] columns = null, YesNoGuess header = YesNoGuess.No)
Function RemoveDuplicates(Optional columns As Integer() = Nothing, Optional header As YesNoGuess = YesNoGuess.No) As Integer
Parameters
Type Name Description
int[] columns

Array of indexes of the columns that contain the duplicate information. Specify null if you want to remove duplicates in all columns.
YesNoGuess header

Specifies whether the first row contains header information. Specify Guess if you want Spread to attempt to determine the header.
Returns
Type Description
int

The total numbers of removed rows.