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

Example 6 with ExcelAnalysisException

use of com.alibaba.excel.exception.ExcelAnalysisException in project easyexcel by alibaba.

the class ExcelReaderSheetBuilder method doReadSync.

/**
 * Synchronous reads return results
 *
 * @return
 */
public <T> List<T> doReadSync() {
    if (excelReader == null) {
        throw new ExcelAnalysisException("Must use 'EasyExcelFactory.read().sheet()' to call this method");
    }
    SyncReadListener syncReadListener = new SyncReadListener();
    registerReadListener(syncReadListener);
    excelReader.read(build());
    excelReader.finish();
    return (List<T>) syncReadListener.getList();
}

Example 7 with ExcelAnalysisException

use of com.alibaba.excel.exception.ExcelAnalysisException in project RuoYi-Vue-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);
}

Example 8 with ExcelAnalysisException

use of com.alibaba.excel.exception.ExcelAnalysisException 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 9 with ExcelAnalysisException

use of com.alibaba.excel.exception.ExcelAnalysisException 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);
}

Example 10 with ExcelAnalysisException

use of com.alibaba.excel.exception.ExcelAnalysisException in project easyexcel by alibaba.

the class ExcelAnalyserImpl method finish.

@Override
public void finish() {
    if (finished) {
        return;
    }
    finished = true;
    if (analysisContext == null || analysisContext.readWorkbookHolder() == null) {
        return;
    }
    ReadWorkbookHolder readWorkbookHolder = analysisContext.readWorkbookHolder();
    Throwable throwable = null;
    try {
        if (readWorkbookHolder.getReadCache() != null) {
            readWorkbookHolder.getReadCache().destroy();
        }
    } catch (Throwable t) {
        throwable = t;
    }
    try {
        if ((readWorkbookHolder instanceof XlsxReadWorkbookHolder) && ((XlsxReadWorkbookHolder) readWorkbookHolder).getOpcPackage() != null) {
            ((XlsxReadWorkbookHolder) readWorkbookHolder).getOpcPackage().revert();
        }
    } catch (Throwable t) {
        throwable = t;
    }
    try {
        if ((readWorkbookHolder instanceof XlsReadWorkbookHolder) && ((XlsReadWorkbookHolder) readWorkbookHolder).getPoifsFileSystem() != null) {
            ((XlsReadWorkbookHolder) readWorkbookHolder).getPoifsFileSystem().close();
        }
    } catch (Throwable t) {
        throwable = t;
    }
    // https://github.com/alibaba/easyexcel/issues/2309
    try {
        if ((readWorkbookHolder instanceof CsvReadWorkbookHolder) && ((CsvReadWorkbookHolder) readWorkbookHolder).getCsvParser() != null) {
            ((CsvReadWorkbookHolder) readWorkbookHolder).getCsvParser().close();
        }
    } catch (Throwable t) {
        throwable = t;
    }
    try {
        if (analysisContext.readWorkbookHolder().getAutoCloseStream() && readWorkbookHolder.getInputStream() != null) {
            readWorkbookHolder.getInputStream().close();
        }
    } catch (Throwable t) {
        throwable = t;
    }
    try {
        if (readWorkbookHolder.getTempFile() != null) {
            FileUtils.delete(readWorkbookHolder.getTempFile());
        }
    } catch (Throwable t) {
        throwable = t;
    }
    clearEncrypt03();
    removeThreadLocalCache();
    if (throwable != null) {
        throw new ExcelAnalysisException("Can not close IO.", throwable);
    }
}