读取EXCEL值

最新推荐文章于 2022-08-12 15:24:57 发布

原创最新推荐文章于 2022-08-12 15:24:57 发布 · 235 阅读

0 ·

CC 4.0 BY-SA版权

JAVA 专栏收录该内容

19 篇文章

订阅专栏

/**
 * 读取EXCEL值
 *
 * @author wlx
 * @date 2019-09-16 22:37:18
 * <p>
 * Author wlx
 */
public class ExcelUtil {
   public static  Object getCellValue(Cell cell) {
      Object value = null;

      //格式化number String字符串
      DecimalFormat df = new DecimalFormat("0");
      //日期格式化
      SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");

      switch (cell.getCellTypeEnum()) {
         case STRING:
            value = cell.getRichStringCellValue().getString();
            break;
         case NUMERIC:
            if("General".equals(cell.getCellStyle().getDataFormatString())){
               if(StringUtils.isNotEmpty(cell.toString())){
                  if(cell.toString().indexOf(".")==-1){
                     value = cell.toString();
                  }else{
                     String[] list = cell.toString().split("/.");
                     try{
                        if(list[1].length()>1){
                           value = cell.toString();
                        }else{
                           value = df.format(cell.getNumericCellValue());
                        }
                     }catch (Exception ex){
                        value = df.format(cell.getNumericCellValue());
                     }
                  }
               }else{
                  value = "";
               }
            }else if("m/d/yy".equals(cell.getCellStyle().getDataFormatString())){
               value = sdf.format(cell.getDateCellValue());
            }else{
               value = df.format(cell.getNumericCellValue());
            }
            break;
         case BOOLEAN:
            value = cell.getBooleanCellValue();
            break;
         case BLANK:
            value = "";
            break;
         default:
            value = cell.toString();
            break;
      }
      return value;
   }
}