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

License:Open Source License

@Test
public void testNestedTables3() throws Exception {

    // debug = true;
    removeEmptyRows = false;// w  ww. j  a  va  2  s  .  c o m
    InputStream inputStream = runAndRenderReport("NestedTables3.rptdesign", "xlsx");
    assertNotNull(inputStream);
    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(13, firstNullRow(sheet));

        assertEquals("Header", sheet.getRow(0).getCell(0).getStringCellValue());
        assertEquals("First Column", sheet.getRow(1).getCell(0).getStringCellValue());
        assertEquals("Wibble", sheet.getRow(1).getCell(3).getStringCellValue());
        assertEquals(1.0, sheet.getRow(1).getCell(1).getNumericCellValue(), 0.0);
        assertEquals(2.0, sheet.getRow(2).getCell(1).getNumericCellValue(), 0.0);
        assertEquals(3.0, sheet.getRow(3).getCell(1).getNumericCellValue(), 0.0);
        assertEquals("First Column", sheet.getRow(5).getCell(0).getStringCellValue());
        assertEquals("Wibble", sheet.getRow(5).getCell(3).getStringCellValue());
        assertEquals(2.0, sheet.getRow(5).getCell(1).getNumericCellValue(), 0.0);
        assertEquals(4.0, sheet.getRow(6).getCell(1).getNumericCellValue(), 0.0);
        assertEquals(6.0, sheet.getRow(7).getCell(1).getNumericCellValue(), 0.0);
    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

@Test
public void testNestedTables4() throws Exception {

    // debug = true;
    removeEmptyRows = false;//from w ww  . j a  v  a2  s .  c  o  m
    InputStream inputStream = runAndRenderReport("NestedTables4.rptdesign", "xlsx");
    assertNotNull(inputStream);
    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(13, firstNullRow(sheet));

        assertEquals("Header", sheet.getRow(0).getCell(0).getStringCellValue());
        assertEquals("First Column", sheet.getRow(1).getCell(0).getStringCellValue());
        assertEquals("Wibble", sheet.getRow(1).getCell(3).getStringCellValue());
        assertEquals("Wobble", sheet.getRow(1).getCell(5).getStringCellValue());
        assertEquals(1.0, sheet.getRow(1).getCell(1).getNumericCellValue(), 0.0);
        assertEquals(2.0, sheet.getRow(2).getCell(1).getNumericCellValue(), 0.0);
        assertEquals(3.0, sheet.getRow(3).getCell(1).getNumericCellValue(), 0.0);
        assertEquals("First Column", sheet.getRow(5).getCell(0).getStringCellValue());
        assertEquals("Wibble", sheet.getRow(5).getCell(3).getStringCellValue());
        assertEquals("Wobble", sheet.getRow(5).getCell(5).getStringCellValue());
        assertEquals(2.0, sheet.getRow(5).getCell(1).getNumericCellValue(), 0.0);
        assertEquals(4.0, sheet.getRow(6).getCell(1).getNumericCellValue(), 0.0);
        assertEquals(6.0, sheet.getRow(7).getCell(1).getNumericCellValue(), 0.0);
    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

@Test
public void testNestedTables5() throws Exception {

    debug = false;//from  w  w w .  j  ava  2s. c  o  m
    removeEmptyRows = false;
    InputStream inputStream = runAndRenderReport("NestedTables5.rptdesign", "xlsx");
    assertNotNull(inputStream);
    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(18, firstNullRow(sheet));

        assertEquals(1.0, sheet.getRow(0).getCell(0).getNumericCellValue(), 0.0);
        assertEquals(2.0, sheet.getRow(1).getCell(0).getNumericCellValue(), 0.0);
        assertEquals(3.0, sheet.getRow(2).getCell(0).getNumericCellValue(), 0.0);
        assertEquals(1.0, sheet.getRow(5).getCell(0).getNumericCellValue(), 0.0);
        assertEquals(2.0, sheet.getRow(5).getCell(1).getNumericCellValue(), 0.0);
        assertEquals(3.0, sheet.getRow(5).getCell(2).getNumericCellValue(), 0.0);
        assertEquals("Row1", sheet.getRow(0).getCell(2).getStringCellValue());
        assertEquals("Row2", sheet.getRow(1).getCell(2).getStringCellValue());
        assertEquals("Row3", sheet.getRow(2).getCell(2).getStringCellValue());
        assertEquals("Row4", sheet.getRow(3).getCell(2).getStringCellValue());
        assertEquals("Row5", sheet.getRow(4).getCell(2).getStringCellValue());
        assertEquals("Solo", sheet.getRow(0).getCell(3).getStringCellValue());

        assertEquals(2.0, sheet.getRow(6).getCell(0).getNumericCellValue(), 0.0);
        assertEquals(4.0, sheet.getRow(7).getCell(0).getNumericCellValue(), 0.0);
        assertEquals(6.0, sheet.getRow(8).getCell(0).getNumericCellValue(), 0.0);
        assertEquals(2.0, sheet.getRow(11).getCell(0).getNumericCellValue(), 0.0);
        assertEquals(4.0, sheet.getRow(11).getCell(1).getNumericCellValue(), 0.0);
        assertEquals(6.0, sheet.getRow(11).getCell(2).getNumericCellValue(), 0.0);
        assertEquals("Row1", sheet.getRow(6).getCell(2).getStringCellValue());
        assertEquals("Row2", sheet.getRow(7).getCell(2).getStringCellValue());
        assertEquals("Row3", sheet.getRow(8).getCell(2).getStringCellValue());
        assertEquals("Row4", sheet.getRow(9).getCell(2).getStringCellValue());
        assertEquals("Row5", sheet.getRow(10).getCell(2).getStringCellValue());
        assertEquals("Solo", sheet.getRow(6).getCell(3).getStringCellValue());

    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

@Test
public void testNestedTables6() throws Exception {

    // debug = true;
    removeEmptyRows = false;/*w  w  w .  j  a  v a 2s  . co  m*/
    InputStream inputStream = runAndRenderReport("NestedTables6.rptdesign", "xlsx");
    assertNotNull(inputStream);
    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(13, firstNullRow(sheet));

        assertEquals("Header", sheet.getRow(0).getCell(0).getStringCellValue());
        assertEquals("H2", sheet.getRow(0).getCell(1).getStringCellValue());
        assertEquals("H3", sheet.getRow(0).getCell(2).getStringCellValue());
        assertEquals("H4", sheet.getRow(0).getCell(3).getStringCellValue());
        assertEquals("H5", sheet.getRow(0).getCell(4).getStringCellValue());
        assertEquals("H6", sheet.getRow(0).getCell(5).getStringCellValue());
        assertEquals("H7", sheet.getRow(0).getCell(6).getStringCellValue());

        assertEquals("First Column", sheet.getRow(1).getCell(0).getStringCellValue());
        assertEquals(1.0, sheet.getRow(1).getCell(1).getNumericCellValue(), 0.0);
        assertEquals("Header", sheet.getRow(1).getCell(3).getStringCellValue());
        assertEquals(2.0, sheet.getRow(2).getCell(1).getNumericCellValue(), 0.0);
        assertEquals("Wibble", sheet.getRow(2).getCell(3).getStringCellValue());
        assertEquals("Wobble", sheet.getRow(2).getCell(5).getStringCellValue());
        assertEquals(3.0, sheet.getRow(3).getCell(1).getNumericCellValue(), 0.0);
        assertEquals(1.0, sheet.getRow(4).getCell(1).getNumericCellValue(), 0.0);
        assertEquals(2.0, sheet.getRow(4).getCell(2).getNumericCellValue(), 0.0);
        assertEquals(3.0, sheet.getRow(4).getCell(3).getNumericCellValue(), 0.0);
        assertEquals(3.0, sheet.getRow(4).getCell(4).getNumericCellValue(), 0.0);
        assertEquals(3.0, sheet.getRow(4).getCell(5).getNumericCellValue(), 0.0);
        assertEquals(3.0, sheet.getRow(4).getCell(6).getNumericCellValue(), 0.0);

        assertEquals("First Column", sheet.getRow(5).getCell(0).getStringCellValue());
        assertEquals(2.0, sheet.getRow(5).getCell(1).getNumericCellValue(), 0.0);
        assertEquals("Header", sheet.getRow(5).getCell(3).getStringCellValue());
        assertEquals(4.0, sheet.getRow(6).getCell(1).getNumericCellValue(), 0.0);
        assertEquals("Wibble", sheet.getRow(6).getCell(3).getStringCellValue());
        assertEquals("Wobble", sheet.getRow(6).getCell(5).getStringCellValue());
        assertEquals(6.0, sheet.getRow(7).getCell(1).getNumericCellValue(), 0.0);
        assertEquals(2.0, sheet.getRow(8).getCell(1).getNumericCellValue(), 0.0);
        assertEquals(4.0, sheet.getRow(8).getCell(2).getNumericCellValue(), 0.0);
        assertEquals(6.0, sheet.getRow(8).getCell(3).getNumericCellValue(), 0.0);
        assertEquals(6.0, sheet.getRow(8).getCell(4).getNumericCellValue(), 0.0);
        assertEquals(6.0, sheet.getRow(8).getCell(5).getNumericCellValue(), 0.0);
        assertEquals(6.0, sheet.getRow(8).getCell(6).getNumericCellValue(), 0.0);

    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

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

    InputStream inputStream = runAndRenderReport("NestedTables.rptdesign", "xlsx");
    assertNotNull(inputStream);/*from  ww w. j  a  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(1, firstNullRow(sheet));

        assertEquals("One Two Three\n1 2 3\n2 4 6\n3 6 9", sheet.getRow(0).getCell(0).getStringCellValue());
        assertEquals("One Two Three\n1 2 3\n2 4 6\n3 6 9", sheet.getRow(0).getCell(1).getStringCellValue());
    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

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

    debug = false;/*from   w  ww. j a  v  a  2  s .  co m*/
    InputStream inputStream = runAndRenderReport("NestedTablesSingleColumnGrid.rptdesign", "xlsx");
    assertNotNull(inputStream);
    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(10, firstNullRow(sheet));
    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

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

    debug = false;/*from  w w  w  .  jav a  2 s . c  om*/
    InputStream inputStream = runAndRenderReport("NumberFormats.rptdesign", "xlsx");
    assertNotNull(inputStream);
    try {

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

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

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

        assertEquals(3035, sheet.getColumnWidth(0));
        assertEquals(3913, sheet.getColumnWidth(1));
        assertEquals(7021, sheet.getColumnWidth(2));
        assertEquals(4205, sheet.getColumnWidth(3));
        assertEquals(3474, sheet.getColumnWidth(4));
        assertEquals(2852, sheet.getColumnWidth(5));
        assertEquals(3510, sheet.getColumnWidth(6));
        assertEquals(2889, sheet.getColumnWidth(7));
        assertEquals(2048, sheet.getColumnWidth(8));

        DataFormatter formatter = new DataFormatter();
        Locale locale = Locale.getDefault();

        assertEquals("1", formatter.formatCellValue(sheet.getRow(1).getCell(1)));
        assertEquals("2019-10-11 13:18:46", formatter.formatCellValue(sheet.getRow(1).getCell(2)));
        assertEquals("3.1415926536", formatter.formatCellValue(sheet.getRow(1).getCell(3)));
        assertEquals("3.1415926536", formatter.formatCellValue(sheet.getRow(1).getCell(4)));
        assertEquals("false", formatter.formatCellValue(sheet.getRow(1).getCell(5)));
        if (locale.getDisplayName().equals("en-US")) {
            assertEquals("Oct 11, 2019", formatter.formatCellValue(sheet.getRow(1).getCell(6)));
            assertEquals("1:18:46 PM", formatter.formatCellValue(sheet.getRow(1).getCell(7)));
        } else if (locale.getDisplayName().equals("en-GB")) {
            assertEquals("11-Oct-2019", formatter.formatCellValue(sheet.getRow(1).getCell(6)));
            assertEquals("13:18:46", formatter.formatCellValue(sheet.getRow(1).getCell(7)));
        }

        assertEquals("2", formatter.formatCellValue(sheet.getRow(2).getCell(1)));
        assertEquals("2019-10-11 13:18:46", formatter.formatCellValue(sheet.getRow(2).getCell(2)));
        assertEquals("6.2831853072", formatter.formatCellValue(sheet.getRow(2).getCell(3)));
        assertEquals("6.2831853072", formatter.formatCellValue(sheet.getRow(2).getCell(4)));
        assertEquals("true", formatter.formatCellValue(sheet.getRow(2).getCell(5)));
        if (locale.getDisplayName().equals("en-US")) {
            assertEquals("Oct 11, 2019", formatter.formatCellValue(sheet.getRow(1).getCell(6)));
            assertEquals("1:18:46 PM", formatter.formatCellValue(sheet.getRow(1).getCell(7)));
        } else if (locale.getDisplayName().equals("en-GB")) {
            assertEquals("11-Oct-2019", formatter.formatCellValue(sheet.getRow(1).getCell(6)));
            assertEquals("13:18:46", formatter.formatCellValue(sheet.getRow(1).getCell(7)));
        }

        assertEquals("3.1415926536", formatter.formatCellValue(sheet.getRow(5).getCell(1)));
        assertEquals("3.1415926536", formatter.formatCellValue(sheet.getRow(5).getCell(2)));
        assertEquals("3.14", formatter.formatCellValue(sheet.getRow(5).getCell(3)));
        assertEquals("3.14", formatter.formatCellValue(sheet.getRow(5).getCell(4)));
        assertEquals("314.16%", formatter.formatCellValue(sheet.getRow(5).getCell(5)));
        assertEquals("3.14E00", formatter.formatCellValue(sheet.getRow(5).getCell(6)));
        assertEquals("3.14E00", formatter.formatCellValue(sheet.getRow(5).getCell(7)));

        assertEquals("6.2831853072", formatter.formatCellValue(sheet.getRow(6).getCell(1)));
        assertEquals("6.2831853072", formatter.formatCellValue(sheet.getRow(6).getCell(2)));
        assertEquals("6.28", formatter.formatCellValue(sheet.getRow(6).getCell(3)));
        assertEquals("6.28", formatter.formatCellValue(sheet.getRow(6).getCell(4)));
        assertEquals("628.32%", formatter.formatCellValue(sheet.getRow(6).getCell(5)));
        assertEquals("6.28E00", formatter.formatCellValue(sheet.getRow(6).getCell(6)));
        assertEquals("6.28E00", formatter.formatCellValue(sheet.getRow(6).getCell(7)));

        assertEquals("1", formatter.formatCellValue(sheet.getRow(9).getCell(1)));
        if (locale.getDisplayName().equals("en-US")) {
            assertEquals("October 11, 2019 1:18:46 PM", formatter.formatCellValue(sheet.getRow(9).getCell(2)));
        } else if (locale.getDisplayName().equals("en-GB")) {
            assertEquals("11 October 2019 13:18:46", formatter.formatCellValue(sheet.getRow(9).getCell(2)));
        }
        assertEquals("3.1415926536", formatter.formatCellValue(sheet.getRow(9).getCell(3)));
        assertEquals("3.1415926536", formatter.formatCellValue(sheet.getRow(9).getCell(4)));
        assertEquals("false", formatter.formatCellValue(sheet.getRow(9).getCell(5)));
        if (locale.getDisplayName().equals("en-US")) {
            assertEquals("10/11/19", formatter.formatCellValue(sheet.getRow(9).getCell(6)));
        } else if (locale.getDisplayName().equals("en-GB")) {
            assertEquals("11/10/19", formatter.formatCellValue(sheet.getRow(9).getCell(6)));
        }
        assertEquals("13:18", formatter.formatCellValue(sheet.getRow(9).getCell(7)));

        assertEquals("2", formatter.formatCellValue(sheet.getRow(10).getCell(1)));
        if (locale.getDisplayName().equals("en-US")) {
            assertEquals("October 11, 2019 1:18:46 PM", formatter.formatCellValue(sheet.getRow(9).getCell(2)));
        } else if (locale.getDisplayName().equals("en-GB")) {
            assertEquals("11 October 2019 13:18:46", formatter.formatCellValue(sheet.getRow(9).getCell(2)));
        }
        assertEquals("6.2831853072", formatter.formatCellValue(sheet.getRow(10).getCell(3)));
        assertEquals("6.2831853072", formatter.formatCellValue(sheet.getRow(10).getCell(4)));
        assertEquals("true", formatter.formatCellValue(sheet.getRow(10).getCell(5)));
        if (locale.getDisplayName().equals("en-US")) {
            assertEquals("10/11/19", formatter.formatCellValue(sheet.getRow(9).getCell(6)));
        } else if (locale.getDisplayName().equals("en-GB")) {
            assertEquals("11/10/19", formatter.formatCellValue(sheet.getRow(9).getCell(6)));
        }
        assertEquals("13:18", formatter.formatCellValue(sheet.getRow(10).getCell(7)));

        assertEquals("MSRP $3.14", formatter.formatCellValue(sheet.getRow(15).getCell(1)));

        assertEquals("_-* #,##0.00_-;-* #,##0.00_-;_-* \"-\"??_-;_-@_-",
                sheet.getRow(19).getCell(1).getCellStyle().getDataFormatString());
        assertEquals(sheet.getRow(18).getCell(2).getStringCellValue(),
                sheet.getRow(19).getCell(2).getCellStyle().getDataFormatString());
        assertEquals(sheet.getRow(18).getCell(3).getStringCellValue(),
                sheet.getRow(19).getCell(3).getCellStyle().getDataFormatString());
        assertEquals(sheet.getRow(18).getCell(4).getStringCellValue(),
                sheet.getRow(19).getCell(4).getCellStyle().getDataFormatString());
        assertEquals(sheet.getRow(18).getCell(5).getStringCellValue(),
                sheet.getRow(19).getCell(5).getCellStyle().getDataFormatString());
        assertEquals(sheet.getRow(18).getCell(6).getStringCellValue(),
                sheet.getRow(19).getCell(6).getCellStyle().getDataFormatString());
        assertEquals(sheet.getRow(18).getCell(7).getStringCellValue(),
                sheet.getRow(19).getCell(7).getCellStyle().getDataFormatString());

    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

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

    InputStream inputStream = runAndRenderReportFileNotStream("NumberFormats.rptdesign", "xlsx");
    assertNotNull(inputStream);/*from  ww w .j  av  a 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());

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

}

---

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

License:Open Source License

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

    InputStream inputStream = runAndRenderReport("PageLayout.rptdesign", "xlsx");
    assertNotNull(inputStream);/*w  w  w  .j  a v a 2 s . com*/
    try {

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

        assertEquals(1, workbook.getNumberOfSheets());
        assertEquals("Page Layout Test", workbook.getSheetAt(0).getSheetName());

        XSSFSheet sheet0 = workbook.getSheetAt(0);
        XSSFPrintSetup printSetup = sheet0.getPrintSetup();
        assertEquals(PaperSize.A4_PAPER, printSetup.getPaperSizeEnum());
        assertEquals(PrintOrientation.LANDSCAPE, printSetup.getOrientation());
        assertEquals(1.0 / 2.54, printSetup.getHeaderMargin(), 0.01);
        assertEquals(1.0 / 2.54, printSetup.getFooterMargin(), 0.01);
        assertEquals(0.7 / 2.54, sheet0.getMargin(Sheet.LeftMargin), 0.01);
        assertEquals(0.7 / 2.54, sheet0.getMargin(Sheet.RightMargin), 0.01);
        assertEquals(1.7 / 2.54, sheet0.getMargin(Sheet.TopMargin), 0.01);
        assertEquals(1.7 / 2.54, sheet0.getMargin(Sheet.BottomMargin), 0.01);

    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

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

    InputStream inputStream = runAndRenderReport("PageLayoutPixels.rptdesign", "xlsx");
    assertNotNull(inputStream);//from w ww. ja  v  a 2 s  .  c om
    try {

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

        assertEquals(1, workbook.getNumberOfSheets());
        assertEquals("Page Layout Test", workbook.getSheetAt(0).getSheetName());

        XSSFSheet sheet0 = workbook.getSheetAt(0);
        XSSFPrintSetup printSetup = sheet0.getPrintSetup();
        assertEquals(PaperSize.A4_PAPER, printSetup.getPaperSizeEnum());
        assertEquals(PrintOrientation.LANDSCAPE, printSetup.getOrientation());
        assertEquals(0.3, printSetup.getHeaderMargin(), 0.01);
        assertEquals(0.3, printSetup.getFooterMargin(), 0.01);
        assertEquals(0.7, sheet0.getMargin(Sheet.LeftMargin), 0.01);
        assertEquals(0.7, sheet0.getMargin(Sheet.RightMargin), 0.01);
        assertEquals(0.75, sheet0.getMargin(Sheet.TopMargin), 0.01);
        assertEquals(0.75, sheet0.getMargin(Sheet.BottomMargin), 0.01);

    } finally {
        inputStream.close();
    }
}

---

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