GetFilterData(Worksheet,Int32,Int32,Int32,Int32,Boolean) Method

In This Topic

Gets filter data from specified range.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Shared Function GetFilterData( _
   ByVal worksheet As Worksheet, _
   ByVal columnIndex As Integer, _
   ByVal row As Integer, _
   ByVal row2 As Integer, _
   Optional ByVal maxItems As Integer, _
   Optional ByVal columnDirection As Boolean _
) As FilterData

'Usage
 
Dim worksheet As Worksheet
Dim columnIndex As Integer
Dim row As Integer
Dim row2 As Integer
Dim maxItems As Integer
Dim columnDirection As Boolean
Dim value As FilterData
 
value = AutoFilterColumn.GetFilterData(worksheet, columnIndex, row, row2, maxItems, columnDirection)

public static FilterData GetFilterData( 
   Worksheet worksheet,
   int columnIndex,
   int row,
   int row2,
   int maxItems,
   bool columnDirection
)

Parameters

worksheet: The worksheet contains the AutoFilter object.
columnIndex: The column index to get FilterData.
row: The start row index.
row2: The end row index.
maxItems
columnDirection

Return Value

A FilterData represents the filter data of this filter column.

Reference

AutoFilterColumn Structure
AutoFilterColumn Members
Overload List