Examples of SXSSFSheet

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

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

    // write using streaming writer
    {
      ExcelDataContext dc = new ExcelDataContext(file);
      ExcelUpdateCallback callback = new ExcelUpdateCallback(dc);


      SXSSFSheet sheet = (SXSSFSheet) callback.createSheet("foobar");


      Field windowSizeField = SXSSFSheet.class
          .getDeclaredField("_randomAccessWindowSize");
      windowSizeField.setAccessible(true);
      int windowSize = windowSizeField.getInt(sheet);
      assertEquals(1000, windowSize);


      Field rowsField = SXSSFSheet.class.getDeclaredField("_rows");
      rowsField.setAccessible(true);
      @SuppressWarnings("unchecked")
      Map<Integer, SXSSFRow> rows = (Map<Integer, SXSSFRow>) rowsField
          .get(sheet);
      assertEquals(0, rows.size());


      // create 5x the amound of rows as the streaming sheet will hold in
      // memory
      for (int i = 0; i < windowSize * 5; i++) {
        Row row = sheet.createRow(i);
        Cell cell = row.createCell(0);
        cell.setCellValue("value" + i);


        assertTrue(rows.size() <= 1000);
      }


      assertEquals(1000, rows.size());


      ExcelUtils.writeWorkbook(dc, sheet.getWorkbook());
    }


    assertTrue("Usually the file size will be circa 42000, but it was: "
        + file.length(), file.length() > 40000 && file.length() < 45000);

View Full Code Here

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

    }


    @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);
            sheet.showInPane(i, 0);
            // this one fails: sheet.showInPane((short)i, 0);
        }


        int i = 0;
        sheet.showInPane(i, i);


        Workbook wb = SXSSFITestDataProvider.instance.writeOutAndReadBack(workbook);
        checkRowCount(wb);
    }

View Full Code Here

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

    }


    @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);
            sheet.showInPane(i, 0);
            // this one fails: sheet.showInPane((short)i, 0);
        }


        int i = 0;
        sheet.showInPane(i, i);


        Workbook wb = SXSSFITestDataProvider.instance.writeOutAndReadBack(workbook);
        checkRowCount(wb);
    }

View Full Code Here

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

    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

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

    }


    @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);
            sheet.showInPane(i, 0);
            // this one fails: sheet.showInPane((short)i, 0);
        }


        int i = 0;
        sheet.showInPane(i, i);


        Workbook wb = SXSSFITestDataProvider.instance.writeOutAndReadBack(workbook);
        checkRowCount(wb);
    }

View Full Code Here

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

        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);
            sheet.showInPane(i, 0);
            // this one fails: sheet.showInPane((short)i, 0);
        }
        
        short i = 0;
        sheet.showInPane(i, i);
        
        Workbook wb = SXSSFITestDataProvider.instance.writeOutAndReadBack(workbook);
        checkRowCount(wb);
    }

View Full Code Here

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.