List of usage examples for org.apache.poi.ss.usermodel PaperSize A4_PAPER
PaperSize A4_PAPER
To view the source code for org.apache.poi.ss.usermodel PaperSize A4_PAPER.
Click Source Link
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 . ja v a 2 s.c o m 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. java 2 s.co m*/ 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(); } }