aspose.cells
Class FindOptions

//Instantiate the workbook object
$workbook = new cells\Workbook("Book1.xls");
//Get Cells collection 
$cells = $workbook->getWorksheets()->get(0)->getCells();
//Instantiate FindOptions Object
$findOptions = new cells\FindOptions();
//Create a Cells Area
$ca = new cells\CellArea();
$ca->StartRow = 0;
$ca->StartColumn = 0;
$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(cells\LookInType::VALUES);
//Find the cell with 0 value
$cell =$cells->find("a", null, $findOptions);
echo "Found cell: ".$cell."\n";

FindOptions

function FindOptions()

function setCaseSensitive(value)

Indicates if the searched string is case sensitive.

NOTE: This member is now obsolete. Instead, please use FindOptions.CaseSensitive property. This property will be removed 12 months later since June 2010. Aspose apologizes for any inconvenience you may have experienced.

function getCaseSensitive() / function setCaseSensitive(value)

Indicates if the searched string is case sensitive.

function getLookAtType() / function setLookAtType(value)

Look at type. The value of the property is LookAtType integer constant.

function isRangeSet()

Indicates whether the searched range is set.

function getSearchNext() / function setSearchNext(value)

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.

function getSearchBackward() / function setSearchBackward(value)

Whether search backward for cells.

function getSeachOrderByRows() / function setSeachOrderByRows(value)

Indicates whether search order by rows or columns.

function getLookInType() / function setLookInType(value)

Look in type. The value of the property is LookInType integer constant.

function getRegexKey() / function setRegexKey(value)

Indicates whether the searched key is regex. If true then the searched key will be taken as regex.

function getValueTypeSensitive() / function setValueTypeSensitive(value)

Indicates whether searched cell value type should be same with the searched key.

function getStyle() / function setStyle(value)

The format to search for.

function getConvertNumericData() / function setConvertNumericData(value)

Gets or sets a value that indicates whether converting the searched string value to numeric data.

function getRange()

Gets and sets the searched range.

Returns:

Returns the seached range.

function setRange(ca)

Sets the searched range.

Parameters:

ca: CellArea - the searched range.