org.apache.poi.ss.usermodel.Sheet.getPrintSetup()方法的使用及代码示例

x33g5p2x  于2022-01-29 转载在 其他  
字(10.9k)|赞(0)|评价(0)|浏览(279)

本文整理了Java中org.apache.poi.ss.usermodel.Sheet.getPrintSetup()方法的一些代码示例，展示了Sheet.getPrintSetup()的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台，是从一些精选项目中提取出来的代码，具有较强的参考意义，能在一定程度帮忙到你。Sheet.getPrintSetup()方法的具体详情如下：
包路径：org.apache.poi.ss.usermodel.Sheet
类名称：Sheet
方法名：getPrintSetup

Sheet.getPrintSetup介绍

[英]Gets the print setup object.
[中]获取打印设置对象。

代码示例

代码示例来源：origin: primefaces/primefaces

protected void applyOptions(Workbook wb, DataTable table, Sheet sheet, ExporterOptions options) {
  facetStyle = wb.createCellStyle();
  facetStyle.setAlignment(HorizontalAlignment.CENTER);
  facetStyle.setVerticalAlignment(VerticalAlignment.CENTER);
  facetStyle.setWrapText(true);
  applyFacetOptions(wb, options, facetStyle);
  cellStyle = wb.createCellStyle();
  cellStyle.setAlignment(HorizontalAlignment.LEFT);
  applyCellOptions(wb, options, cellStyle);
  PrintSetup printSetup = sheet.getPrintSetup();
  printSetup.setLandscape(true);
  printSetup.setPaperSize(PrintSetup.A4_PAPERSIZE);
  sheet.setPrintGridlines(true);
}

代码示例来源：origin: micromata/projectforge

public PrintSetup getPrintSetup()
{
 return poiSheet.getPrintSetup();
}

代码示例来源：origin: stackoverflow.com

Sheet sheet = workbook.getSheetAt(0);
sheet.getPrintSetup().setPaperSize(PrintSetup.A4_PAPERSIZE);

代码示例来源：origin: youseries/ureport

protected Sheet createSheet(SXSSFWorkbook wb,Paper paper,String name){
  Sheet sheet = null;
  if(name==null){
    sheet=wb.createSheet();
  }else{			
    sheet=wb.createSheet(name);
  }
  PaperType paperType=paper.getPaperType();
  XSSFPrintSetup printSetup=(XSSFPrintSetup)sheet.getPrintSetup();
  Orientation orientation=paper.getOrientation();
  if(orientation.equals(Orientation.landscape)){
    printSetup.setOrientation(PrintOrientation.LANDSCAPE);            
  }
  setupPaper(paperType, printSetup);
  int leftMargin=paper.getLeftMargin();
  int rightMargin=paper.getRightMargin();
  int topMargin=paper.getTopMargin();
  int bottomMargin=paper.getBottomMargin();
  sheet.setMargin(Sheet.LeftMargin, UnitUtils.pointToInche(leftMargin));
  sheet.setMargin(Sheet.RightMargin, UnitUtils.pointToInche(rightMargin));
  sheet.setMargin(Sheet.TopMargin, UnitUtils.pointToInche(topMargin));
  sheet.setMargin(Sheet.BottomMargin, UnitUtils.pointToInche(bottomMargin));
  return sheet;
}

代码示例来源：origin: youseries/ureport

private Sheet createSheet(HSSFWorkbook wb,Paper paper,String name){
  Sheet sheet = null;
  if(name==null){
    sheet=wb.createSheet();
  }else{			
    sheet=wb.createSheet(name);
  }
  PaperType paperType=paper.getPaperType();
  HSSFPrintSetup printSetup=(HSSFPrintSetup)sheet.getPrintSetup();
  Orientation orientation=paper.getOrientation();
  if(orientation.equals(Orientation.landscape)){
    printSetup.setLandscape(true);
  }
  setupPaper(paperType, printSetup);
  int leftMargin=paper.getLeftMargin();
  int rightMargin=paper.getRightMargin();
  int topMargin=paper.getTopMargin();
  int bottomMargin=paper.getBottomMargin();
  sheet.setMargin(Sheet.LeftMargin, UnitUtils.pointToInche(leftMargin));
  sheet.setMargin(Sheet.RightMargin, UnitUtils.pointToInche(rightMargin));
  sheet.setMargin(Sheet.TopMargin, UnitUtils.pointToInche(topMargin));
  sheet.setMargin(Sheet.BottomMargin, UnitUtils.pointToInche(bottomMargin));
  return sheet;
}

代码示例来源：origin: net.sf.jxls/jxls-core

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());
  }
}

代码示例来源：origin: subtlelib/poi

@Override
public SheetContext fitOnPagesByWidth(int pages) {
  PrintSetup printSetup = sheet.getPrintSetup();
  sheet.setAutobreaks(true);
  printSetup.setFitWidth((short) pages);
  return this;
}

代码示例来源：origin: SheetJS/jxls

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());
  }
}

代码示例来源：origin: subtlelib/poi

@Override
public SheetContext fitOnPagesByHeight(int pages) {
  PrintSetup printSetup = sheet.getPrintSetup();
  sheet.setAutobreaks(true);
  printSetup.setFitHeight((short) pages);
  return this;
}

代码示例来源：origin: stackoverflow.com

String safeName = WorkbookUtil.createSafeSheetName("Datos");
Sheet sheet = wb.createSheet(safeName);
sheet.getPrintSetup().setLandscape(true);
sheet.getPrintSetup().setPaperSize(XSSFPrintSetup.LETTER_PAPERSIZE);

代码示例来源：origin: stackoverflow.com

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);

代码示例来源：origin: org.apache.poi/poi-examples

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);
      }
    }
  }
}

代码示例来源：origin: de.tudarmstadt.ukp.dkpro.lab/dkpro-lab-core

Sheet sheet = wb.createSheet("Summary");
PrintSetup printSetup = sheet.getPrintSetup();
printSetup.setLandscape(true);
sheet.setFitToPage(true);

代码示例来源：origin: net.paissad.tools.reqcoco/reqcoco-core

final PrintSetup ps = sheet.getPrintSetup();

代码示例来源：origin: de.tudarmstadt.ukp.dkpro.lab/de.tudarmstadt.ukp.dkpro.lab.core

Sheet sheet = wb.createSheet("Summary");
PrintSetup printSetup = sheet.getPrintSetup();
printSetup.setLandscape(true);
sheet.setFitToPage(true);

代码示例来源：origin: caryyu/excel2pdf

/**
   * 取得 Excel 版面設定的紙張大小並依據直橫式旋轉
   * @return
   */
  public Rectangle getPageSize() {
    short size = excel.getSheet().getPrintSetup().getPaperSize();
    boolean landScape = excel.getSheet().getPrintSetup().getLandscape();
    switch(size) {
    case PrintSetup.A3_PAPERSIZE:
      return landScape?PageSize.A3.rotate():PageSize.A3;
    case PrintSetup.A4_PAPERSIZE:
      return landScape?PageSize.A4.rotate():PageSize.A4;
    case PrintSetup.A4_ROTATED_PAPERSIZE:
      return landScape?PageSize.A4:PageSize.A4.rotate();
    case PrintSetup.A4_SMALL_PAPERSIZE:
        return landScape?PageSize.A4.rotate():PageSize.A4;
    case PrintSetup.A5_PAPERSIZE:
        return landScape?PageSize.A5.rotate():PageSize.A5;
    case PrintSetup.LETTER_PAPERSIZE:
      return landScape?PageSize.LETTER.rotate():PageSize.LETTER;
    case PrintSetup.LETTER_ROTATED_PAPERSIZE:
      return landScape?PageSize.LETTER:PageSize.LETTER.rotate();
    case PrintSetup.B4_PAPERSIZE:
        return landScape?PageSize.B4.rotate():PageSize.B4;
    case PrintSetup.B5_PAPERSIZE:
        return landScape?PageSize.B5.rotate():PageSize.B5;
    default: return landScape?PageSize.A4.rotate().rotate():PageSize.A4;
    }
  }
}

代码示例来源：origin: org.primefaces/primefaces

protected void applyOptions(Workbook wb, DataTable table, Sheet sheet, ExporterOptions options) {
  facetStyle = wb.createCellStyle();
  facetStyle.setAlignment(HorizontalAlignment.CENTER);
  facetStyle.setVerticalAlignment(VerticalAlignment.CENTER);
  facetStyle.setWrapText(true);
  applyFacetOptions(wb, options, facetStyle);
  cellStyle = wb.createCellStyle();
  cellStyle.setAlignment(HorizontalAlignment.LEFT);
  applyCellOptions(wb, options, cellStyle);
  PrintSetup printSetup = sheet.getPrintSetup();
  printSetup.setLandscape(true);
  printSetup.setPaperSize(PrintSetup.A4_PAPERSIZE);
  sheet.setPrintGridlines(true);
}

代码示例来源：origin: org.jxls/jxls-poi

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() );
}

代码示例来源：origin: com.bstek.ureport/ureport2-core

protected Sheet createSheet(SXSSFWorkbook wb,Paper paper,String name){
  Sheet sheet = null;
  if(name==null){
    sheet=wb.createSheet();
  }else{			
    sheet=wb.createSheet(name);
  }
  PaperType paperType=paper.getPaperType();
  XSSFPrintSetup printSetup=(XSSFPrintSetup)sheet.getPrintSetup();
  Orientation orientation=paper.getOrientation();
  if(orientation.equals(Orientation.landscape)){
    printSetup.setOrientation(PrintOrientation.LANDSCAPE);            
  }
  setupPaper(paperType, printSetup);
  int leftMargin=paper.getLeftMargin();
  int rightMargin=paper.getRightMargin();
  int topMargin=paper.getTopMargin();
  int bottomMargin=paper.getBottomMargin();
  sheet.setMargin(Sheet.LeftMargin, UnitUtils.pointToInche(leftMargin));
  sheet.setMargin(Sheet.RightMargin, UnitUtils.pointToInche(rightMargin));
  sheet.setMargin(Sheet.TopMargin, UnitUtils.pointToInche(topMargin));
  sheet.setMargin(Sheet.BottomMargin, UnitUtils.pointToInche(bottomMargin));
  return sheet;
}

代码示例来源：origin: com.bstek.ureport/ureport2-core

private Sheet createSheet(HSSFWorkbook wb,Paper paper,String name){
  Sheet sheet = null;
  if(name==null){
    sheet=wb.createSheet();
  }else{			
    sheet=wb.createSheet(name);
  }
  PaperType paperType=paper.getPaperType();
  HSSFPrintSetup printSetup=(HSSFPrintSetup)sheet.getPrintSetup();
  Orientation orientation=paper.getOrientation();
  if(orientation.equals(Orientation.landscape)){
    printSetup.setLandscape(true);
  }
  setupPaper(paperType, printSetup);
  int leftMargin=paper.getLeftMargin();
  int rightMargin=paper.getRightMargin();
  int topMargin=paper.getTopMargin();
  int bottomMargin=paper.getBottomMargin();
  sheet.setMargin(Sheet.LeftMargin, UnitUtils.pointToInche(leftMargin));
  sheet.setMargin(Sheet.RightMargin, UnitUtils.pointToInche(rightMargin));
  sheet.setMargin(Sheet.TopMargin, UnitUtils.pointToInche(topMargin));
  sheet.setMargin(Sheet.BottomMargin, UnitUtils.pointToInche(bottomMargin));
  return sheet;
}

内容来源于网络，如有侵权，请联系作者删除！

sheet

相关文章

    查看更多
    微信公众号

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新文章

    更多

    Sheet类方法

    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com