title: Search algorithm for excel document in Java
body: <p>I'm writing a program to read an xslx file using Apache POI in java, and create a search algorithm to search for s string in the records. I've written the code to print all the records but I can't seem to find how to create the search algorithm. It's meant to show records with "zgheib" only. I would really appreciate a hand. This is my code:</p>
  
  <pre><code>import java.io.File;
  import java.io.FileInputStream;
  import java.io.FileOutputStream;
  import java.io.IOException;
  import java.util.Iterator;
  import org.apache.poi.ss.usermodel.Cell;
  import org.apache.poi.ss.usermodel.Row;
  import org.apache.poi.xssf.usermodel.XSSFCell;
  import org.apache.poi.xssf.usermodel.XSSFRow;
  import org.apache.poi.xssf.usermodel.XSSFSheet;
  import org.apache.poi.xssf.usermodel.XSSFWorkbook;
  
  public class test {
      public static void main(String[] args) throws IOException {
          try
          {
              FileInputStream file = new FileInputStream(new File("C:\\Users\\Junaid\\Documents\\IntelliJ Projects\\ReadExcel_Bashar\\src\\assignment.xlsx"));
  
          //Create Workbook instance holding reference to .xlsx file
          XSSFWorkbook workbook = new XSSFWorkbook(file);
  
          //Get first/desired sheet from the workbook
          XSSFSheet sheet = workbook.getSheetAt(0);
  
          //Iterate through each rows one by one
          Iterator&lt;Row&gt; rowIterator = sheet.iterator();
          while (rowIterator.hasNext())
          {
              Row row = rowIterator.next();
              //For each row, iterate through all the columns
              Iterator&lt;Cell&gt; cellIterator = row.cellIterator();
  
              while (cellIterator.hasNext())
              {
                  Cell cell = cellIterator.next();
                  //Check the cell type and format accordingly
                  switch (cell.getCellType())
                  {
                      case Cell.CELL_TYPE_NUMERIC:
                          System.out.print(cell.getNumericCellValue() + "\t");
                          break;
                      case Cell.CELL_TYPE_STRING:
                          System.out.print(cell.getStringCellValue() + "\t");
                          break;
                  }
              }
              System.out.println("");
          }
          file.close();
      }
      catch (Exception e)
      {
          e.printStackTrace();
      }
  }
  
  }
  </code></pre>