Example usage for org.apache.poi.xssf.usermodel XSSFWorkbook getNumberOfSheets

List of usage examples for org.apache.poi.xssf.usermodel XSSFWorkbook getNumberOfSheets

  1. HOME
  2. Java
  3. org.apache.poi
  4. org.apache.poi.xssf.usermodel.*
  5. XSSFWorkbook
  6. getNumberOfSheets

Introduction

In this page you can find the example usage for org.apache.poi.xssf.usermodel XSSFWorkbook getNumberOfSheets.

Prototype

@Override
public int getNumberOfSheets()

Source Link

Document

Get the number of worksheets in the this workbook

Usage

From source file:uk.co.spudsoft.birt.emitters.excel.tests.Issue46RemoveBlankRowsUserProperties.java

License:Open Source License

@Test
public void testWithUserPropertyOnTable() throws Exception {

    debug = false;/*from  w  ww .jav a  2s . c  o  m*/
    structuredHeader = false;
    InputStream inputStream = runAndRenderReport("BlankRowsDisabledAtTable.rptdesign", "xlsx");
    assertNotNull(inputStream);
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());

        assertEquals(11, this.firstNullRow(workbook.getSheetAt(0)));
    } finally {
        inputStream.close();
    }
}

From source file:uk.co.spudsoft.birt.emitters.excel.tests.Issue50MultiRowCrosstabHeaderGrids.java

License:Open Source License

@Test
public void testHeader() throws Exception {

    debug = false;/* w  w w .  j a  va 2 s.co m*/
    InputStream inputStream = runAndRenderReport("Issue50MultiRowCrosstabHeaderGrids.rptdesign", "xlsx");
    assertNotNull(inputStream);
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());

        Sheet sheet = workbook.getSheetAt(0);
        assertEquals("Atelier graphique", sheet.getRow(2).getCell(1).getStringCellValue());
        assertTrue(mergedRegion(sheet, 0, 0, 1, 0));
        assertTrue(mergedRegion(sheet, 0, 1, 1, 1));
        assertEquals(34, sheet.getNumMergedRegions());

        assertEquals(100, this.firstNullRow(workbook.getSheetAt(0)));
    } finally {
        inputStream.close();
    }

}

From source file:uk.co.spudsoft.birt.emitters.excel.tests.Issue55GroupsNotWorkingCorrectly.java

License:Open Source License

@Test
public void testHeader() throws Exception {

    debug = false;/*from   w ww. j a  v a 2 s.  c o m*/
    groupSummaryHeader = true;
    InputStream inputStream = runAndRenderReport("Issue55.rptdesign", "xlsx");
    assertNotNull(inputStream);
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());

        XSSFSheet sheet0 = workbook.getSheetAt(0);

        assertEquals(!groupSummaryHeader, sheet0.getRowSumsBelow());

        assertEquals(0, sheet0.getRow(0).getCTRow().getOutlineLevel());
        assertEquals(0, sheet0.getRow(1).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(2).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(3).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(4).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(5).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(6).getCTRow().getOutlineLevel());
        assertEquals(0, sheet0.getRow(7).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(8).getCTRow().getOutlineLevel());

    } finally {
        inputStream.close();
    }

}

From source file:uk.co.spudsoft.birt.emitters.excel.tests.Issue55GroupsNotWorkingCorrectly.java

License:Open Source License

@Test
public void testFooter() throws Exception {

    debug = false;//from  www  .jav a  2 s  .  c  om
    groupSummaryHeader = false;
    InputStream inputStream = runAndRenderReport("Issue55.rptdesign", "xlsx");
    assertNotNull(inputStream);
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());
        assertEquals(!groupSummaryHeader, workbook.getSheetAt(0).getRowSumsBelow());

        XSSFSheet sheet0 = workbook.getSheetAt(0);

        assertEquals(!groupSummaryHeader, sheet0.getRowSumsBelow());

        assertEquals(0, sheet0.getRow(0).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(1).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(2).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(3).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(4).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(5).getCTRow().getOutlineLevel());
        assertEquals(0, sheet0.getRow(6).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(7).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(8).getCTRow().getOutlineLevel());

    } finally {
        inputStream.close();
    }

}

From source file:uk.co.spudsoft.birt.emitters.excel.tests.Issue55GroupsNotWorkingCorrectly.java

License:Open Source License

@Test
public void testHeaderHierarchy() throws Exception {

    debug = false;/*from w ww.j a  v  a 2s  .  c  o m*/
    groupSummaryHeader = true;
    InputStream inputStream = runAndRenderReport("Issue55GroupHierarchy.rptdesign", "xlsx");
    assertNotNull(inputStream);
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());

        XSSFSheet sheet0 = workbook.getSheetAt(0);

        assertEquals(!groupSummaryHeader, sheet0.getRowSumsBelow());

        /*         for( int i = 0; i < 64; ++i ) {
                    System.out.println( "assertEquals( " + sheet0.getRow( i ).getCTRow().getOutlineLevel() + ", sheet0.getRow( " + i + " ).getCTRow().getOutlineLevel() );" );
                 }
        */
        assertEquals(0, sheet0.getRow(0).getCTRow().getOutlineLevel());
        assertEquals(0, sheet0.getRow(1).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(2).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(3).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(4).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(5).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(6).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(7).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(8).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(9).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(10).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(11).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(12).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(13).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(14).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(15).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(16).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(17).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(18).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(19).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(20).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(21).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(22).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(23).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(24).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(25).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(26).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(27).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(28).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(29).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(30).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(31).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(32).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(33).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(34).getCTRow().getOutlineLevel());
        assertEquals(0, sheet0.getRow(35).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(36).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(37).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(38).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(39).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(40).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(41).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(42).getCTRow().getOutlineLevel());
        assertEquals(0, sheet0.getRow(43).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(44).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(45).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(46).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(47).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(48).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(49).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(50).getCTRow().getOutlineLevel());
        assertEquals(0, sheet0.getRow(51).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(52).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(53).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(54).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(55).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(56).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(57).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(58).getCTRow().getOutlineLevel());
        assertEquals(0, sheet0.getRow(59).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(60).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(61).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(62).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(63).getCTRow().getOutlineLevel());

    } finally {
        inputStream.close();
    }

}

From source file:uk.co.spudsoft.birt.emitters.excel.tests.Issue55GroupsNotWorkingCorrectly.java

License:Open Source License

@Test
public void testFooterHierarchyWithHeader() throws Exception {

    /*/*from   w  ww.  j  a v  a  2 s . co  m*/
     *  Note that the results of this test are a yucky mess
     *  
     *  Excel groups with a summary row above or below the data rows.
     *  Each group has to have a distinct summary row - if you have two groups that try to end with the same summary row Excel represents them like the image on the right (you can still hide with the controls on the top of the grouping column, but not with the individual expand/collapse controls).
       *
     *   You can do one of three things:
     *   
     *       Give each group level a header row and set ExcelEmitter.GroupSummaryHeader.
     *       Give each group level a footer row and don't set ExcelEmitter.GroupSummaryHeader.
     *       Accept that you are going to get something odd :)
     *  
     */

    debug = false;
    groupSummaryHeader = false;
    InputStream inputStream = runAndRenderReport("Issue55GroupHierarchy.rptdesign", "xlsx");
    assertNotNull(inputStream);
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());
        assertEquals(!groupSummaryHeader, workbook.getSheetAt(0).getRowSumsBelow());

        XSSFSheet sheet0 = workbook.getSheetAt(0);

        assertEquals(!groupSummaryHeader, sheet0.getRowSumsBelow());

        /*         for( int i = 0; i < 64; ++i ) {
                    System.out.println( "assertEquals( " + sheet0.getRow( i ).getCTRow().getOutlineLevel() + ", sheet0.getRow( " + i + " ).getCTRow().getOutlineLevel() );" );
                 }
        */
        assertEquals(0, sheet0.getRow(0).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(1).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(2).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(3).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(4).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(5).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(6).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(7).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(8).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(9).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(10).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(11).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(12).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(13).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(14).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(15).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(16).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(17).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(18).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(19).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(20).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(21).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(22).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(23).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(24).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(25).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(26).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(27).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(28).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(29).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(30).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(31).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(32).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(33).getCTRow().getOutlineLevel());
        assertEquals(0, sheet0.getRow(34).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(35).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(36).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(37).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(38).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(39).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(40).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(41).getCTRow().getOutlineLevel());
        assertEquals(0, sheet0.getRow(42).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(43).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(44).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(45).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(46).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(47).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(48).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(49).getCTRow().getOutlineLevel());
        assertEquals(0, sheet0.getRow(50).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(51).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(52).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(53).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(54).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(55).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(56).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(57).getCTRow().getOutlineLevel());
        assertEquals(0, sheet0.getRow(58).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(59).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(60).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(61).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(62).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(63).getCTRow().getOutlineLevel());

    } finally {
        inputStream.close();
    }

}

From source file:uk.co.spudsoft.birt.emitters.excel.tests.Issue55GroupsNotWorkingCorrectly.java

License:Open Source License

@Test
public void testFooterHierarchy() throws Exception {

    debug = false;/*from   w  w  w.j av  a2  s .  co m*/
    groupSummaryHeader = false;
    InputStream inputStream = runAndRenderReport("Issue55GroupHierarchyBelow.rptdesign", "xlsx");
    assertNotNull(inputStream);
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());
        assertEquals(!groupSummaryHeader, workbook.getSheetAt(0).getRowSumsBelow());

        XSSFSheet sheet0 = workbook.getSheetAt(0);

        assertEquals(!groupSummaryHeader, sheet0.getRowSumsBelow());

        /*         for( int i = 0; i < 64; ++i ) {
                    System.out.println( "assertEquals( " + sheet0.getRow( i ).getCTRow().getOutlineLevel() + ", sheet0.getRow( " + i + " ).getCTRow().getOutlineLevel() );" );
                 }
        */
        assertEquals(0, sheet0.getRow(0).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(1).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(2).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(3).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(4).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(5).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(6).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(7).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(8).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(9).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(10).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(11).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(12).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(13).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(14).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(15).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(16).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(17).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(18).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(19).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(20).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(21).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(22).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(23).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(24).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(25).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(26).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(27).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(28).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(29).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(30).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(31).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(32).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(33).getCTRow().getOutlineLevel());
        assertEquals(0, sheet0.getRow(34).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(35).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(36).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(37).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(38).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(39).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(40).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(41).getCTRow().getOutlineLevel());
        assertEquals(0, sheet0.getRow(42).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(43).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(44).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(45).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(46).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(47).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(48).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(49).getCTRow().getOutlineLevel());
        assertEquals(0, sheet0.getRow(50).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(51).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(52).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(53).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(54).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(55).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(56).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(57).getCTRow().getOutlineLevel());
        assertEquals(0, sheet0.getRow(58).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(59).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(60).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(61).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(62).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(63).getCTRow().getOutlineLevel());

    } finally {
        inputStream.close();
    }

}

From source file:uk.co.spudsoft.birt.emitters.excel.tests.Issue56FreezePanes.java

License:Open Source License

@Test
public void testPanes() throws Exception {

    debug = false;/*from   w  ww  .ja v  a 2  s.c  o  m*/
    groupSummaryHeader = true;
    InputStream inputStream = runAndRenderReport("Issue56FreezePanes.rptdesign", "xlsx");
    assertNotNull(inputStream);
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());

        XSSFSheet sheet0 = workbook.getSheetAt(0);

        PaneInformation paneInfo = sheet0.getPaneInformation();
        assertEquals(true, paneInfo.isFreezePane());
        assertEquals(2, paneInfo.getVerticalSplitLeftColumn());
        assertEquals(1, paneInfo.getHorizontalSplitTopRow());
    } finally {
        inputStream.close();
    }

}

From source file:uk.co.spudsoft.birt.emitters.excel.tests.Issue58.java

License:Open Source License

@Test
public void testIssue58WithoutOption() throws BirtException, IOException {

    debug = false;//from   w w w .  ja  va  2  s .  c  o  m
    InputStream inputStream = runAndRenderReport("Issue58.rptdesign", "xlsx");
    assertNotNull(inputStream);
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());

        Sheet sheet = workbook.getSheetAt(0);
        assertEquals(21, this.firstNullRow(sheet));
        assertEquals(20, this.lastRow(sheet));

    } finally {
        inputStream.close();
    }
}

From source file:uk.co.spudsoft.birt.emitters.excel.tests.Issue58.java

License:Open Source License

@Test
public void testIssue58WithOption() throws BirtException, IOException {

    debug = false;//  w w  w. ja v a2s . c  o  m
    blankLineAfterTopLevelTable = true;
    InputStream inputStream = runAndRenderReport("Issue58.rptdesign", "xlsx");
    assertNotNull(inputStream);
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());

        Sheet sheet = workbook.getSheetAt(0);
        assertEquals(6, this.firstNullRow(sheet));
        assertEquals(21, this.lastRow(sheet));

    } finally {
        inputStream.close();
    }
}