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

License:Open Source License

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

    debug = false;//from ww  w  . ja  va 2  s  .  c  om
    InputStream inputStream = runAndRenderReport("Hyperlinks.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("_BK" + (i + 1000), sheet.getRow(i).getCell(1).getHyperlink().getAddress());
        }

    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

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

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

        assertEquals(1, workbook.getNumberOfSheets());

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

        assertEquals("FF206090",
                ((XSSFColor) sheet.getRow(1).getCell(0).getCellStyle().getFillForegroundColorColor())
                        .getARGBHex());
        assertEquals("FF206090",
                ((XSSFColor) sheet.getRow(1).getCell(1).getCellStyle().getFillForegroundColorColor())
                        .getARGBHex());
        assertEquals("FF206090",
                ((XSSFColor) sheet.getRow(1).getCell(2).getCellStyle().getFillForegroundColorColor())
                        .getARGBHex());
        assertEquals("FF206090",
                ((XSSFColor) sheet.getRow(1).getCell(3).getCellStyle().getFillForegroundColorColor())
                        .getARGBHex());

        assertEquals("FF6495ED",
                ((XSSFColor) sheet.getRow(2).getCell(0).getCellStyle().getFillForegroundColorColor())
                        .getARGBHex());
        assertEquals("FF6495ED",
                ((XSSFColor) sheet.getRow(2).getCell(1).getCellStyle().getFillForegroundColorColor())
                        .getARGBHex());
        assertEquals("FF6495ED",
                ((XSSFColor) sheet.getRow(2).getCell(2).getCellStyle().getFillForegroundColorColor())
                        .getARGBHex());
        assertEquals("FF6495ED",
                ((XSSFColor) sheet.getRow(2).getCell(3).getCellStyle().getFillForegroundColorColor())
                        .getARGBHex());

        assertEquals("Customer", sheet.getRow(1).getCell(0).getStringCellValue());
        assertEquals("Given Name", sheet.getRow(1).getCell(1).getStringCellValue());
        assertEquals("Family Name", sheet.getRow(1).getCell(2).getStringCellValue());
        assertEquals("Phone", sheet.getRow(1).getCell(3).getStringCellValue());

    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

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

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

        assertEquals(1, workbook.getNumberOfSheets());

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

        assertEquals("Hello\n\nMatey", sheet.getRow(1).getCell(0).getStringCellValue());
        assertEquals(41.3, sheet.getRow(1).getHeightInPoints(), 0.01);
        assertEquals(55.1, sheet.getRow(2).getHeightInPoints(), 0.01);

    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

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

    debug = false;/*w ww .j ava 2 s .c  o m*/
    InputStream inputStream = runAndRenderReport("Issue29.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));

        for (int i = 0; i < 4; ++i) {
            for (Cell cell : sheet.getRow(i)) {
                assertEquals(0, cell.getCellStyle().getBorderTop());
                assertEquals(0, cell.getCellStyle().getBorderLeft());
                assertEquals(0, cell.getCellStyle().getBorderRight());
                assertEquals(0, cell.getCellStyle().getBorderBottom());
            }
        }
        assertEquals("Bibble", sheet.getRow(5).getCell(0).getStringCellValue());
        assertEquals(24.0, sheet.getRow(0).getHeightInPoints(), 0.1);

    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

@Test
public void testWithoutOption() throws Exception {

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

        assertEquals(3, workbook.getNumberOfSheets());

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

    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

@Test
public void testWithOption() throws Exception {

    debug = false;// w ww  .j  av  a2  s. com
    structuredHeader = true;
    InputStream inputStream = runAndRenderReport("StructuredHeader.rptdesign", "xlsx");
    structuredHeader = false;
    assertNotNull(inputStream);
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(3, workbook.getNumberOfSheets());

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

    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

@Test
public void testWithUserProperty() throws Exception {

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

        assertEquals(3, workbook.getNumberOfSheets());

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

    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

@Test
public void testWithoutOption() throws Exception {

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

        assertEquals(1, workbook.getNumberOfSheets());

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

---

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

License:Open Source License

@Test
public void testWithOption() throws Exception {

    debug = false;/*w  ww.  java2 s  .  c  o  m*/
    removeEmptyRows = false;
    InputStream inputStream = runAndRenderReport("BlankRows.rptdesign", "xlsx");
    removeEmptyRows = true;
    assertNotNull(inputStream);
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());

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

---

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

License:Open Source License

@Test
public void testWithUserPropertyOnReport() throws Exception {

    debug = false;/*  ww  w  .ja v a  2s. c  om*/
    structuredHeader = false;
    InputStream inputStream = runAndRenderReport("BlankRowsDisabledAtReport.rptdesign", "xlsx");
    assertNotNull(inputStream);
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());

        assertEquals(12, this.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
• »