1. //获取原Sheet页的设置
3. SheetSettings sheetSetting=sheet.getSettings();
5. //将原sheet页的打印设置设置到当前Sheet页中
7. sheet=new MjJxlExcelCopyPrintSetting().copySheetSettingToSheet(sheet, sheetSetting);

1. 下面是MjJxlExcelCopyPrintSetting的代码：
2. import jxl.HeaderFooter;
3. import jxl.Range;
4. import jxl.SheetSettings;
5. import jxl.format.PageOrientation;
6. import jxl.format.PaperSize;
7. import jxl.write.WritableSheet;
9. /**
10.  * 读取Jxl方法并设置
12.  * @author 邱大为
13.  * @version 1.0
14.  */
15. public class MjJxlExcelCopyPrintSetting {
16.     /**
17.      * 该方法将setting设置到sheet中
18.      * @param sheet 需要设置的sheet
19.      * @param setting 被设置的属性
20.      * @return
21.      */
22.     public WritableSheet copySheetSettingToSheet(WritableSheet sheet,SheetSettings setting){
23. //      设置原Sheet打印属性到新Sheet页
24.         SheetSettings sheetSettings= sheet.getSettings();
26.         sheetSettings.setAutomaticFormulaCalculation(setting.getAutomaticFormulaCalculation());
27.         sheetSettings.setBottomMargin(setting.getBottomMargin());
28.         sheetSettings.setCopies(setting.getCopies());
29.         sheetSettings.setDefaultColumnWidth(setting.getDefaultColumnWidth());
30.         sheetSettings.setDefaultRowHeight(setting.getDefaultRowHeight());
31.         sheetSettings.setDisplayZeroValues(setting.getDisplayZeroValues());
32.         sheetSettings.setFitHeight(setting.getFitHeight());
33.         sheetSettings.setFitToPages(setting.getFitToPages());
34.         sheetSettings.setFitWidth(setting.getFitWidth());
36.         HeaderFooter footer=setting.getFooter();
37.         if(footer!=null){
38.             sheetSettings.setFooter(footer);
39.         }
40.         sheetSettings.setFooterMargin(setting.getFooterMargin());
41.         HeaderFooter header=setting.getHeader();
42.         if(header!=null){
43.             sheetSettings.setHeader(header);
44.         }
45.         sheetSettings.setHeaderMargin(setting.getHeaderMargin());
46.         sheetSettings.setHidden(setting.isHidden());
47.         sheetSettings.setHorizontalCentre(setting.isHorizontalCentre());
48.         sheetSettings.setHorizontalFreeze(setting.getHorizontalFreeze());
49.         sheetSettings.setHorizontalPrintResolution(setting.getHorizontalPrintResolution());
50.         sheetSettings.setLeftMargin(setting.getLeftMargin());
51.         sheetSettings.setNormalMagnification(setting.getNormalMagnification());
52.         PageOrientation pageOrientation=setting.getOrientation();
53.         if(pageOrientation!=null){
54.             sheetSettings.setOrientation(pageOrientation);
55.         }
56.         sheetSettings.setPageBreakPreviewMagnification(setting.getPageBreakPreviewMagnification());
57.         sheetSettings.setPageBreakPreviewMode(setting.getPageBreakPreviewMode());
58.         sheetSettings.setPageStart(setting.getPageStart());
59.         PaperSize paperSize=setting.getPaperSize();
60.         if(paperSize!=null){
61.             sheetSettings.setPaperSize(setting.getPaperSize());
62.         }
64.         sheetSettings.setPassword(setting.getPassword());
65.         sheetSettings.setPasswordHash(setting.getPasswordHash());
66.         Range printArea=setting.getPrintArea();
67.         if(printArea!=null){
68.             sheetSettings.setPrintArea(printArea.getTopLeft()==null?0:printArea.getTopLeft().getColumn(),
69.                     printArea.getTopLeft()==null?0:printArea.getTopLeft().getRow(),
70.                             printArea.getBottomRight()==null?0:printArea.getBottomRight().getColumn(),
71.                                     printArea.getBottomRight()==null?0:printArea.getBottomRight().getRow());
72.         }
74.         sheetSettings.setPrintGridLines(setting.getPrintGridLines());
75.         sheetSettings.setPrintHeaders(setting.getPrintHeaders());
77.         Range printTitlesCol=setting.getPrintTitlesCol();
78.         if(printTitlesCol!=null){
79.         sheetSettings.setPrintTitlesCol(printTitlesCol.getTopLeft()==null?0:printTitlesCol.getTopLeft().getColumn(),
80.                 printTitlesCol.getBottomRight()==null?0:printTitlesCol.getBottomRight().getColumn());
81.         }
82.         Range printTitlesRow=setting.getPrintTitlesRow();
83.         if(printTitlesRow!=null){
84.             sheetSettings.setPrintTitlesRow(printTitlesRow.getTopLeft()==null?0:printTitlesRow.getTopLeft().getRow(),
85.                     printTitlesRow.getBottomRight()==null?0:printTitlesRow.getBottomRight().getRow());
86.         }
88.         sheetSettings.setProtected(setting.isProtected());
89.         sheetSettings.setRecalculateFormulasBeforeSave(setting.getRecalculateFormulasBeforeSave());
90.         sheetSettings.setRightMargin(setting.getRightMargin());
91.         sheetSettings.setScaleFactor(setting.getScaleFactor());
92.         sheetSettings.setSelected(setting.isSelected());
93.         sheetSettings.setShowGridLines(setting.getShowGridLines());
94.         sheetSettings.setTopMargin(setting.getTopMargin());
95.         sheetSettings.setVerticalCentre(setting.isVerticalCentre());
96.         sheetSettings.setVerticalFreeze(setting.getVerticalFreeze());
97.         sheetSettings.setVerticalPrintResolution(setting.getVerticalPrintResolution());
98.         sheetSettings.setZoomFactor(setting.getZoomFactor());
99.         return sheet;
100.     }
101. }
103. 关于POI的打印设置：

     转自http://bbs.club.sina.com.cn/tableforum/App/view.php?bbsid=343&subid=0&fid=5477&tbid=8182特此感谢

     1.页面
     1.1方向
     1.1.1纵向(T)HSSFPrintSetup#setLandscape(false); [默认状态]
     1.1.2横向(L)HSSFPrintSetup#setLandscape(true);

     1.2缩放
     1.2.1缩放比例(A)HSSFPrintSetup#setScale((short) 100);[默认状态]
     1.2.2调整(F)
     页宽 HSSFPrintSetup#setFitWidth((short) 1);
     页高 HSSFPrintSetup#setFitHeight((short) 0);

     1.3纸张大小(Z)HSSFPrintSetup#setPageSize(HSSFPrintSetup.LETTER_PAPERSIZE);
     纸张大小的定义说明：
     public static final short LETTER_PAPERSIZE = 1;
     public static final short LEGAL_PAPERSIZE = 5;
     public static final short EXECUTIVE_PAPERSIZE = 7;
     public static final short A4_PAPERSIZE = 9;
     public static final short A5_PAPERSIZE = 11;
     public static final short ENVELOPE_10_PAPERSIZE = 20;
     public static final short ENVELOPE_DL_PAPERSIZE = 27;
     public static final short ENVELOPE_CS_PAPERSIZE = 28;
     public static final short ENVELOPE_MONARCH_PAPERSIZE = 37;

     1.4打印质量(Q)HSSFPrintSetup#setVResolution((short) 300)
     1.5起始页码(R)HSSFPrintSetup#setPageStrart((short) 0);[默认状态]

     2页面距
     2.1上(T)HSSFSheet#setMargin(HSSFSheet.TopMargin,(short)0.6);
     2.2下(B)HSSFSheet#setMargin(HSSFSheet.BottomMargin,(short)0.6);
     2.3左(L)HSSFSheet#setMargin(HSSFSheet.LeftMargin,(short)0.6);
     2.4右(R)HSSFSheet#setMargin(HSSFSheet.RightMargin,(short)0.2);
     2.5页眉(A)HSSFPrintSetup#setHeaderMargin((double)0.2);
     2.6页脚(F)HSSFPrintSetup#setFooterMargin((double)0.6);
     2.7居中方式
     2.7.1水平(Z)HSSFSheet#setHorizontallyCenter(false);
     2.7.2垂直(V)HSSFSheet#setVerticallyCenter(false);

     3页眉/页脚
     3.1页眉HSSFHeader#setLeft（HSSFHeader.date();
     说明:
     首先获得HSSFHeader对象
     确定页眉的显示位置(如,左边显示页眉HSSFHeader#setLeft(显示内容))
     可使用HSSFHeader#setLeft,setCenter,setRight

     3.2页脚HSSFFotter#setLeft（HSSFFotter.page()+”/”+HSSFFotter.numPages()）；
     说明同3.1
     首先获得HSSFFotter对象
     确定页眉的显示位置(如,左边显示页眉HSSFFotter#setLeft(显示内容))
     可使用HSSFFotter#setLeft,setCenter,setRight

     4工作表
     4.1打印区域
     HSSFWorkbook#setPrintArea(intsheetIndex,
     intstartColumn,
     intendColumn,
     intstartRow,
     intendRow);
     参数的说明
     sheetIndex–从0开始的sheet的索引编号
     startColumn-打印区域的开始列号
     endColumn-打印区域的结束列号
     startRow-打印区域的开始行号
     endRow-打印区域的结束行号

     4.2打印标题
     HSSFWorkbook#setRepeatingRowsAndColumns(intsheetIndex,
     intstartColumn,
     intendColumn,
     intstartRow,
     intendRow);
     参数说明同4.1
     使用说明：
     仅仅设置左端标题列：
     workbook.setRepeatingRowsAndColumns(0,0,1,-1-1);

     仅仅设置顶端标题行：
     workbook.setRepeatingRowsAndColumns(0,-1,-1,0,4);

     同时设置左端和顶端标题：
     workbook.setRepeatingRowsAndColumns(0,-1,-1,-1,-1);

     4.3打印
     网格线(G)：HSSFSheet#setPrintGridlines(false);
     单色打印(B)HSSFPrintSetup#setNoColor(false);
     按草稿方式（Q）：HSSFPrintSetup#setDraft(false)；
     行号列标(L):（很抱歉，还没有找到）
     批注(M):（很抱歉，还没有找到）
     错误单元格打印为(E):（很抱歉，还没有找到）

     4.4打印顺序

     HSSFPrintSetup#setLeftToRight(false)；

本文链接地址: java jxl 的打印设置http://www.hongyanliren.com/2015m01/27509.html

相关文章

• 微信小程序中引入iconfont阿里矢量图库
• 微信小程序之toast等弹框提示
• 微信小程序-中处理json数据 （从json数据中提取想要的值 将变量json字符串转成json对象）
• 微信小程序中的变量和作用域
• 小程序 data变量用法 全局变量
• 微信小程序用setData修改数组或对象中的一个属性值
• 微信小程序多层嵌套循环，二级数组遍历【key】
• fastJSON使用（一）——对象转换成json