SpreadsheetGear The Performance Spreadsheet Component Company 
Find Method
See Also 
SpreadsheetGear Namespace > IRange Interface : Find Method
what
Specifies the text to find.
after
Specifies the cell to start after within this range, or null to start after the top-left cell of this range.
lookIn
Specifies whether to search formulas or values.
lookAt
Specifies partial or complete match.
searchOrder
Specifies whether to search by rows or by columns.
searchDirection
Specifies whether to search forward (next) or backwards (previous).
matchCase
Specifies whether text searches should match case.
Searches for the specified text according to the specified options, and returns an IRange representing the found cell or null if no cell is found.

Syntax

C# 
virtual IRange Find( 
   string what,
   IRange after,
   FindLookIn lookIn,
   LookAt lookAt,
   SearchOrder searchOrder,
   SearchDirection searchDirection,
   bool matchCase
)

Parameters

what
Specifies the text to find.
after
Specifies the cell to start after within this range, or null to start after the top-left cell of this range.
lookIn
Specifies whether to search formulas or values.
lookAt
Specifies partial or complete match.
searchOrder
Specifies whether to search by rows or by columns.
searchDirection
Specifies whether to search forward (next) or backwards (previous).
matchCase
Specifies whether text searches should match case.

Return Value

Returns the next or previous cell which meets the specified criteria, or null if no cell is found.

Requirements

Platforms: Windows Vista, Windows XP, Windows Server 2008, Windows Server 2003, Windows 2000, Windows Me and Windows 98, including 32 bit and 64 bit editions where applicable. SpreadsheetGear for .NET 1.x requires the Microsoft .NET Framework 1.1 or .NET 2.0 (works with .NET 3.x). SpreadsheetGear for .NET 2007 requires the Microsoft .NET Framework 2.0 (works with .NET 3.x).

See Also