easypoi导入校验跳过空行

最新推荐文章于 2024-07-02 10:27:11 发布

西门吹雪@132

最新推荐文章于 2024-07-02 10:27:11 发布

阅读量575

点赞数 2

文章标签： java

本文链接：https://blog.csdn.net/qq_50523945/article/details/135875658

版权

话不多说，直接上代码

ImportParams importParams = new ImportParams();
		importParams.setTitleRows(0);
		importParams.setHeadRows(1);
		importParams.setNeedVerfiy(true);
		importParams.setVerifyHandler(dnImportExcelVerifyHandler);

import cn.afterturn.easypoi.excel.entity.result.ExcelVerifyHandlerResult;
import cn.afterturn.easypoi.handler.inter.IExcelVerifyHandler;
import com.pig4cloud.pigx.fashion.api.excel.asnImport.AsnImport;
import com.pig4cloud.pigx.fashion.api.excel.dnImport.DnImport;
import org.apache.commons.lang3.StringUtils;
import org.springframework.stereotype.Component;

/**
 * 检查是否有空行
 */
@Component
public class DnImportExcelVerifyHandler implements IExcelVerifyHandler<DnImport> {
	@Override
	public ExcelVerifyHandlerResult verifyHandler(DnImport dnImport) {
		if(StringUtils.isBlank(dnImport.getWarehouseCode())
			&& StringUtils.isBlank(dnImport.getCompanyCode())
			&& StringUtils.isBlank(dnImport.getOutboundDispatchNumber())
			&& StringUtils.isBlank(dnImport.getCustomerNumber())
			&& StringUtils.isBlank(dnImport.getOrderType())
			&& StringUtils.isBlank(dnImport.getProductPropertyBin())
			&& StringUtils.isBlank(dnImport.getExpectedArrivalDate())
			&& null==dnImport.getPriority()
			&& StringUtils.isBlank(dnImport.getNeedQc())
			&& StringUtils.isBlank(dnImport.getReceivingAddressCode())
			&& StringUtils.isBlank(dnImport.getReceiverName())
			&& StringUtils.isBlank(dnImport.getTelephone())
			&& StringUtils.isBlank(dnImport.getAddress())
			&& StringUtils.isBlank(dnImport.getRemark())
			&& StringUtils.isBlank(dnImport.getPartNumber())
			&& StringUtils.isBlank(dnImport.getEan())
			&& null == dnImport.getQuantity()
			&& StringUtils.isBlank(dnImport.getSpecifyLocation())
			&& StringUtils.isBlank(dnImport.getSpecifyReceiptBatch())
			&& StringUtils.isBlank(dnImport.getQuantityUnit())
		){
			ExcelVerifyHandlerResult result = new ExcelVerifyHandlerResult(false);
			result.setMsg("空行数据");
			return result;
		}
		return new ExcelVerifyHandlerResult(true);
	}
}