• Home
• com.github.stupdit1t
• poi-excel
• 3.2.2
• source code
• BigDecimalHandler.java

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

com.github.stupdit1t.excel.handle.BigDecimalHandler Maven / Gradle / Ivy

package com.github.stupdit1t.excel.handle;

import com.github.stupdit1t.excel.common.PoiConstant;
import com.github.stupdit1t.excel.common.PoiException;
import com.github.stupdit1t.excel.core.parse.OpsColumn;
import com.github.stupdit1t.excel.handle.rule.BaseVerifyRule;
import org.apache.commons.lang3.math.NumberUtils;

import java.math.BigDecimal;


/**
 * BigDecimal校验实体
 *
 * @author 625
 */
public class BigDecimalHandler extends BaseVerifyRule {

	/**
	 * 常规验证
	 *
	 * @param allowNull 可为空
	 */
	public BigDecimalHandler(boolean allowNull, OpsColumn opsColumn) {
		super(allowNull, opsColumn);
	}

	@Override
	protected BigDecimal doHandle(int row, int col, Object cellValue) throws Exception {
		if (cellValue instanceof BigDecimal) {
			return (BigDecimal) cellValue;
		} else {
			String value = String.valueOf(cellValue);
			if (this.trim) {
				value = value.trim();
			}
			if (NumberUtils.isCreatable(value)) {
				return new BigDecimal(value);
			}
		}
		throw PoiException.error(PoiConstant.INCORRECT_FORMAT_STR);
	}
}