Class FindOptions

FindOptions class

Represents find options.

public class FindOptions


FindOptions()The default constructor.


CaseSensitive { get; set; }Indicates if the searched string is case sensitive.
ConvertNumericData { get; set; }Gets or sets a value that indicates whether converting the searched string value to numeric data.
IsCaseSensitive { get; set; }(Obsolete.) Indicates if the searched string is case sensitive.
IsRangeSet { get; }Indicates whether the searched range is set.
LookAtType { get; set; }Look at type.
LookInType { get; set; }Look in type.
RegexKey { get; set; }Indicates whether the searched key is regex. If true the searched key will be taken as regex and parsed. Otherwise the key will be parsed according to the rules in ms excel.
SeachOrderByRows { get; set; }Indicates whether search order by rows or columns.
SearchBackward { get; set; }Whether search backward for cells.
SearchNext { get; set; }(Obsolete.) Search order. True: search next. False: search previous.
Style { get; set; }The format to search for.
ValueTypeSensitive { get; set; }Indicates whether searched cell value type should be same with the searched key.


GetRange()Gets and sets the searched range.
SetRange(CellArea)Sets the searched range.



//Instantiate the workbook object
Workbook workbook = new Workbook("book1.xls");

//Get Cells collection 
Cells cells = workbook.Worksheets[0].Cells;

//Instantiate FindOptions Object
FindOptions findOptions = new FindOptions();

//Create a Cells Area
CellArea ca = new CellArea();
ca.StartRow = 8;
ca.StartColumn = 2;
ca.EndRow = 17;
ca.EndColumn = 13;

//Set cells area for find options

//Set searching properties
findOptions.SearchBackward = false;

findOptions.SeachOrderByRows = true;

findOptions.LookInType = LookInType.Values;

//Find the cell with 0 value
Cell cell = cells.Find(0, null, findOptions);


'Instantiate the workbook object
Dim workbook As New Workbook("book1.xls")

'Get Cells collection 
Dim cells As Cells = workbook.Worksheets(0).Cells

'Instantiate FindOptions Object
Dim findOptions As New FindOptions()

'Create a Cells Area
Dim ca As New CellArea()
ca.StartRow = 8
ca.StartColumn = 2
ca.EndRow = 17
ca.EndColumn = 13

'Set cells area for find options

'Set searching properties
findOptions.SearchBackward = True

findOptions.SeachOrderByRows = True

findOptions.LookInType = LookInType.Values

'Find the cell with 0 value
Dim cell As Cell = cells.Find(0, Nothing, findOptions)

See Also