Find Value in Cells

Aspose.Cells

//Instantiating a Workbook object
Workbook workbook = new Workbook("workbook.xls");

//Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.getWorksheets().get(0);

//Finding the cell containing the specified formula
Cells cells = worksheet.getCells();

//Instantiate FindOptions
FindOptions findOptions = new FindOptions();

//Finding the cell containing a string value that starts with "Or"
findOptions.setLookAtType(LookAtType.START_WITH);

Cell cell = cells.find("SH",null,findOptions);

//Printing the name of the cell found after searching worksheet
System.out.println("Name of the cell containing String: " + cell.getName());

Download Source Code