FindOptions
FindOptions class
Represents find options.
new FindOptions()
Methods
| Name | Description |
|---|---|
| getCaseSensitive() | Indicates if the searched string is case sensitive. |
| getConvertNumericData() | Gets or sets a value that indicates whether converting the searched string value to numeric data. |
| getLookAtType() | Look at type. The value of the property is LookAtType integer constant. |
| getLookInType() | Look in type. The value of the property is LookInType integer constant. |
| getRange() | Gets and sets the searched range. |
| getRegexKey() | Indicates whether the searched key is regex. If true the searched key will be taken as regex and parsed. Otherwise the k |
| getSeachOrderByRows() | Indicates whether search order by rows or columns. |
| getSearchBackward() | Whether search backward for cells. |
| getSearchNext() | Search order. True: search next. False: search previous. NOTE: This member is now obsolete. Instead, please use FindOpti |
| getSearchOrderByRows() | |
| getStyle() | The format to search for. |
| getValueTypeSensitive() | Indicates whether searched cell value type should be same with the searched key. |
| isRangeSet() | Indicates whether the searched range is set. |
| setCaseSensitive() | Indicates if the searched string is case sensitive. |
| setConvertNumericData() | Gets or sets a value that indicates whether converting the searched string value to numeric data. |
| setLookAtType() | Look at type. The value of the property is LookAtType integer constant. |
| setLookInType() | Look in type. The value of the property is LookInType integer constant. |
| setRange(ca) | Sets the searched range. |
| setRegexKey() | Indicates whether the searched key is regex. If true the searched key will be taken as regex and parsed. Otherwise the k |
| setSeachOrderByRows() | Indicates whether search order by rows or columns. |
| setSearchBackward() | Whether search backward for cells. |
| setSearchNext() | Search order. True: search next. False: search previous. NOTE: This member is now obsolete. Instead, please use FindOpti |
| setSearchOrderByRows() | |
| setStyle() | The format to search for. |
| setValueTypeSensitive() | Indicates whether searched cell value type should be same with the searched key. |
getCaseSensitive()
Indicates if the searched string is case sensitive.
getConvertNumericData()
Gets or sets a value that indicates whether converting the searched string value to numeric data.
getLookAtType()
Look at type. The value of the property is LookAtType integer constant.
getLookInType()
Look in type. The value of the property is LookInType integer constant.
getRange()
Gets and sets the searched range.
Returns: CellArea — CellArea Returns the searched range.
getRegexKey()
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.
getSeachOrderByRows()
Indicates whether search order by rows or columns.
getSearchBackward()
Whether search backward for cells.
getSearchNext()
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.
getSearchOrderByRows()
getStyle()
The format to search for.
getValueTypeSensitive()
Indicates whether searched cell value type should be same with the searched key.
isRangeSet()
Indicates whether the searched range is set.
setCaseSensitive()
Indicates if the searched string is case sensitive.
setConvertNumericData()
Gets or sets a value that indicates whether converting the searched string value to numeric data.
setLookAtType()
Look at type. The value of the property is LookAtType integer constant.
setLookInType()
Look in type. The value of the property is LookInType integer constant.
setRange(ca)
Sets the searched range.
| Parameter | Type | Description |
|---|---|---|
| ca | CellArea | the searched range. |
setRegexKey()
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.
setSeachOrderByRows()
Indicates whether search order by rows or columns.
setSearchBackward()
Whether search backward for cells.
setSearchNext()
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.
setSearchOrderByRows()
setStyle()
The format to search for.
setValueTypeSensitive()
Indicates whether searched cell value type should be same with the searched key.