package com.moral.api.utils;

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

public class ExcelUtils {

    public static Object getValue(Cell cell) {
        Object value = null;
        if (cell == null) {
            return null;
        }
        switch (cell.getCellType()){
            case STRING:
                // 字符串类型
                value = cell.getStringCellValue();
                break;
            case NUMERIC:
                if (DateUtil.isCellDateFormatted(cell)){
                value = cell.getDateCellValue();
                }else {
                 // double类型
                 value = cell.getNumericCellValue();
                }
                break;
            case BOOLEAN:
                // boolean类型
                value = cell.getBooleanCellValue();
                break;
            case FORMULA:
                value = cell.getCellFormula();
                break;
            default:
                break;
        }
        return value;
    }
}