GetDistinctRange Method

In This Topic

Refine distinct rows or columns from Reference list.

Syntax

Visual Basic
C#

'Declaration
 
Public Shared Function GetDistinctRange( _
   ByVal references() As Reference, _
   ByVal refineRow As Boolean, _
   ByRef startIndices() As Integer, _
   ByRef endIndices() As Integer _
) As Integer

'Usage
 
Dim references() As Reference
Dim refineRow As Boolean
Dim startIndices() As Integer
Dim endIndices() As Integer
Dim value As Integer
 
value = SpreadsheetHelper.GetDistinctRange(references, refineRow, startIndices, endIndices)

public static int GetDistinctRange( 
   Reference[] references,
   bool refineRow,
   out int[] startIndices,
   out int[] endIndices
)

Parameters

references: Source cell references
refineRow: indicate row or column should be refine.
startIndices: List of start indices has refined.
endIndices: List of end indices has refined.

Reference

SpreadsheetHelper Class
SpreadsheetHelper Members