JXL的打印设置在jxl.SheetSettings这个类中,我们可以通过方法Sheet(或者WritableSheet)#getSettings()获取。
1.页面
1.1方向
SheetSetting#setOrientation(PageOrientation po);
参数: PageOrientation#LANDSCAPE 横向打印
PageOrientation# PORTRAIT 纵向打印
1.2缩放
1.2.1缩放比例(A) SheetSetting #setScaleFactor (int);百分比形式
1.2.2调整(F)
页宽 SheetSetting #setFitWidth(int);
页高 SheetSetting #setFitHeight(int);
1.3纸张大小(Z) SheetSetting #setPaperSize (PaperSize);
纸张大小的定义说明参见PaperSize类中的常量。
1.4起始页码(R) SheetSetting #setPageStrart(int);[默认状态]
2页面距
2.1上(T) SheetSetting # setTopMargin (double);
2.2下(B) SheetSetting # setBottomMargin (double);
2.3左(L) SheetSetting # setLeftMargin (double);
2.4右(R) SheetSetting # setRightMargin (double);
2.5页眉(A) SheetSetting #setHeaderMargin(double);
2.6页脚(F) SheetSetting #setFooterMargin(double);
2.7居中方式
2.7.1水平(Z) SheetSetting # setHorizontalCentre (boolean);
2.7.2垂直(V) SheetSetting #setVerticallyCenter(boolean);
3页眉/页脚
3.1页眉SheetSetting # setHeader(HeaderFooter);
说明:
对于HeaderFooter的设置,首先确定页眉的位置(左、中、右),通过HeaderFooter#getCentre()(或者getLeft()、getRight())方法获取HeaderFooter.Contents类,之后对这个类的属性进行操作。
下面简单介绍几个常用方法:
设置字号:Contents#setFontSize(int)
设置字体:Contents#setFontName(String)
设置内容:Contents# append(String),还有appendDate()当前日期等等,具体参考Contents类说明
3.2页脚SheetSetting # setFooter(HeaderFooter);
说明同上
4工作表
4.1打印区域
SheetSettings #setPrintArea(firstCol, firstRow, lastCol, lastRow)
4.2打印标题
SheetSettings#setPrintTitles (firstRow,lastRow,firstCol,lastCol);
SheetSettings#setPrintTitlesCol(firstCol,lastCol)
SheetSettings#setPrintTitlesRow(firstRow,lastRow)
另有一些其他的设置可在JXL API中找到,不多说了。
附件:通常在Excel中设置好打印,再将其读出来设置到当前页中来,附上代码:
在向Sheet页写数据之前:
1
//获取原Sheet页的设置
2
3
SheetSettings sheetSetting=
sheet.getSettings();
4
![](http://wanghaoran04141205.iteye.com/Images/OutliningIndicators/None.gif)
5
//将原sheet页的打印设置设置到当前Sheet页中
6
7
sheet=new
MjJxlExcelCopyPrintSetting().copySheetSettingToSheet(sheet, sheetSetting);
8
1
下面是MjJxlExcelCopyPrintSetting的代码:
2
![](http://wanghaoran04141205.iteye.com/Images/OutliningIndicators/None.gif)
3
import
jxl.HeaderFooter;
4
import
jxl.Range;
5
import
jxl.SheetSettings;
6
import
jxl.format.PageOrientation;
7
import
jxl.format.PaperSize;
8
import
jxl.write.WritableSheet;
9
![](http://wanghaoran04141205.iteye.com/Images/OutliningIndicators/None.gif)
10![](http://wanghaoran04141205.iteye.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
/** */
/**
11
* 读取Jxl方法并设置
12![](http://wanghaoran04141205.iteye.com/Images/OutliningIndicators/InBlock.gif)
13
* @author 邱大为
14
* @version 1.0
15
*/
16![](http://wanghaoran04141205.iteye.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
public class MjJxlExcelCopyPrintSetting
{
17![](http://wanghaoran04141205.iteye.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/** *//**
18
* 该方法将setting设置到sheet中
19
* @param sheet 需要设置的sheet
20
* @param setting 被设置的属性
21
* @return
22
*/
23![](http://wanghaoran04141205.iteye.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
public WritableSheet copySheetSettingToSheet(WritableSheet sheet,SheetSettings setting)
{
24
// 设置原Sheet打印属性到新Sheet页
25
SheetSettings sheetSettings= sheet.getSettings();
26
27
sheetSettings.setAutomaticFormulaCalculation(setting.getAutomaticFormulaCalculation());
28
sheetSettings.setBottomMargin(setting.getBottomMargin());
29
sheetSettings.setCopies(setting.getCopies());
30
sheetSettings.setDefaultColumnWidth(setting.getDefaultColumnWidth());
31
sheetSettings.setDefaultRowHeight(setting.getDefaultRowHeight());
32
sheetSettings.setDisplayZeroValues(setting.getDisplayZeroValues());
33
sheetSettings.setFitHeight(setting.getFitHeight());
34
sheetSettings.setFitToPages(setting.getFitToPages());
35
sheetSettings.setFitWidth(setting.getFitWidth());
36
37
HeaderFooter footer=setting.getFooter();
38![](http://wanghaoran04141205.iteye.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
if(footer!=null)
{
39
sheetSettings.setFooter(footer);
40
}
41
sheetSettings.setFooterMargin(setting.getFooterMargin());
42
HeaderFooter header=setting.getHeader();
43![](http://wanghaoran04141205.iteye.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
if(header!=null)
{
44
sheetSettings.setHeader(header);
45
}
46
sheetSettings.setHeaderMargin(setting.getHeaderMargin());
47
sheetSettings.setHidden(setting.isHidden());
48
sheetSettings.setHorizontalCentre(setting.isHorizontalCentre());
49
sheetSettings.setHorizontalFreeze(setting.getHorizontalFreeze());
50
sheetSettings.setHorizontalPrintResolution(setting.getHorizontalPrintResolution());
51
sheetSettings.setLeftMargin(setting.getLeftMargin());
52
sheetSettings.setNormalMagnification(setting.getNormalMagnification());
53
PageOrientation pageOrientation=setting.getOrientation();
54![](http://wanghaoran04141205.iteye.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
if(pageOrientation!=null)
{
55
sheetSettings.setOrientation(pageOrientation);
56
}
57
sheetSettings.setPageBreakPreviewMagnification(setting.getPageBreakPreviewMagnification());
58
sheetSettings.setPageBreakPreviewMode(setting.getPageBreakPreviewMode());
59
sheetSettings.setPageStart(setting.getPageStart());
60
PaperSize paperSize=setting.getPaperSize();
61![](http://wanghaoran04141205.iteye.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
if(paperSize!=null)
{
62
sheetSettings.setPaperSize(setting.getPaperSize());
63
}
64
65
sheetSettings.setPassword(setting.getPassword());
66
sheetSettings.setPasswordHash(setting.getPasswordHash());
67
Range printArea=setting.getPrintArea();
68![](http://wanghaoran04141205.iteye.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
if(printArea!=null)
{
69
sheetSettings.setPrintArea(printArea.getTopLeft()==null?0:printArea.getTopLeft().getColumn(),
70
printArea.getTopLeft()==null?0:printArea.getTopLeft().getRow(),
71
printArea.getBottomRight()==null?0:printArea.getBottomRight().getColumn(),
72
printArea.getBottomRight()==null?0:printArea.getBottomRight().getRow());
73
}
74
75
sheetSettings.setPrintGridLines(setting.getPrintGridLines());
76
sheetSettings.setPrintHeaders(setting.getPrintHeaders());
77
78
Range printTitlesCol=setting.getPrintTitlesCol();
79![](http://wanghaoran04141205.iteye.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
if(printTitlesCol!=null)
{
80
sheetSettings.setPrintTitlesCol(printTitlesCol.getTopLeft()==null?0:printTitlesCol.getTopLeft().getColumn(),
81
printTitlesCol.getBottomRight()==null?0:printTitlesCol.getBottomRight().getColumn());
82
}
83
Range printTitlesRow=setting.getPrintTitlesRow();
84![](http://wanghaoran04141205.iteye.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
if(printTitlesRow!=null)
{
85
sheetSettings.setPrintTitlesRow(printTitlesRow.getTopLeft()==null?0:printTitlesRow.getTopLeft().getRow(),
86
printTitlesRow.getBottomRight()==null?0:printTitlesRow.getBottomRight().getRow());
87
}
88
89
sheetSettings.setProtected(setting.isProtected());
90
sheetSettings.setRecalculateFormulasBeforeSave(setting.getRecalculateFormulasBeforeSave());
91
sheetSettings.setRightMargin(setting.getRightMargin());
92
sheetSettings.setScaleFactor(setting.getScaleFactor());
93
sheetSettings.setSelected(setting.isSelected());
94
sheetSettings.setShowGridLines(setting.getShowGridLines());
95
sheetSettings.setTopMargin(setting.getTopMargin());
96
sheetSettings.setVerticalCentre(setting.isVerticalCentre());
97
sheetSettings.setVerticalFreeze(setting.getVerticalFreeze());
98
sheetSettings.setVerticalPrintResolution(setting.getVerticalPrintResolution());
99
sheetSettings.setZoomFactor(setting.getZoomFactor());
100
return sheet;
101
}
102
}
103
![](http://wanghaoran04141205.iteye.com/Images/OutliningIndicators/None.gif)
104
![](http://wanghaoran04141205.iteye.com/Images/OutliningIndicators/None.gif)
105
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对象
确定页眉的显示位置(如,左边显示页眉