sheet.setFitToPage(true); PrintSetup ps = sheet.getPrintSetup(); ps.setFitWidth( (short) 1); ps.setFitHeight( (short) 0);
@Override public SheetContext fitOnPagesByWidth(int pages) { PrintSetup printSetup = sheet.getPrintSetup(); sheet.setAutobreaks(true); printSetup.setFitWidth((short) pages); return this; }
Workbook wb = new HSSFWorkbook(); Sheet sheet = wb.createSheet("format sheet"); PrintSetup ps = sheet.getPrintSetup(); sheet.setAutobreaks(true); ps.setFitHeight((short)1); ps.setFitWidth((short)1);
public static void main(String[]args) throws IOException { try (Workbook wb = new XSSFWorkbook()) { //or new HSSFWorkbook(); Sheet sheet = wb.createSheet("format sheet"); PrintSetup ps = sheet.getPrintSetup(); sheet.setAutobreaks(true); ps.setFitHeight((short) 1); ps.setFitWidth((short) 1); // Create various cells and rows for spreadsheet. try (FileOutputStream fileOut = new FileOutputStream("fitSheetToOnePage.xlsx")) { wb.write(fileOut); } } } }
ps.setFitWidth((short) 1);
printSetup.setFitWidth((short) 1);
printSetup.setFitWidth((short)1);
sheet.getPrintSetup().setLandscape(true); sheet.setAutobreaks(true); sheet.getPrintSetup().setFitWidth((short) 1); sheet.getPrintSetup().setFitHeight((short) 1);
public static void copyPrintSetup(Sheet destSheet, Sheet srcSheet) { PrintSetup setup = srcSheet.getPrintSetup(); if (setup != null) { destSheet.getPrintSetup().setLandscape(setup.getLandscape()); destSheet.getPrintSetup().setPaperSize(setup.getPaperSize()); destSheet.getPrintSetup().setScale(setup.getScale()); destSheet.getPrintSetup().setFitWidth(setup.getFitWidth()); destSheet.getPrintSetup().setFitHeight(setup.getFitHeight()); destSheet.getPrintSetup().setFooterMargin(setup.getFooterMargin()); destSheet.getPrintSetup().setHeaderMargin(setup.getHeaderMargin()); destSheet.getPrintSetup().setPaperSize(setup.getPaperSize()); destSheet.getPrintSetup().setPageStart(setup.getPageStart()); } }
public static void copyPrintSetup(Sheet destSheet, Sheet srcSheet) { PrintSetup setup = srcSheet.getPrintSetup(); if (setup != null) { destSheet.getPrintSetup().setLandscape(setup.getLandscape()); destSheet.getPrintSetup().setPaperSize(setup.getPaperSize()); destSheet.getPrintSetup().setScale(setup.getScale()); destSheet.getPrintSetup().setFitWidth(setup.getFitWidth()); destSheet.getPrintSetup().setFitHeight(setup.getFitHeight()); destSheet.getPrintSetup().setFooterMargin(setup.getFooterMargin()); destSheet.getPrintSetup().setHeaderMargin(setup.getHeaderMargin()); destSheet.getPrintSetup().setPaperSize(setup.getPaperSize()); destSheet.getPrintSetup().setPageStart(setup.getPageStart()); } }
private static void copyPrintSetup(Sheet src, Sheet dest) { PrintSetup srcPrintSetup = src.getPrintSetup(); PrintSetup destPrintSetup = dest.getPrintSetup(); destPrintSetup.setCopies(srcPrintSetup.getCopies()); destPrintSetup.setDraft(srcPrintSetup.getDraft()); destPrintSetup.setFitHeight(srcPrintSetup.getFitHeight()); destPrintSetup.setFitWidth(srcPrintSetup.getFitWidth()); destPrintSetup.setFooterMargin(srcPrintSetup.getFooterMargin()); destPrintSetup.setHeaderMargin(srcPrintSetup.getHeaderMargin()); destPrintSetup.setHResolution(srcPrintSetup.getHResolution()); destPrintSetup.setLandscape(srcPrintSetup.getLandscape()); destPrintSetup.setLeftToRight(srcPrintSetup.getLeftToRight()); destPrintSetup.setNoColor(srcPrintSetup.getNoColor()); destPrintSetup.setNoOrientation(srcPrintSetup.getNoOrientation()); destPrintSetup.setNotes(srcPrintSetup.getNotes()); destPrintSetup.setPageStart(srcPrintSetup.getPageStart()); destPrintSetup.setPaperSize(srcPrintSetup.getPaperSize()); destPrintSetup.setScale(srcPrintSetup.getScale()); destPrintSetup.setUsePage(srcPrintSetup.getUsePage()); destPrintSetup.setValidSettings(srcPrintSetup.getValidSettings()); destPrintSetup.setVResolution( srcPrintSetup.getVResolution() ); }