Examples with ExcelDataConvertException com.alibaba.excel.exception.ExcelDataConvertException used on opensource projects

Example 11 with ExcelDataConvertException

use of com.alibaba.excel.exception.ExcelDataConvertException in project RuoYi-Flowable-Plus by KonBAI-Q.

the class DefaultExcelListener method onException.

/**
 * 处理异常
 *
 * @param exception ExcelDataConvertException
 * @param context   Excel 上下文
 */
@Override
public void onException(Exception exception, AnalysisContext context) throws Exception {
    String errMsg = null;
    if (exception instanceof ExcelDataConvertException) {
        // 如果是某一个单元格的转换异常 能获取到具体行号
        ExcelDataConvertException excelDataConvertException = (ExcelDataConvertException) exception;
        Integer rowIndex = excelDataConvertException.getRowIndex();
        Integer columnIndex = excelDataConvertException.getColumnIndex();
        errMsg = StrUtil.format("第{}行-第{}列-表头{}: 解析异常<br/>", rowIndex + 1, columnIndex + 1, headMap.get(columnIndex));
        if (log.isDebugEnabled()) {
            log.error(errMsg);
        }
    }
    if (exception instanceof ConstraintViolationException) {
        ConstraintViolationException constraintViolationException = (ConstraintViolationException) exception;
        Set<ConstraintViolation<?>> constraintViolations = constraintViolationException.getConstraintViolations();
        String constraintViolationsMsg = constraintViolations.stream().map(ConstraintViolation::getMessage).collect(Collectors.joining(", "));
        errMsg = StrUtil.format("第{}行数据校验异常: {}", context.readRowHolder().getRowIndex() + 1, constraintViolationsMsg);
        if (log.isDebugEnabled()) {
            log.error(errMsg);
        }
    }
    excelResult.getErrorList().add(errMsg);
    throw new ExcelAnalysisException(errMsg);
}

Example 12 with ExcelDataConvertException

use of com.alibaba.excel.exception.ExcelDataConvertException in project RuoYi-Cloud-Plus by JavaLionLi.

the class DefaultExcelListener method onException.

/**
 * 处理异常
 *
 * @param exception ExcelDataConvertException
 * @param context   Excel 上下文
 */
@Override
public void onException(Exception exception, AnalysisContext context) throws Exception {
    String errMsg = null;
    if (exception instanceof ExcelDataConvertException) {
        // 如果是某一个单元格的转换异常 能获取到具体行号
        ExcelDataConvertException excelDataConvertException = (ExcelDataConvertException) exception;
        Integer rowIndex = excelDataConvertException.getRowIndex();
        Integer columnIndex = excelDataConvertException.getColumnIndex();
        errMsg = StrUtil.format("第{}行-第{}列-表头{}: 解析异常<br/>", rowIndex + 1, columnIndex + 1, headMap.get(columnIndex));
        if (log.isDebugEnabled()) {
            log.error(errMsg);
        }
    }
    if (exception instanceof ConstraintViolationException) {
        ConstraintViolationException constraintViolationException = (ConstraintViolationException) exception;
        Set<ConstraintViolation<?>> constraintViolations = constraintViolationException.getConstraintViolations();
        String constraintViolationsMsg = constraintViolations.stream().map(ConstraintViolation::getMessage).collect(Collectors.joining(", "));
        errMsg = StrUtil.format("第{}行数据校验异常: {}", context.readRowHolder().getRowIndex() + 1, constraintViolationsMsg);
        if (log.isDebugEnabled()) {
            log.error(errMsg);
        }
    }
    excelResult.getErrorList().add(errMsg);
    throw new ExcelAnalysisException(errMsg);
}