如何将excel单元格值转换为字符串类型？在excel中将单元格设置为文本类型不起作用

我正在尝试从 Excel 工作表中读取一个值，并通过比较 webelement 中的值将其输入到文本字段中。

如何从单元格中获取此值作为字符串而不是数字？下面给出了读写excel的代码

public String getValueFromCell(int iRowNumber, int iColNumber)
   {
      XSSFRow row = sheet.getRow(iRowNumber);
      Cell cell = row.getCell(iColNumber);

      return cell == null ? "" : cell.toString();
   }

   /**
    * returns no. of rows of excel sheet
    * 
    * @return
    */
   public int getRowCount()
   {
      return sheet.getLastRowNum();
   }

   /**
    * returns no. of columns of excel sheet
    * 
    * @param sheetName
    * @return
    */
   public int getColumnCount(String sheetName)
   {

      sheet = workbook.getSheet(sheetName);
      row = sheet.getRow(0);
      return row.getLastCellNum();
   }

   /**
    * return row number of a String value
    * 
    * @param value
    * @return
    */
   public int getRowNumber(String value)
   {
      XSSFSheet indexsheet = workbook.getSheet("Index");
      for(int i = 0; i <= indexsheet.getLastRowNum(); i++)
      {
         row = indexsheet.getRow(i);
         if(value.equalsIgnoreCase(row.getCell(0).getStringCellValue()))
         {
            return i + 1;
         }
      }
      return 0;
   }

   /**
    * sets data in a cell
    * 
    * @param path
    * @param sheetName
    * @param colName
    * @param rowNum
    * @param data
    * @return
    */
   public boolean setCellData(String path, String sheetName, String colName, int rowNum, String data)
   {
      try
      {
         if(rowNum <= 0)
            return false;

         int index = workbook.getSheetIndex(sheetName);
         int colNum = -1;
         if(index == -1)
            return false;


         sheet = workbook.getSheetAt(index);


         row = sheet.getRow(0);
         for(int i = 0; i < row.getLastCellNum(); i++)
         {
            if(row.getCell(i).getStringCellValue().trim().equals(colName))
               colNum = i;
         }
         if(colNum == -1)
            return false;

         sheet.autoSizeColumn(colNum);
         row = sheet.getRow(rowNum - 1);
         if(row == null)
            row = sheet.createRow(rowNum - 1);

         cell = row.getCell(colNum);
         if(cell == null)
            cell = row.createCell(colNum);

         cell.setCellValue(data);

      }
      catch(Exception e)
      {
         e.printStackTrace();
         return false;
      }
      return true;
   }

}