FindOptions
FindOptions class
Represents find options.
Constructors
| Name | Description |
|---|---|
| FindOptions |
Properties
| Name | Type | Description |
|---|---|---|
| CaseSensitive | boolean | Indicates if the searched string is case sensitive. |
| LookAtType | int | Look at type. The value of the property is LookAtType integer constant. |
| IsRangeSet | boolean | Indicates whether the searched range is set. |
| SearchNext | boolean | Search order. True: search next. False: search previous. NOTE: This member is now obsolete. Instead, please use FindOpti |
| SearchBackward | boolean | Whether search backward for cells. |
| SeachOrderByRows | boolean | Indicates whether search order by rows or columns. |
| SearchOrderByRows | boolean | |
| LookInType | int | Look in type. The value of the property is LookInType integer constant. |
| RegexKey | boolean | Indicates whether the searched key is regex. If true the searched key will be taken as regex and parsed. Otherwise the k |
| ValueTypeSensitive | boolean | Indicates whether searched cell value type should be same with the searched key. |
| Style | Style | The format to search for. |
| ConvertNumericData | boolean | Gets or sets a value that indicates whether converting the searched string value to numeric data. |
Methods
| Name | Description |
|---|---|
| getRange | Gets and sets the searched range. |
| setRange | Sets the searched range. |
FindOptions()
FindOptions.CaseSensitive property
Indicates if the searched string is case sensitive.
Type: boolean
FindOptions.LookAtType property
Look at type. The value of the property is LookAtType integer constant.
Type: int
FindOptions.IsRangeSet property
Indicates whether the searched range is set.
Type: boolean
FindOptions.SearchNext property
Search order. True: search next. False: search previous. NOTE: This member is now obsolete. Instead, please use FindOptions.SearchBackward property. This property will be removed 12 months later since November 2018. Aspose apologizes for any inconvenience you may have experienced.
Type: boolean
FindOptions.SearchBackward property
Whether search backward for cells.
Type: boolean
FindOptions.SeachOrderByRows property
Indicates whether search order by rows or columns.
Type: boolean
FindOptions.SearchOrderByRows property
Type: boolean
FindOptions.LookInType property
Look in type. The value of the property is LookInType integer constant.
Type: int
FindOptions.RegexKey property
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.
Type: boolean
FindOptions.ValueTypeSensitive property
Indicates whether searched cell value type should be same with the searched key.
Type: boolean
FindOptions.Style property
The format to search for.
Type: Style
FindOptions.ConvertNumericData property
Gets or sets a value that indicates whether converting the searched string value to numeric data.
Type: boolean
getRange()
Gets and sets the searched range.
Returns: Returns the searched range.
setRange(ca)
Sets the searched range.
| Parameter | Type | Description |
|---|---|---|
| ca | CellArea | the searched range. |