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

License:Open Source License

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

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

        assertEquals(327, workbook.getNumberOfSheets());

        Sheet firstSheet = workbook.getSheetAt(0);
        assertEquals(7, this.firstNullRow(firstSheet));

        assertEquals("10100", firstSheet.getSheetName());

        for (Sheet sheet : workbook) {
            if (!"Sheet326".equals(sheet.getSheetName())) {
                assertEquals(Integer.toString((int) sheet.getRow(1).getCell(0).getNumericCellValue()),
                        sheet.getSheetName());
            }
        }

    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

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

    debug = false;/*from w  w  w .  j av  a2 s  .  c om*/
    removeEmptyRows = false;
    spannedRowHeight = null;
    InputStream inputStream = runAndRenderReport("Issue62RowSpanAutoHeight.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.Issue62RowSpanAutoHeight.java

License:Open Source License

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

    debug = false;/*from  w  w w. jav a 2 s.  com*/
    removeEmptyRows = false;
    spannedRowHeight = ExcelEmitter.SPANNED_ROW_HEIGHT_SPREAD;
    InputStream inputStream = runAndRenderReport("Issue62RowSpanAutoHeight.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.Issue62RowSpanAutoHeight.java

License:Open Source License

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

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

        assertTrue(sheet.getRow(0).getHeight() > sheet.getRow(1).getHeight());
        assertTrue(sheet.getRow(3).getHeight() > sheet.getRow(4).getHeight());
        assertTrue(sheet.getRow(6).getHeight() > sheet.getRow(7).getHeight());
        assertTrue(sheet.getRow(7).getHeight() > sheet.getRow(8).getHeight());

    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

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

    debug = false;/*w w w .j ava 2  s .com*/
    removeEmptyRows = false;
    spannedRowHeight = ExcelEmitter.SPANNED_ROW_HEIGHT_IGNORED;
    InputStream inputStream = runAndRenderReport("Issue62RowSpanAutoHeight.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(0).getHeight(), sheet.getRow(3).getHeight());
        assertEquals(sheet.getRow(0).getHeight(), sheet.getRow(4).getHeight());
        assertEquals(sheet.getRow(0).getHeight(), sheet.getRow(6).getHeight());
        assertEquals(sheet.getRow(0).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.Issue62RowSpanAutoHeight.java

License:Open Source License

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

    debug = false;/*www .  j  a  va 2 s  .  c o  m*/
    removeEmptyRows = false;
    spannedRowHeight = 3;
    InputStream inputStream = runAndRenderReport("Issue62RowSpanAutoHeight.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.Issue66SingleSheetWithPageBreaks.java

License:Open Source License

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

    singleSheetWithPagination = false;/*from w  w  w.  j  av a 2  s.c  om*/
    InputStream inputStream = runAndRenderReport("Issue66PageBreaking.rptdesign", "xlsx");
    assertNotNull(inputStream);
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());
        assertEquals(122, workbook.getSheetAt(0).getRowBreaks().length);

    } finally {
        inputStream.close();
    }
    inputStream.close();
    singleSheetWithPagination = true;
}

---

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

License:Open Source License

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

    InputStream inputStream = runAndRenderReportAsOne("MultiSheets1.rptdesign", "xlsx");
    assertNotNull(inputStream);/* w  ww .ja  va2  s.  c  om*/
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());
        assertEquals(2, workbook.getSheetAt(0).getRowBreaks().length);
        assertEquals(3, workbook.getSheetAt(0).getRowBreaks()[0]);
        assertEquals(7, workbook.getSheetAt(0).getRowBreaks()[1]);
        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.Issue66SingleSheetWithPageBreaks.java

License:Open Source License

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

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

        assertEquals(1, workbook.getNumberOfSheets());
        assertEquals(0, workbook.getSheetAt(0).getRowBreaks().length);
        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.Issue66SingleSheetWithPageBreaks.java

License:Open Source License

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

    InputStream inputStream = runAndRenderReportCustomTask("MultiSheets1.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(2, workbook.getSheetAt(0).getRowBreaks().length);
        assertEquals(3, workbook.getSheetAt(0).getRowBreaks()[0]);
        assertEquals(7, workbook.getSheetAt(0).getRowBreaks()[1]);
        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
• »