Example usage for org.apache.poi.xssf.usermodel XSSFWorkbook 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.Issue78ExceptionCreatingTableName.java

License:Open Source License

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

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

        assertEquals(1, workbook.getNumberOfSheets());

    } finally {
        inputStream.close();
    }
    inputStream.close();
}

---

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

License:Open Source License

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

    debug = false;//  w  w w  .ja v  a2 s  .co  m
    InputStream inputStream = runAndRenderReport("Issue82TableInFooter.rptdesign", "xlsx");
    assertNotNull(inputStream);
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());

        Sheet sheet = workbook.getSheetAt(0);
        assertEquals(4, this.firstNullRow(sheet));
    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

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

    debug = false;//from w ww .  ja  v  a2s.  c  om
    InputStream inputStream = runAndRenderReport("Issue86BlankRowInGroupHeader.rptdesign", "xlsx");
    assertNotNull(inputStream);
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());

        Sheet sheet = workbook.getSheetAt(0);
        assertEquals(123, this.firstNullRow(sheet));
    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

@Test
public void testPrintPagesXlsx() throws Exception {

    scale = false;//from   www.j av  a 2 s  .c  o  m
    InputStream inputStream = runAndRenderReport("BigCrosstab.rptdesign", "xlsx");
    assertNotNull(inputStream);
    try {

        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());
        assertEquals(13, workbook.getNumCellStyles());
        assertEquals("Big Crosstab Report 1", workbook.getSheetAt(0).getSheetName());

        assertEquals(2, workbook.getSheetAt(0).getPrintSetup().getFitWidth());
        assertEquals(3, workbook.getSheetAt(0).getPrintSetup().getFitHeight());
        assertEquals(true, workbook.getSheetAt(0).getAutobreaks());

        assertEquals(60, workbook.getSheetAt(0).getRow(1).getCell(2).getCellStyle().getRotation());
        assertEquals(60, workbook.getSheetAt(0).getRow(2).getCell(2).getCellStyle().getRotation());
        assertEquals(60, workbook.getSheetAt(0).getRow(2).getCell(3).getCellStyle().getRotation());
        assertEquals(0, workbook.getSheetAt(0).getRow(3).getCell(2).getCellStyle().getRotation());

        assertTrue(runTime - startTime < 4500L);
        assertTrue(renderTime - runTime < 4000L);

        Sheet sheet = workbook.getSheetAt(0);
        assertEquals(236, firstNullRow(sheet));

        assertEquals(28, greatestNumColumns(sheet));

    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

@Test
public void testPrintScaleXlsx() throws Exception {

    scale = true;// w w w. j a v  a  2s  .c o m
    InputStream inputStream = runAndRenderReport("BigCrosstab.rptdesign", "xlsx");
    assertNotNull(inputStream);
    try {

        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());
        assertEquals(13, workbook.getNumCellStyles());
        assertEquals("Big Crosstab Report 1", workbook.getSheetAt(0).getSheetName());

        assertEquals(27, workbook.getSheetAt(0).getPrintSetup().getScale());
        //I don't know why, but this is returning true and the output is still good
        //assertEquals( false, workbook.getSheetAt(0).getAutobreaks() );

        assertEquals(60, workbook.getSheetAt(0).getRow(1).getCell(2).getCellStyle().getRotation());
        assertEquals(60, workbook.getSheetAt(0).getRow(2).getCell(2).getCellStyle().getRotation());
        assertEquals(60, workbook.getSheetAt(0).getRow(2).getCell(3).getCellStyle().getRotation());
        assertEquals(0, workbook.getSheetAt(0).getRow(3).getCell(2).getCellStyle().getRotation());

        assertTrue(runTime - startTime < 4500L);
        assertTrue(renderTime - runTime < 4000L);

        Sheet sheet = workbook.getSheetAt(0);
        assertEquals(236, firstNullRow(sheet));

        assertEquals(28, greatestNumColumns(sheet));

    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

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

    debug = false;//  ww  w .  j  av  a2s  .com
    removeEmptyRows = false;
    spannedRowHeight = null;
    InputStream inputStream = runAndRenderReport("Issue94DisableRowSpanAutoHeightAtRow.rptdesign", "xlsx");
    assertNotNull(inputStream);
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());

        Sheet sheet = workbook.getSheetAt(0);
        assertEquals(9, this.lastRow(sheet));

        assertEquals(sheet.getRow(0).getHeight(), sheet.getRow(1).getHeight());
        assertEquals(sheet.getRow(3).getHeight(), sheet.getRow(4).getHeight());
        assertTrue(sheet.getRow(6).getHeight() < sheet.getRow(7).getHeight());
        assertTrue(sheet.getRow(6).getHeight() > sheet.getRow(8).getHeight());
        assertTrue(sheet.getRow(7).getHeight() > sheet.getRow(8).getHeight());
    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

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

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

        assertEquals(1, workbook.getNumberOfSheets());

        Sheet sheet = workbook.getSheetAt(0);
        assertEquals(2002, this.firstNullRow(sheet));

        for (int i = 1; i < 2000; ++i) {
            assertEquals("http://www.spudsoft.co.uk/?p=" + i,
                    sheet.getRow(i).getCell(0).getHyperlink().getAddress());

            assertEquals(
                    "run?__report=Issue95ClickThroughHyperlinks.rptdesign&Pointless=" + i + "&__overwrite=true",
                    sheet.getRow(i).getCell(1).getHyperlink().getAddress());
        }

    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

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

    debug = false;//from w  w  w . j  a va  2s  .  com
    InputStream inputStream = runAndRenderReport("Lists.rptdesign", "xlsx");
    assertNotNull(inputStream);
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(28, workbook.getNumberOfSheets());

        assertEquals(17, this.firstNullRow(workbook.getSheetAt(0)));
        assertEquals(11, this.firstNullRow(workbook.getSheetAt(1)));
        assertEquals(11, this.firstNullRow(workbook.getSheetAt(2)));
        assertEquals(13, this.firstNullRow(workbook.getSheetAt(3)));
        assertEquals(11, this.firstNullRow(workbook.getSheetAt(4)));
        assertEquals(13, this.firstNullRow(workbook.getSheetAt(5)));
        assertEquals(31, this.firstNullRow(workbook.getSheetAt(6)));
        assertEquals(33, this.firstNullRow(workbook.getSheetAt(7)));
        assertEquals(9, this.firstNullRow(workbook.getSheetAt(8)));
        assertEquals(11, this.firstNullRow(workbook.getSheetAt(9)));

        assertEquals("Australia", workbook.getSheetAt(0).getSheetName());
        assertEquals("Austria", workbook.getSheetAt(1).getSheetName());

    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

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

    InputStream inputStream = runAndRenderReportAsOne("MultiSheetsPassword.rptdesign", "xlsx");
    assertNotNull(inputStream);//from w w w . j  a va2s .  c  o  m
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(3, workbook.getNumberOfSheets());
        assertEquals("Number Formats 1", workbook.getSheetAt(0).getSheetName());
        assertEquals("Number Formats 2", workbook.getSheetAt(1).getSheetName());
        assertEquals("Number Formats 3", workbook.getSheetAt(2).getSheetName());

        assertEquals(4, firstNullRow(workbook.getSheetAt(0)));
        assertEquals(4, firstNullRow(workbook.getSheetAt(1)));
        assertEquals(3, firstNullRow(workbook.getSheetAt(2)));

        assertEquals(true, workbook.getSheetAt(0).isDisplayGridlines());
        assertEquals(false, workbook.getSheetAt(1).isDisplayGridlines());
        assertEquals(false, workbook.getSheetAt(2).isDisplayGridlines());
        assertEquals(true, workbook.getSheetAt(0).isDisplayRowColHeadings());
        assertEquals(false, workbook.getSheetAt(1).isDisplayGridlines());
        assertEquals(true, workbook.getSheetAt(2).isDisplayRowColHeadings());

        assertEquals(true, workbook.getSheetAt(0).getProtect());
        assertEquals(false, workbook.getSheetAt(1).getProtect());
        assertEquals(true, workbook.getSheetAt(2).getProtect());
    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

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

    InputStream inputStream = runAndRenderReport("ListsPassword.rptdesign", "xlsx");
    assertNotNull(inputStream);//from w w w.  j a v  a 2 s . c  o m
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(28, workbook.getNumberOfSheets());

        assertEquals(17, this.firstNullRow(workbook.getSheetAt(0)));
        assertEquals(11, this.firstNullRow(workbook.getSheetAt(1)));
        assertEquals(11, this.firstNullRow(workbook.getSheetAt(2)));
        assertEquals(13, this.firstNullRow(workbook.getSheetAt(3)));
        assertEquals(11, this.firstNullRow(workbook.getSheetAt(4)));
        assertEquals(13, this.firstNullRow(workbook.getSheetAt(5)));
        assertEquals(31, this.firstNullRow(workbook.getSheetAt(6)));
        assertEquals(33, this.firstNullRow(workbook.getSheetAt(7)));
        assertEquals(9, this.firstNullRow(workbook.getSheetAt(8)));
        assertEquals(11, this.firstNullRow(workbook.getSheetAt(9)));

        assertEquals("Australia", workbook.getSheetAt(0).getSheetName());
        assertEquals("Austria", workbook.getSheetAt(1).getSheetName());

        for (int i = 0; i < 28; ++i) {
            assertEquals(true, workbook.getSheetAt(i).getProtect());
        }

    } finally {
        inputStream.close();
    }
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• »