title: Java POI: How to find an Excel cell with a string value and get its position (row) to use that position to find another cell
body: <p>I'm looking for a cell in a spreadsheet that has the string 'Total' and then use the row in which that cell is to find the total value in another cell which is always the same cell/column (the 10th cell in a 0 based index).</p>
  
  <p>I have the following code, which has no errors (syntax), but the findCell method is not returning rowNum value:</p>
  
  <pre><code>    public static void main(String[] args) throws IOException{
  
          String fileName = "C:\\file-path\\report.xls";
          String cellContent = "Total";
          int rownr=0, colnr = 10;
  
          InputStream input = new FileInputStream(fileName);
  
          HSSFWorkbook wb = new HSSFWorkbook(input);
          HSSFSheet sheet = wb.getSheetAt(0);
  
          rownr = findRow(sheet, cellContent);
  
          output(sheet, rownr, colnr);
  
          finish();
      }
  
      private static void output(HSSFSheet sheet, int rownr, int colnr) {
          /*
           * This method displays the total value of the month
           */
  
          HSSFRow row = sheet.getRow(rownr);
          HSSFCell cell = row.getCell(colnr);
  
                  System.out.println("Your total is: " + cell);           
      }
  
      private static int findRow(HSSFSheet sheet, String cellContent){
          /*
           *  This is the method to find the row number
           */
  
          int rowNum = 0; 
  
          for(Row row : sheet) {
              for(Cell cell : row) {
  
                  while(cell.getCellType() == Cell.CELL_TYPE_STRING){
  
                      if(cell.getRichStringCellValue().getString () == cellContent);{
  
                              rowNum = row.getRowNum();
                              return rowNum;  
                      }
                  }
              }
          }               
          return rowNum;
      }
  
      private static void finish() {
  
          System.exit(0);
      }
  }   
  </code></pre>