# Search Data

## Content

You can search for a string in the widget and specify options such as the case, exact match, wild cards, cell range to search, and the order to search in. You can search cell text, cell tags, or formulas.

You can use the [search](/spreadjs/api/v16/classes/GC.Spread.Sheets.Worksheet#search) method and the [SearchCondition](/spreadjs/api/v16/classes/GC.Spread.Sheets.Search.SearchCondition) class to find items in code.

## Using Code
This example searches for a specific text string.
```js
activeSheet.getCell(2,3).value("testSearch");
var searchCondition = new GC.Spread.Sheets.Search.SearchCondition();
searchCondition.searchString = "testSearch";
searchCondition.startSheetIndex = spread.getActiveSheetIndex();
searchCondition.endSheetIndex = spread.getActiveSheetIndex();
searchCondition.searchOrder = GC.Spread.Sheets.Search.SearchOrder.NOrder;
searchCondition.searchTarget = GC.Spread.Sheets.Search.SearchFoundFlags.CellText;
searchCondition.searchFlags = GC.Spread.Sheets.Search.SearchFlags.Ignorecase| GC.Spread.Sheets.Search.SearchFlags.UseWildCards;
var searchresult= spread.search(searchCondition);
var str ="[searchFoundFlag:"+ searchresult.searchFoundFlag+",\r\n foundSheetIndex:"+searchresult.foundSheetIndex+",foundRowIndex:" +
searchresult.foundRowIndex+", foundColumnIndex:"+searchresult.foundColumnIndex+", foundString:"+searchresult.foundSheetIndex+"]";
alert(str);
```