JAVA 读取EXCEL

来源：互联网发布：淘宝如何一元秒杀编辑：程序博客网时间：2024/05/17 05:55

    private static String getCellFormatValue(HSSFCell cell) {
       String cellvalue = "";
       if (cell != null) {
           switch (cell.getCellType()) {
           case HSSFCell.CELL_TYPE_NUMERIC:
               cellvalue = String.valueOf(cell.getNumericCellValue());
           case HSSFCell.CELL_TYPE_FORMULA: {

               if (HSSFDateUtil.isCellDateFormatted(cell)) {
                   Date date = cell.getDateCellValue();
                   cellvalue = cell.getDateCellValue().toLocaleString();
               } else {
                   double num = new Double((double) cell.getNumericCellValue());
                   cellvalue = String.valueOf(num);
               }
               break;
           }

           case HSSFCell.CELL_TYPE_STRING:
               cellvalue = cell.getStringCellValue();
               break;
           default:
               cellvalue = "";
           }
       } else {
           cellvalue = "";
       }
       return cellvalue.trim();
   }