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

Example 1 with ExcelAnalysisException

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

the class XlsxSaxAnalyser method parseXmlSource.

private void parseXmlSource(InputStream inputStream, ContentHandler handler) {
    InputSource inputSource = new InputSource(inputStream);
    try {
        SAXParserFactory saxFactory;
        String xlsxSAXParserFactoryName = xlsxReadContext.xlsxReadWorkbookHolder().getSaxParserFactoryName();
        if (StringUtils.isEmpty(xlsxSAXParserFactoryName)) {
            saxFactory = SAXParserFactory.newInstance();
        } else {
            saxFactory = SAXParserFactory.newInstance(xlsxSAXParserFactoryName, null);
        }
        try {
            saxFactory.setFeature("http://apache.org/xml/features/disallow-doctype-decl", true);
        } catch (Throwable ignore) {
        }
        try {
            saxFactory.setFeature("http://xml.org/sax/features/external-general-entities", false);
        } catch (Throwable ignore) {
        }
        try {
            saxFactory.setFeature("http://xml.org/sax/features/external-parameter-entities", false);
        } catch (Throwable ignore) {
        }
        SAXParser saxParser = saxFactory.newSAXParser();
        XMLReader xmlReader = saxParser.getXMLReader();
        xmlReader.setContentHandler(handler);
        xmlReader.parse(inputSource);
        inputStream.close();
    } catch (IOException | ParserConfigurationException | SAXException e) {
        throw new ExcelAnalysisException(e);
    } finally {
        if (inputStream != null) {
            try {
                inputStream.close();
            } catch (IOException e) {
                throw new ExcelAnalysisException("Can not close 'inputStream'!");
            }
        }
    }
}

Example 2 with ExcelAnalysisException

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

the class ExcelAnalyserImpl method analysis.

@Override
public void analysis(List<ReadSheet> readSheetList, Boolean readAll) {
    try {
        if (!readAll && CollectionUtils.isEmpty(readSheetList)) {
            throw new IllegalArgumentException("Specify at least one read sheet.");
        }
        analysisContext.readWorkbookHolder().setParameterSheetDataList(readSheetList);
        analysisContext.readWorkbookHolder().setReadAll(readAll);
        try {
            excelReadExecutor.execute();
        } catch (ExcelAnalysisStopException e) {
            if (LOGGER.isDebugEnabled()) {
                LOGGER.debug("Custom stop!");
            }
        }
    } catch (RuntimeException e) {
        finish();
        throw e;
    } catch (Throwable e) {
        finish();
        throw new ExcelAnalysisException(e);
    }
}

Example 3 with ExcelAnalysisException

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

the class XlsListSheetListener method execute.

public void execute() {
    MissingRecordAwareHSSFListener listener = new MissingRecordAwareHSSFListener(this);
    HSSFListener formatListener = new FormatTrackingHSSFListener(listener);
    HSSFEventFactory factory = new HSSFEventFactory();
    HSSFRequest request = new HSSFRequest();
    EventWorkbookBuilder.SheetRecordCollectingListener workbookBuildingListener = new EventWorkbookBuilder.SheetRecordCollectingListener(formatListener);
    request.addListenerForAllRecords(workbookBuildingListener);
    try {
        factory.processWorkbookEvents(request, xlsReadContext.xlsReadWorkbookHolder().getPoifsFileSystem());
    } catch (IOException e) {
        throw new ExcelAnalysisException(e);
    }
}

Example 4 with ExcelAnalysisException

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

the class XlsSaxAnalyser method execute.

@Override
public void execute() {
    XlsReadWorkbookHolder xlsReadWorkbookHolder = xlsReadContext.xlsReadWorkbookHolder();
    MissingRecordAwareHSSFListener listener = new MissingRecordAwareHSSFListener(this);
    xlsReadWorkbookHolder.setFormatTrackingHSSFListener(new FormatTrackingHSSFListener(listener));
    EventWorkbookBuilder.SheetRecordCollectingListener workbookBuildingListener = new EventWorkbookBuilder.SheetRecordCollectingListener(xlsReadWorkbookHolder.getFormatTrackingHSSFListener());
    xlsReadWorkbookHolder.setHssfWorkbook(workbookBuildingListener.getStubHSSFWorkbook());
    HSSFEventFactory factory = new HSSFEventFactory();
    HSSFRequest request = new HSSFRequest();
    request.addListenerForAllRecords(xlsReadWorkbookHolder.getFormatTrackingHSSFListener());
    try {
        factory.processWorkbookEvents(request, xlsReadWorkbookHolder.getPoifsFileSystem());
    } catch (IOException e) {
        throw new ExcelAnalysisException(e);
    }
}

Example 5 with ExcelAnalysisException

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

the class FileUtils method writeToFile.

/**
 * Write inputStream to file
 *
 * @param file file
 * @param inputStream inputStream
 * @param closeInputStream closeInputStream
 */
public static void writeToFile(File file, InputStream inputStream, boolean closeInputStream) {
    OutputStream outputStream = null;
    try {
        outputStream = new FileOutputStream(file);
        int bytesRead;
        byte[] buffer = new byte[WRITE_BUFF_SIZE];
        while ((bytesRead = inputStream.read(buffer, 0, WRITE_BUFF_SIZE)) != -1) {
            outputStream.write(buffer, 0, bytesRead);
        }
    } catch (Exception e) {
        throw new ExcelAnalysisException("Can not create temporary file!", e);
    } finally {
        if (outputStream != null) {
            try {
                outputStream.close();
            } catch (IOException e) {
                throw new ExcelAnalysisException("Can not close 'outputStream'!", e);
            }
        }
        if (inputStream != null && closeInputStream) {
            try {
                inputStream.close();
            } catch (IOException e) {
                throw new ExcelAnalysisException("Can not close 'inputStream'", e);
            }
        }
    }
}