POI读取Excel内容格式化

import org.apache.poi.hssf.usermodel.HSSFDataFormatter;
import org.apache.poi.hssf.usermodel.HSSFDateUtil;

public Object getValue(Cell cell) {
    if (cell == null)
        return "";
    //如果是日期类型(POI会把日期转数字)
    if (cell.getCellType() == cell.CELL_TYPE_NUMERIC) {
        //Check if a cell contains a date
        if (HSSFDateUtil.isCellDateFormatted(cell)) {
            Date d = HSSFDateUtil.getJavaDate(cell.getNumericCellValue());
            return new SimpleDateFormat("yyyy-MM-dd").format(d);
        }
    }
    HSSFDataFormatter df = new HSSFDataFormatter();
    return df.formatCellValue(cell);
}