java poi Excel导入整数浮点数转换问题解决

最新推荐文章于 2023-06-07 15:27:06 发布

weixin_30420305

最新推荐文章于 2023-06-07 15:27:06 发布

阅读量666

点赞数

文章标签： java

原文链接：http://www.cnblogs.com/ckaifeng/p/4988970.html

版权

    /**
   * 获取单元格数据
   */
   protected static String getCellValue(Cell cell) {
       String cellValue = "";
       if (cell != null) {
           switch (cell.getCellType()) {
           case Cell.CELL_TYPE_STRING:
               cellValue = cell.getStringCellValue();
               break;
           case Cell.CELL_TYPE_NUMERIC:
               String dataFormat = cell.getCellStyle().getDataFormatString();
               if (DateUtil.isCellDateFormatted(cell)) {
                   cellValue = sdf.format(cell.getDateCellValue());
               } else if ("@".equals(dataFormat)) {
                   cellValue = df.format(cell.getNumericCellValue());
               } else {
                   cellValue = String.valueOf(cell.getNumericCellValue());
                   DecimalFormat df = new DecimalFormat("#.#########");
                   cellValue=df.format(Double.valueOf(cellValue));
               }
               break;
           case Cell.CELL_TYPE_BOOLEAN:
               cellValue = String.valueOf(cell.getBooleanCellValue());
               break;
           case Cell.CELL_TYPE_FORMULA:
               cellValue = cell.getCellFormula();
               break;
           default:
               cellValue = "";
           }
       }
       return cellValue;
   }