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.RaggedCrosstabReportTest.java

License:Open Source License

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

    InputStream inputStream = runAndRenderReport("RaggedCrosstab.rptdesign", "xlsx");
    assertNotNull(inputStream);/*  w w  w  .ja va 2s . c om*/
    try {

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

        assertEquals(1, workbook.getNumberOfSheets());
        assertEquals("Ragged Crosstab Report", workbook.getSheetAt(0).getSheetName());

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

---

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

License:Open Source License

@Test
public void singleCells() throws Exception {
    debug = false;/*from   w  ww.j  a v  a 2s  .co  m*/
    InputStream inputStream = runAndRenderReport("SideBySideOneCellEach.rptdesign", "xlsx");
    assertNotNull(inputStream);
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());
        assertEquals("Sheet0", workbook.getSheetAt(0).getSheetName());

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

        assertEquals(305, sheet.getRow(0).getHeightInPoints(), 1.0);
        assertEquals(19346, sheet.getColumnWidth(0));
        assertEquals(19346, sheet.getColumnWidth(1));
    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

@Test
public void multiColumns() throws Exception {
    debug = false;//from  www.ja v  a 2  s.  c o m
    InputStream inputStream = runAndRenderReport("SideBySideMultiColumns.rptdesign", "xlsx");
    assertNotNull(inputStream);
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());
        assertEquals("Sheet0", workbook.getSheetAt(0).getSheetName());

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

        assertEquals(297, sheet.getRow(0).getHeightInPoints(), 1.0);
        assertEquals(2048, sheet.getColumnWidth(0));
        assertEquals(6196, sheet.getColumnWidth(1));
        assertEquals(3749, sheet.getColumnWidth(2));
        assertEquals(2396, sheet.getColumnWidth(3));
        assertEquals(4516, sheet.getColumnWidth(4));
        assertEquals(7072, sheet.getColumnWidth(5));
        assertEquals(2048, sheet.getColumnWidth(6));
        assertEquals(3509, sheet.getColumnWidth(7));
        assertEquals(2048, sheet.getColumnWidth(8));
        assertEquals(2314, sheet.getColumnWidth(9));
        assertEquals(2338, sheet.getColumnWidth(10));
        assertEquals(2048, sheet.getColumnWidth(11));
        assertEquals(2048, sheet.getColumnWidth(12));

        assertTrue(mergedRegion(sheet, 0, 0, 0, 5));
        assertTrue(mergedRegion(sheet, 0, 7, 0, 12));
    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

@Test
public void tables() throws Exception {
    debug = false;//from ww w . jav a 2s .  co  m
    removeEmptyRows = false;
    InputStream inputStream = runAndRenderReport("SideBySideTables.rptdesign", "xlsx");
    assertNotNull(inputStream);
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());
        assertEquals("Sheet0", workbook.getSheetAt(0).getSheetName());

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

        assertEquals(5522, sheet.getColumnWidth(0));
        assertEquals(2742, sheet.getColumnWidth(1));
        assertEquals(1353, sheet.getColumnWidth(2));
        assertEquals(5522, sheet.getColumnWidth(3));
        assertEquals(2742, sheet.getColumnWidth(4));

        assertTrue(mergedRegion(sheet, 0, 2, 28, 2));
        assertTrue(mergedRegion(sheet, 8, 3, 28, 3));
        assertTrue(mergedRegion(sheet, 8, 4, 28, 4));

    } finally {
        inputStream.close();
    }

}

---

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

License:Open Source License

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

    InputStream inputStream = runAndRenderReport("SimpleTable.rptdesign", "xlsx");
    assertNotNull(inputStream);//  w  w w  .jav a  2s . co  m
    try {

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

        assertEquals(1, workbook.getNumberOfSheets());
        assertEquals("Simple Table Report", workbook.getSheetAt(0).getSheetName());

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

        assertEquals("1", sheet.getRow(0).getCell(0).getStringCellValue());
        assertEquals("2", sheet.getRow(1).getCell(0).getStringCellValue());
        assertEquals(3.0, sheet.getRow(0).getCell(1).getNumericCellValue(), 0.001);
        assertEquals(Cell.CELL_TYPE_BLANK, sheet.getRow(1).getCell(1).getCellType());

        assertEquals("Title\nSubtitle", sheet.getHeader().getLeft());
        assertEquals("The Writer", sheet.getFooter().getLeft());
        assertEquals("1", sheet.getFooter().getCenter());
    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

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

    InputStream inputStream = runAndRenderReportAsOne("MultiSheets1.rptdesign", "xlsx");
    assertNotNull(inputStream);//www . j  a va 2 s.  com
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());
        assertEquals("Number Formats Test Report", workbook.getSheetAt(0).getSheetName());

        assertEquals(11, firstNullRow(workbook.getSheetAt(0)));

        assertEquals(false, workbook.getSheetAt(0).isDisplayGridlines());
        assertEquals(false, workbook.getSheetAt(0).isDisplayRowColHeadings());
    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

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

    InputStream inputStream = runAndRenderReportDefaultTask("MultiSheets1.rptdesign", "xlsx");
    assertNotNull(inputStream);//  w  w  w. j  a va 2s.c  om
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());
        assertEquals("Number Formats Test Report", workbook.getSheetAt(0).getSheetName());

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

---

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

License:Open Source License

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

    InputStream inputStream = runAndRenderReportCustomTask("MultiSheets1.rptdesign", "xlsx");
    assertNotNull(inputStream);/*ww w. j a va 2  s  . c  o m*/
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());
        assertEquals("Number Formats Test Report", workbook.getSheetAt(0).getSheetName());

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

---

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

License:Open Source License

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

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

        assertEquals(1, workbook.getNumberOfSheets());
        assertEquals("Multiple Sheets - Break in sub-", workbook.getSheetAt(0).getSheetName());

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

---

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

License:Open Source License

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

    InputStream inputStream = runAndRenderReportCustomTask("MultiSheetsNoNames.rptdesign", "xlsx");
    assertNotNull(inputStream);//from  ww  w .j a va  2s.  co m
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());
        assertEquals("Number Formats Test Report", workbook.getSheetAt(0).getSheetName());

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

---

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