Example usage for org.apache.poi.xssf.streaming SXSSFWorkbook SXSSFWorkbook

Introduction

In this page you can find the example usage for org.apache.poi.xssf.streaming SXSSFWorkbook SXSSFWorkbook.

Prototype

public SXSSFWorkbook(XSSFWorkbook workbook, int rowAccessWindowSize, boolean compressTmpFiles) 

Source Link

Document

Constructs an workbook from an existing workbook.

Usage

From source file:net.pcal.sqlsheet.XlsDriver.java

License:Apache License

private SXSSFWorkbook getOrCreateXlsxStream(URL workbookUrl) throws IOException, InvalidFormatException {
    if (workbookUrl.getProtocol().equalsIgnoreCase("file")) {
        File source = new File(workbookUrl.getPath());
        if (source.exists() || (source.length() != 0)) {
            logger.warning("File " + source.getPath() + " is not empty, and will parsed to memory!");
        } else {//from  w  w w. j a v  a2s  .com
            Workbook workbook = new XSSFWorkbook();
            flushWorkbook(workbook, source);
        }
    }
    return new SXSSFWorkbook(new XSSFWorkbook(workbookUrl.openStream()), 1000, false);
}

---

From source file:org.jberet.support.io.ExcelStreamingItemWriter.java

License:Open Source License

@Override
protected Workbook createWorkbook(final InputStream templateInputStream)
        throws IOException, InvalidFormatException {
    if (templateInputStream != null) {
        final Workbook template = WorkbookFactory.create(templateInputStream);
        if (template instanceof XSSFWorkbook) {
            workbook = compressTempFiles == Boolean.TRUE
                    ? new SXSSFWorkbook((XSSFWorkbook) template, -1, compressTempFiles)
                    : new SXSSFWorkbook((XSSFWorkbook) template, -1);
            return template;
        } else {/*from   w  ww . jav  a2s  .  com*/
            throw SupportMessages.MESSAGES.incompatibleExcelFileFormat(templateResource);
        }
    } else if (resource.endsWith("xlsx")) {
        final SXSSFWorkbook workbook1 = new SXSSFWorkbook(-1);
        if (compressTempFiles == Boolean.TRUE) {
            workbook1.setCompressTempFiles(true);
        }
        workbook = workbook1;
    } else {
        throw SupportMessages.MESSAGES.incompatibleExcelFileFormat(resource);
    }
    return null;
}

---