FindOptions class
FindOptions class
Represents find options.
The FindOptions type exposes the following members:
Constructors
| Constructor | Description |
|---|---|
| init | Constructs a new instance of FindOptions |
Properties
| Property | Description |
|---|---|
| is_case_sensitive | Indicates if the searched string is case sensitive. |
| case_sensitive | Indicates if the searched string is case sensitive. |
| look_at_type | Look at type. |
| is_range_set | Indicates whether the searched range is set. |
| search_next | Search order. True: search next. False: search previous. |
| search_backward | Whether search backward for cells. |
| seach_order_by_rows | Indicates whether search order by rows or columns. |
| look_in_type | Look in type. |
| regex_key | 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. |
| value_type_sensitive | Indicates whether searched cell value type should be same with the searched key. |
| style | The format to search for. |
| convert_numeric_data | Gets or sets a value that indicates whether converting the searched string value to numeric data. |
Methods
| Method | Description |
|---|---|
| get_range | Gets and sets the searched range. |
| set_range | Sets the searched range. |
Example
from aspose.cells import CellArea, FindOptions, LookInType, Workbook
# Instantiate the workbook object
workbook = Workbook("book1.xls")
# Get Cells collection
cells = workbook.worksheets[0].cells
# Instantiate FindOptions Object
findOptions = FindOptions()
# Create a Cells Area
ca = CellArea()
ca.start_row = 8
ca.start_column = 2
ca.end_row = 17
ca.end_column = 13
# Set cells area for find options
findOptions.set_range(ca)
# Set searching properties
findOptions.search_backward = False
findOptions.seach_order_by_rows = True
findOptions.look_in_type = LookInType.VALUES
# Find the cell with 0 value
cell = cells.find(0, None, findOptions)
See Also
- module
aspose.cells
