java 在excel中提取字符串

最新推荐文章于 2023-07-25 10:58:02 发布

july_young

最新推荐文章于 2023-07-25 10:58:02 发布

阅读量952

点赞数

分类专栏： java

本文链接：https://blog.csdn.net/july_young/article/details/82876932

版权

java 专栏收录该内容

73 篇文章 0 订阅

订阅专栏

1、导包
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi</artifactId>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml-schemas</artifactId>
</dependency>

2、获取string型的表格内容
public static String getCellValue(Cell cell) {
    String cellValue = "";
    // 以下是判断数据的类型
    switch (cell.getCellType()) {
        case Cell.CELL_TYPE_NUMERIC:
            // 数字
            if (org.apache.poi.ss.usermodel.DateUtil.isCellDateFormatted(cell)) {
                SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
                cellValue = sdf.format(org.apache.poi.ss.usermodel.DateUtil.getJavaDate(cell.getNumericCellValue())).toString();
            } else {
                DataFormatter dataFormatter = new DataFormatter();
                cellValue = dataFormatter.formatCellValue(cell);
            }
            break;
        case Cell.CELL_TYPE_STRING:
            // 字符串
            cellValue = cell.getStringCellValue();
            break;
        case Cell.CELL_TYPE_BOOLEAN:
            // Boolean
            cellValue = cell.getBooleanCellValue() + "";
            break;
        case Cell.CELL_TYPE_FORMULA:
            // 公式
            cellValue = cell.getCellFormula() + "";
            break;
        case Cell.CELL_TYPE_BLANK:
            // 空值
            cellValue = "";
            break;
        case Cell.CELL_TYPE_ERROR:
            // 故障
            cellValue = "非法字符";
            break;
        default:
            cellValue = "未知类型";
            break;
    }
    return cellValue;
}