poi获取单元个中的值返回字符串(数值类型可输出整数或者小数)

/**
     * 获取单元格各类型值,返回字符串类型
     *
     * @param cell
     * @return
     */
    private String getCellValue(Cell cell) {
        String cellValue = null;
        CellType cellType = cell.getCellType();
        switch (cellType) {
            case STRING:
                cellValue = cell.getStringCellValue();
                break;
            case NUMERIC:
                cellValue = cell.getNumericCellValue() + "";
                if (HSSFDateUtil.isCellDateFormatted(cell)) {
                    Date date = cell.getDateCellValue();
                    if (date != null) {
                        cellValue = new SimpleDateFormat("yyyy/MM/dd").format(date);
                    } else {
                        cellValue = "";
                    }
                }
                else {
                    HSSFDataFormatter hssfDataFormatter = new HSSFDataFormatter();
                    cellValue = hssfDataFormatter.formatCellValue(cell);
                }
                break;
            case FORMULA:
                cellValue = cell.getCellFormula() + "";
                break;
            case BLANK:
                cellValue = "";
                break;
            case ERROR:
                cellValue = "非法字符";
        }
        return cellValue;
    }
posted @ 2020-03-30 17:17  Runtimeing  阅读(819)  评论(0编辑  收藏  举报