Example:
# Instantiate the workbook object workbook = Workbook("Book2.xlsx") # Get Cells collection cells = workbook.getWorksheets().get(0).getCells() # Instantiate FindOptions Object findOptions = FindOptions() # Create a Cells Area ca = 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.setSearchNext(True) findOptions.setSeachOrderByRows(True) findOptions.setLookInType(LookInType.VALUES) # Find the cell with 0 value cell = cells.find(0, None, findOptions)
Constructor Summary |
---|
FindOptions()
|
Property Getters/Setters Summary | ||
---|---|---|
method | getCaseSensitive() | |
method | setCaseSensitive(value) | |
Indicates if the searched string is case sensitive. | ||
method | getConvertNumericData() | |
method | setConvertNumericData(value) | |
Gets or sets a value that indicates whether converting the searched string value to numeric data. | ||
void | setCaseSensitive(value) | |
Indicates if the searched string is case sensitive. | ||
method | isRangeSet() | |
Indicates whether the searched range is set. | ||
method | getLookAtType() | |
method | setLookAtType(value) | |
Look at type. The value of the property is LookAtType integer constant. | ||
method | getLookInType() | |
method | setLookInType(value) | |
Look in type. The value of the property is LookInType integer constant. | ||
method | getRegexKey() | |
method | setRegexKey(value) | |
Indicates whether the searched key is regex. If true then the searched key will be taken as regex. | ||
method | getSeachOrderByRows() | |
method | setSeachOrderByRows(value) | |
Indicates whether search order by rows or columns. | ||
method | getSearchBackward() | |
method | setSearchBackward(value) | |
Whether search backward for cells. | ||
method | getSearchNext() | |
method | setSearchNext(value) | |
Search order. True: search next. False: search previous. | ||
method | getStyle() | |
method | setStyle(value) | |
The format to search for. | ||
method | getValueTypeSensitive() | |
method | setValueTypeSensitive(value) | |
Indicates whether searched cell value type should be same with the searched key. |
Method Summary | ||
---|---|---|
method | getRange() | |
Gets and sets the searched range. | ||
method | setRange(ca) | |
Sets the searched range. |
Constructor Detail |
---|
FindOptions()
Property Getters/Setters Detail |
---|
setCaseSensitive : boolean | |
setCaseSensitive(value) |
getCaseSensitive/setCaseSensitive : boolean | |
boolean getCaseSensitive() / setCaseSensitive(value) |
getLookAtType/setLookAtType : int | |
int getLookAtType() / setLookAtType(value) |
isRangeSet : boolean | |
boolean isRangeSet() |
getSearchNext/setSearchNext : boolean | |
boolean getSearchNext() / setSearchNext(value) |
getSearchBackward/setSearchBackward : boolean | |
boolean getSearchBackward() / setSearchBackward(value) |
getSeachOrderByRows/setSeachOrderByRows : boolean | |
boolean getSeachOrderByRows() / setSeachOrderByRows(value) |
getLookInType/setLookInType : int | |
int getLookInType() / setLookInType(value) |
getRegexKey/setRegexKey : boolean | |
boolean getRegexKey() / setRegexKey(value) |
getValueTypeSensitive/setValueTypeSensitive : boolean | |
boolean getValueTypeSensitive() / setValueTypeSensitive(value) |
getStyle/setStyle : Style | |
Style getStyle() / setStyle(value) |
getConvertNumericData/setConvertNumericData : boolean | |
boolean getConvertNumericData() / setConvertNumericData(value) |
Method Detail |
---|
getRange | |
CellArea getRange() |
setRange | |
setRange(ca) |
ca: CellArea
- the searched range.