POI取得Cell的字符串(String)值

最新推荐文章于 2023-11-25 14:59:04 发布

iteye_364

最新推荐文章于 2023-11-25 14:59:04 发布

阅读量608

点赞数

分类专栏： Java 文章标签： POI 读Cell

本文链接：https://blog.csdn.net/iteye_364/article/details/82413418

版权

Java 专栏收录该内容

19 篇文章 0 订阅

订阅专栏


public final static String DATE_OUTPUT_PATTERNS = "yyyy-MM-dd'T'HH:mm:ss.SSSZ";
public final static SimpleDateFormat simpleDateFormat = new SimpleDateFormat(
		DATE_OUTPUT_PATTERNS);

public static String getCellValue(Cell cell) {
	String ret = "";
	if (cell == null) return ret;
	CellType type = cell.getCellTypeEnum();
	switch (type) {
	case BLANK:
		ret = "";
		break;
	case BOOLEAN:
		ret = String.valueOf(cell.getBooleanCellValue());
		break;
	case ERROR:
		ret = null;
		break;
	case FORMULA:
		Workbook wb = cell.getSheet().getWorkbook();
		CreationHelper crateHelper = wb.getCreationHelper();
		FormulaEvaluator evaluator = crateHelper.createFormulaEvaluator();
		ret = getCellValue(evaluator.evaluateInCell(cell));
		break;
	case NUMERIC:
		if (DateUtil.isCellDateFormatted(cell)) {
			Date theDate = cell.getDateCellValue();
			ret = simpleDateFormat.format(theDate);
		} else {
			ret = NumberToTextConverter.toText(cell.getNumericCellValue());
		}
		break;
	case STRING:
		ret = cell.getRichStringCellValue().getString();
		break;
	default:
		ret = "";
	}

	return ret; // 有必要自行trim
}