POI拷貝Excel模版的列印設定

來源:互聯網
上載者:User
/*** 設定列印配置* @param source_sheet* @param target_sheet*/public static void setPrintSetup(HSSFSheet source_sheet,HSSFSheet target_sheet) {HSSFPrintSetup s_printSetup = source_sheet.getPrintSetup();HSSFPrintSetup t_printSetup = target_sheet.getPrintSetup();t_printSetup.setCopies(s_printSetup.getCopies());t_printSetup.setDraft(s_printSetup.getDraft());t_printSetup.setFitHeight(s_printSetup.getFitHeight());t_printSetup.setFitWidth(s_printSetup.getFitWidth());t_printSetup.setFooterMargin(s_printSetup.getFooterMargin());t_printSetup.setHeaderMargin(s_printSetup.getHeaderMargin());t_printSetup.setHResolution(s_printSetup.getHResolution());t_printSetup.setLandscape(s_printSetup.getLandscape());t_printSetup.setLeftToRight(s_printSetup.getLeftToRight());target_sheet.setMargin(HSSFSheet.TopMargin,source_sheet.getMargin(HSSFSheet.TopMargin));// 頁面邊界(上)    target_sheet.setMargin(HSSFSheet.BottomMargin,source_sheet.getMargin(HSSFSheet.BottomMargin));// 頁面邊界(下)    target_sheet.setMargin(HSSFSheet.LeftMargin,source_sheet.getMargin(HSSFSheet.LeftMargin));// 頁面邊界(左)    target_sheet.setMargin(HSSFSheet.RightMargin,source_sheet.getMargin(HSSFSheet.RightMargin));// 頁面邊界(右    t_printSetup.setNoColor(s_printSetup.getNoColor());t_printSetup.setNoOrientation(s_printSetup.getNoOrientation());t_printSetup.setNotes(s_printSetup.getNotes());t_printSetup.setOptions(s_printSetup.getOptions());t_printSetup.setPageStart(s_printSetup.getPageStart());t_printSetup.setPaperSize(s_printSetup.getPaperSize());t_printSetup.setScale(s_printSetup.getScale());t_printSetup.setUsePage(s_printSetup.getUsePage());t_printSetup.setValidSettings(s_printSetup.getValidSettings());t_printSetup.setVResolution(s_printSetup.getVResolution());}

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.