Spread Windows Forms 17
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / IRange Interface / RemoveDuplicates Method
Array of indexes of the columns that contain the duplicate information. Specify null if you want to remove duplicates in all columns.
Specifies whether the first row contains header information. Specify YesNoGuess.Guess if you want Spread to attempt to determine the header.


In This Topic
    RemoveDuplicates Method (IRange)
    In This Topic
    Removes duplicate values from a range of values.
    Syntax
    'Declaration
     
    
    Function RemoveDuplicates( _
       Optional ByVal columns() As Integer, _
       Optional ByVal header As YesNoGuess _
    ) As Integer
    'Usage
     
    
    Dim instance As IRange
    Dim columns() As Integer
    Dim header As YesNoGuess
    Dim value As Integer
     
    value = instance.RemoveDuplicates(columns, header)
    int RemoveDuplicates( 
       int[] columns,
       YesNoGuess header
    )

    Parameters

    columns
    Array of indexes of the columns that contain the duplicate information. Specify null if you want to remove duplicates in all columns.
    header
    Specifies whether the first row contains header information. Specify YesNoGuess.Guess if you want Spread to attempt to determine the header.

    Return Value

    The total numbers of removed rows.
    See Also