Examples of SXSSFSheet


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
Copyright © 2018 www.massapi.com. All rights reserved.
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.