读取excel文件工具类

最新推荐文章于 2023-10-25 19:00:00 发布

原创最新推荐文章于 2023-10-25 19:00:00 发布 · 474 阅读

0 ·

CC 4.0 BY-SA版权

Spring 专栏收录该内容

22 篇文章

订阅专栏

import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;

import java.util.Date;

public class ExcelUtil {
    public static String getStringValue(Row row, int index) {
        Cell cell = row.getCell(index);
        if (cell == null) {
            return "";
        }
        if (cell.getCellType() != Cell.CELL_TYPE_STRING) {
            return "";
        }
        return cell.getStringCellValue();
    }

    public static Date getDateValue(Row row, int index) {
        Cell cell = row.getCell(index);
        if (cell == null) {
            return null;
        }
        return cell.getDateCellValue();
    }

    public static Integer getIntegerValue(Row row, int index) {
        Cell cell = row.getCell(index);
        if (cell == null) {
            return null;
        }
        if (cell.getCellType() != Cell.CELL_TYPE_NUMERIC) {
            return null;
        }
        return (int) cell.getNumericCellValue();
    }

    public static Long getLongValue(Row row, int index) {
        Cell cell = row.getCell(index);
        if (cell == null) {
            return null;
        }
        if (cell.getCellType() != Cell.CELL_TYPE_NUMERIC) {
            return null;
        }
        return (long) cell.getNumericCellValue();
    }

    public static Float getFloatValue(Row row, int index) {
        Cell cell = row.getCell(index);
        if (cell == null) {
            return null;
        }
        if (cell.getCellType() != Cell.CELL_TYPE_NUMERIC) {
            return null;
        }
        return (float)cell.getNumericCellValue();
    }

    public static Double getDoubleValue(Row row, int index) {
        Cell cell = row.getCell(index);
        if (cell == null) {
            return null;
        }
        if (cell.getCellType() != Cell.CELL_TYPE_NUMERIC) {
            return null;
        }
        return cell.getNumericCellValue();
    }
}