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

            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

        checkRowCount(wb);
    }


    @Test
    public void showInPaneManyRowsBug55248SXSSF() {
        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

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

        // now write the file and read it back in
        XSSFWorkbook wbWritten = XSSFTestDataSamples.writeOutAndReadBack(wb);
        verifyBug54084Unicode(wbWritten);


        // finally also write it out via the streaming interface and verify that we still can read it back in
        Workbook wbStreamingWritten = SXSSFITestDataProvider.instance.writeOutAndReadBack(new SXSSFWorkbook(wb));
        verifyBug54084Unicode(wbStreamingWritten);
    }

View Full Code Here

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

            headers.add(cell.getStringCellValue());
        }


        // save the worksheet as-is using SXSSF
        File outputFile = TempFile.createTempFile("poi-56274", ".xlsx");
        SXSSFWorkbook outputWorkbook = new org.apache.poi.xssf.streaming.SXSSFWorkbook(inputWorkbook);
        outputWorkbook.write(new FileOutputStream(outputFile));


        // re-read the saved file and make sure headers in the xml are in the original order
        inputWorkbook = new org.apache.poi.xssf.usermodel.XSSFWorkbook(new FileInputStream(outputFile));
        CTTable ctTable = inputWorkbook.getSheetAt(0).getTables().get(0).getCTTable();
        List<CTTableColumn> ctTableColumnList = ctTable.getTableColumns().getTableColumnList();

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

        checkRowCount(wb);
    }


    @Test
    public void showInPaneManyRowsBug55248SXSSF() {
        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

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

    private SXSSFITestDataProvider() {
        // enforce singleton
    }
    public Workbook openSampleWorkbook(String sampleFileName) {
      XSSFWorkbook xssfWorkbook = XSSFITestDataProvider.instance.openSampleWorkbook(sampleFileName);
      return new SXSSFWorkbook(xssfWorkbook);
    }

View Full Code Here

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

            throw new RuntimeException(e);
        }
        return result;
    }
    public SXSSFWorkbook createWorkbook(){
        return new SXSSFWorkbook();
    }

View Full Code Here

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

    Outlining o = new Outlining();
    o.collapseRow();
  }


  private void collapseRow() throws Exception {
    SXSSFWorkbook wb2 = new SXSSFWorkbook(100);
    SXSSFSheet sheet2 = (SXSSFSheet) wb2.createSheet("new sheet");


    int rowCount = 20;
    for (int i = 0; i < rowCount; i++) {
      sheet2.createRow(i);
    }


    sheet2.groupRow(4, 9);
    sheet2.groupRow(11, 19);


    sheet2.setRowGroupCollapsed(4, true);


    FileOutputStream fileOut = new FileOutputStream("outlining_collapsed.xlsx");
    wb2.write(fileOut);
    fileOut.close();
    wb2.dispose();
  }

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.