Examples with XlsxReadContext com.alibaba.excel.context.xlsx.XlsxReadContext used on opensource projects

Example 1 with XlsxReadContext

use of com.alibaba.excel.context.xlsx.XlsxReadContext in project easyexcel by alibaba.

the class ExcelAnalyserImpl method choiceExcelExecutor.

private void choiceExcelExecutor(ReadWorkbook readWorkbook) throws Exception {
    ExcelTypeEnum excelType = ExcelTypeEnum.valueOf(readWorkbook);
    switch(excelType) {
        case XLS:
            POIFSFileSystem poifsFileSystem;
            if (readWorkbook.getFile() != null) {
                poifsFileSystem = new POIFSFileSystem(readWorkbook.getFile());
            } else {
                poifsFileSystem = new POIFSFileSystem(readWorkbook.getInputStream());
            }
            // So in encrypted excel, it looks like XLS but it's actually XLSX
            if (poifsFileSystem.getRoot().hasEntry(Decryptor.DEFAULT_POIFS_ENTRY)) {
                InputStream decryptedStream = null;
                try {
                    decryptedStream = DocumentFactoryHelper.getDecryptedStream(poifsFileSystem.getRoot().getFileSystem(), readWorkbook.getPassword());
                    XlsxReadContext xlsxReadContext = new DefaultXlsxReadContext(readWorkbook, ExcelTypeEnum.XLSX);
                    analysisContext = xlsxReadContext;
                    excelReadExecutor = new XlsxSaxAnalyser(xlsxReadContext, decryptedStream);
                    return;
                } finally {
                    IOUtils.closeQuietly(decryptedStream);
                    // as we processed the full stream already, we can close the filesystem here
                    // otherwise file handles are leaked
                    poifsFileSystem.close();
                }
            }
            if (readWorkbook.getPassword() != null) {
                Biff8EncryptionKey.setCurrentUserPassword(readWorkbook.getPassword());
            }
            XlsReadContext xlsReadContext = new DefaultXlsReadContext(readWorkbook, ExcelTypeEnum.XLS);
            xlsReadContext.xlsReadWorkbookHolder().setPoifsFileSystem(poifsFileSystem);
            analysisContext = xlsReadContext;
            excelReadExecutor = new XlsSaxAnalyser(xlsReadContext);
            break;
        case XLSX:
            XlsxReadContext xlsxReadContext = new DefaultXlsxReadContext(readWorkbook, ExcelTypeEnum.XLSX);
            analysisContext = xlsxReadContext;
            excelReadExecutor = new XlsxSaxAnalyser(xlsxReadContext, null);
            break;
        case CSV:
            CsvReadContext csvReadContext = new DefaultCsvReadContext(readWorkbook, ExcelTypeEnum.CSV);
            analysisContext = csvReadContext;
            excelReadExecutor = new CsvExcelReadExecutor(csvReadContext);
            break;
        default:
            break;
    }
}