Examples of SXSSFWorkbook

org.apache.poi.xssf.streaming.SXSSFWorkbook
Streaming version of XSSFWorkbook implementing the "BigGridDemo" strategy. @author Alex Geller, Four J's Development Tools

Examples of org.apache.poi.xssf.streaming.SXSSFWorkbook

    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 {
                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);
        }

View Full Code Here

Examples of org.apache.poi.xssf.streaming.SXSSFWorkbook

    }
    
    public void testExistingWorkbook() {
      XSSFWorkbook xssfWorkbook = new XSSFWorkbook();
      xssfWorkbook.createSheet("S1");
      SXSSFWorkbook wb = new SXSSFWorkbook(xssfWorkbook);
      xssfWorkbook = (XSSFWorkbook) SXSSFITestDataProvider.instance.writeOutAndReadBack(wb);
      wb = new SXSSFWorkbook(xssfWorkbook);
      assertEquals(1, wb.getNumberOfSheets());
      Sheet sheet  = wb.getSheetAt(0);
      assertNotNull(sheet);
      assertEquals("S1", sheet.getSheetName());
    }

View Full Code Here

Examples of org.apache.poi.xssf.streaming.SXSSFWorkbook

      xssfWorkbook.createSheet("S1");
      Sheet sheet = xssfWorkbook.createSheet("S2");
      Row row = sheet.createRow(1);
      Cell cell = row.createCell(1);
      cell.setCellValue("value 2_1_1");
      SXSSFWorkbook wb = new SXSSFWorkbook(xssfWorkbook);
      xssfWorkbook = (XSSFWorkbook) SXSSFITestDataProvider.instance.writeOutAndReadBack(wb);
      wb = new SXSSFWorkbook(xssfWorkbook);
      
      // Add a row to the existing empty sheet
      Sheet sheet1 = wb.getSheetAt(0);
      Row row1_1 = sheet1.createRow(1);
      Cell cell1_1_1 = row1_1.createCell(1);
      cell1_1_1.setCellValue("value 1_1_1");
      
      // Add a row to the existing non-empty sheet
      Sheet sheet2 = wb.getSheetAt(1);
      Row row2_2 = sheet2.createRow(2);
      Cell cell2_2_1 = row2_2.createCell(1);
      cell2_2_1.setCellValue("value 2_2_1");
      
      // Add a sheet with one row
      Sheet sheet3 = wb.createSheet("S3");
      Row row3_1 = sheet3.createRow(1);
      Cell cell3_1_1 = row3_1.createCell(1);
      cell3_1_1.setCellValue("value 3_1_1");
      
      xssfWorkbook = (XSSFWorkbook) SXSSFITestDataProvider.instance.writeOutAndReadBack(wb);

View Full Code Here

Examples of org.apache.poi.xssf.streaming.SXSSFWorkbook

    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 {
                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);
        }

View Full Code Here

Examples of org.apache.poi.xssf.streaming.SXSSFWorkbook

   * 初始化函数
   * @param title 表格标题，传“空值”，表示无标题
   * @param headerList 表头列表
   */
  private void initialize(String title, List<String> headerList) {
    this.wb = new SXSSFWorkbook(500);
    this.sheet = wb.createSheet("Export");
    this.styles = createStyles(wb);
    // Create title
    if (StringUtils.isNotBlank(title)){
      Row titleRow = sheet.createRow(rownum++);

View Full Code Here

Examples of org.apache.poi.xssf.streaming.SXSSFWorkbook

    /**
     * Returns a new SXSSFWorkbook workbook
     */
    @Override
    protected Workbook getNewWorkbook() {
        return new SXSSFWorkbook(1);
    }

View Full Code Here

Examples of org.apache.poi.xssf.streaming.SXSSFWorkbook

        assertEquals("Did not match for sheet " + si, topRows[si], sh.getTopRow());
      }


      // for XSSF also test with SXSSF
      if(isXSSF) {
      Workbook swb = new SXSSFWorkbook((XSSFWorkbook) wb);
        for (int si = 0; si < swb.getNumberOfSheets(); si++) {
          Sheet sh = swb.getSheetAt(si);
          assertNotNull(sh.getSheetName());
          assertEquals("Did not match for sheet " + si, topRows[si], sh.getTopRow());
        }
      }
  }

View Full Code Here

Examples of org.apache.poi.xssf.streaming.SXSSFWorkbook

        assertEquals("Did not match for sheet " + si, topRows[si], sh.getLeftCol());
      }


      // for XSSF also test with SXSSF
      if(isXSSF) {
      Workbook swb = new SXSSFWorkbook((XSSFWorkbook) wb);
        for (int si = 0; si < swb.getNumberOfSheets(); si++) {
          Sheet sh = swb.getSheetAt(si);
          assertNotNull(sh.getSheetName());
          assertEquals("Did not match for sheet " + si, topRows[si], sh.getLeftCol());
        }
      }
  }

View Full Code Here

Examples of org.apache.poi.xssf.streaming.SXSSFWorkbook

        XSSFWorkbook wb = XSSFTestDataSamples.writeOutAndReadBack(workbook);
        checkRowCount(wb);
  }


    public void testShowInPaneManyRowsBug55248SXSSF() {
        SXSSFWorkbook workbook = new SXSSFWorkbook(new XSSFWorkbook());
        SXSSFSheet sheet = (SXSSFSheet) workbook.createSheet("Sheet 1");
        
        sheet.showInPane(0, 0);
        
        for(int i = ROW_COUNT/2;i < ROW_COUNT;i++) {
            sheet.createRow(i);

View Full Code Here

0 1 2 3 4

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.