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;
|
}
|
}
|
