java报表JXL和POI打印设置.

男娘i 2024-02-18 19:46 35阅读 0赞

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![None.gif][]//获取原Sheet页的设置    
 2![None.gif][]   
 3![None.gif][]SheetSettings sheetSetting= sheet.getSettings();  
4 ![None.gif][]  
5![None.gif][]//将原sheet页的打印设置设置到当前Sheet页中    
 6![None.gif][]   
 7![None.gif][]sheet=new  MjJxlExcelCopyPrintSetting().copySheetSettingToSheet(sheet, sheetSetting);  
8![None.gif][]

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

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

转载：[http://www.blogjava.net/Vincent-chenxj/articles/242512.html][http_www.blogjava.net_Vincent-chenxj_articles_242512.html]

[None.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/29/734f04ac34004d8f969989ed026a4f66.png
[ExpandedBlockStart.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/29/7a2259e3b24946e7a7c32de4c53d5eb4.png
[InBlock.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/29/0ab0cbfea9614fcba7e7f171b8ef1b45.png
[ExpandedBlockEnd.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/29/91f17f76ef074dd6a6f332422ad4643e.png
[ExpandedSubBlockStart.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/29/054343f06b4b4e2b9e5ea820f4b6d223.png
[ExpandedSubBlockEnd.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/29/b1156222789449588ae2999880990cef.png
[http_www.blogjava.net_Vincent-chenxj_articles_242512.html]: http://www.blogjava.net/Vincent-chenxj/articles/242512.html