Class FindOptions
Namespace: Aspose.Cells
Assembly: Aspose.Cells.dll (25.2.0)
Represents find options.
public class FindOptionsInheritance
Inherited Members
object.GetType(), object.MemberwiseClone(), object.ToString(), object.Equals(object?), object.Equals(object?, object?), object.ReferenceEquals(object?, object?), object.GetHashCode()
Examples
csharp
[C#]
//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
findOptions.SetRange(ca);
//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
findOptions.SetRange(ca)
'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)Constructors
FindOptions()
public FindOptions()Properties
CaseSensitive
Indicates if the searched string is case sensitive.
public bool CaseSensitive { get; set; }Property Value
ConvertNumericData
Gets or sets a value that indicates whether converting the searched string value to numeric data.
public bool ConvertNumericData { get; set; }Property Value
IsRangeSet
Indicates whether the searched range is set.
public bool IsRangeSet { get; }Property Value
LookAtType
Look at type.
public LookAtType LookAtType { get; set; }Property Value
LookInType
Look in type.
public LookInType LookInType { get; set; }Property Value
RegexKey
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.
public bool RegexKey { get; set; }Property Value
SearchBackward
Whether search backward for cells.
public bool SearchBackward { get; set; }Property Value
SearchOrderByRows
Indicates whether search order by rows or columns.
public bool SearchOrderByRows { get; set; }Property Value
Style
The format to search for.
public Style Style { get; set; }Property Value
ValueTypeSensitive
Indicates whether searched cell value type should be same with the searched key.
public bool ValueTypeSensitive { get; set; }Property Value
Methods
GetRange()
Gets and sets the searched range.
public CellArea GetRange()Returns
Returns the searched range.
SetRange(CellArea)
Sets the searched range.
public void SetRange(CellArea ca)Parameters
ca CellArea
the searched range.