/**
* 设置打印配置
* @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());
}
POI拷贝Excel模版的打印设置
最新推荐文章于 2021-02-13 15:23:40 发布