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

License:Open Source License

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

    debug = true;//from w ww. j a  v  a 2 s .  co  m
    InputStream inputStream = runAndRenderReportAsOne("MultiSheets1.rptdesign", "xlsx");
    assertNotNull(inputStream);
    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( "3", workbook.getSheetAt(0).getHeader().getRight() );

        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());
    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

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

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

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

        assertEquals("3", workbook.getSheetAt(0).getHeader().getRight());

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

---

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

License:Open Source License

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

    InputStream inputStream = runAndRenderReportCustomTask("MultiSheets1.rptdesign", "xlsx");
    assertNotNull(inputStream);/*from w w  w . jav  a  2  s  .c om*/
    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("3", workbook.getSheetAt(0).getHeader().getRight());

        assertEquals(4, firstNullRow(workbook.getSheetAt(0)));
        assertEquals(4, firstNullRow(workbook.getSheetAt(1)));
        assertEquals(3, firstNullRow(workbook.getSheetAt(2)));
    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

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

    debug = false;/*  w  w w .  j av a 2s  .  c o m*/
    InputStream inputStream = runAndRenderReportCustomTask("MultiSheetsBreakInSubTable.rptdesign", "xlsx");
    assertNotNull(inputStream);
    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)));

    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

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

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

        assertEquals(3, workbook.getNumberOfSheets());
        assertEquals("Sheet0", workbook.getSheetAt(0).getSheetName());
        assertEquals("Sheet1", workbook.getSheetAt(1).getSheetName());
        assertEquals("Sheet2", workbook.getSheetAt(2).getSheetName());

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

    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

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

    InputStream inputStream = runAndRenderReportCustomTask("MultiSheetsTwoNames.rptdesign", "xlsx");
    assertNotNull(inputStream);/* w ww .j  a  v a  2  s .c  om*/
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

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

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

    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

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

    InputStream inputStream = runAndRenderReportCustomTask("MultiSheetsBigTableFortyInterval.rptdesign",
            "xlsx");
    assertNotNull(inputStream);//www  .jav  a  2s . c  o  m
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

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

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

    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

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

    InputStream inputStream = runAndRenderReportCustomTask("MultiSheetsBigTableZeroInterval.rptdesign", "xlsx");
    assertNotNull(inputStream);/*from   w ww .  java 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(192, firstNullRow(workbook.getSheetAt(0)));

    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

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

    htmlPagination = true;//  w  w  w .ja  va  2 s  .c  o m
    debug = true;
    InputStream inputStream = runAndRenderReportCustomTask("MultiSheetsBigTableZeroInterval.rptdesign", "xlsx");
    assertNotNull(inputStream);
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

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

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

    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

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

    InputStream inputStream = runAndRenderReport("NestedTables2.rptdesign", "xlsx");
    assertNotNull(inputStream);/*  w w  w.  ja v  a 2 s.c  o m*/
    try {

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

        assertEquals(1, workbook.getNumberOfSheets());
        assertEquals("Nested Tables Test Report", workbook.getSheetAt(0).getSheetName());

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

        assertEquals(1, sheet.getRow(0).getCell(0).getNumericCellValue(), 0.0);
        assertEquals(1, sheet.getRow(0).getCell(1).getNumericCellValue(), 0.0);
        assertEquals(2, sheet.getRow(1).getCell(0).getNumericCellValue(), 0.0);
        assertEquals(2, sheet.getRow(1).getCell(1).getNumericCellValue(), 0.0);
        assertEquals(3, sheet.getRow(2).getCell(0).getNumericCellValue(), 0.0);
        assertEquals(3, sheet.getRow(2).getCell(1).getNumericCellValue(), 0.0);
        assertEquals(1, sheet.getRow(3).getCell(0).getNumericCellValue(), 0.0);
        assertEquals(2, sheet.getRow(3).getCell(1).getNumericCellValue(), 0.0);
        assertEquals(3, sheet.getRow(3).getCell(2).getNumericCellValue(), 0.0);

        assertEquals(2, sheet.getRow(4).getCell(0).getNumericCellValue(), 0.0);
        assertEquals(2, sheet.getRow(4).getCell(1).getNumericCellValue(), 0.0);
        assertEquals(4, sheet.getRow(5).getCell(0).getNumericCellValue(), 0.0);
        assertEquals(4, sheet.getRow(5).getCell(1).getNumericCellValue(), 0.0);
        assertEquals(6, sheet.getRow(6).getCell(0).getNumericCellValue(), 0.0);
        assertEquals(6, sheet.getRow(6).getCell(1).getNumericCellValue(), 0.0);
        assertEquals(2, sheet.getRow(7).getCell(0).getNumericCellValue(), 0.0);
        assertEquals(4, sheet.getRow(7).getCell(1).getNumericCellValue(), 0.0);
        assertEquals(6, sheet.getRow(7).getCell(2).getNumericCellValue(), 0.0);

        assertEquals(3, sheet.getRow(8).getCell(0).getNumericCellValue(), 0.0);
        assertEquals(3, sheet.getRow(8).getCell(1).getNumericCellValue(), 0.0);
        assertEquals(6, sheet.getRow(9).getCell(0).getNumericCellValue(), 0.0);
        assertEquals(6, sheet.getRow(9).getCell(1).getNumericCellValue(), 0.0);
        assertEquals(9, sheet.getRow(10).getCell(0).getNumericCellValue(), 0.0);
        assertEquals(9, sheet.getRow(10).getCell(1).getNumericCellValue(), 0.0);
        assertEquals(3, sheet.getRow(11).getCell(0).getNumericCellValue(), 0.0);
        assertEquals(6, sheet.getRow(11).getCell(1).getNumericCellValue(), 0.0);
        assertEquals(9, sheet.getRow(11).getCell(2).getNumericCellValue(), 0.0);

        XSSFColor bgColour = ((XSSFCell) sheet.getRow(0).getCell(0)).getCellStyle()
                .getFillForegroundColorColor();
        assertEquals("FF800000", bgColour.getARGBHex());
        XSSFColor baseColour = ((XSSFCell) sheet.getRow(0).getCell(0)).getCellStyle().getFont().getXSSFColor();
        assertEquals("FF000000", baseColour.getARGBHex());
    } finally {
        inputStream.close();
    }
}

---

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