JXL中设置Excel文件的打印范围方法。
- WritableSheet sheet = workbook.getSheet(0);
- SheetSettings setting = sheet.getSettings();
- // ①设置打印范围(右上的列号和行号,左下的列号和行号)
- setting.setPrintArea(1, 2, 3, 4);
- // ②设置打印的标题部分(开始行和结束行)
- setting.setPrintTitlesRow(0, 3);
- // ③设置打印的标题部分(开始列和结束列)
- setting.setPrintTitlesCol(0, 3);
- // ④是否打印边框
- setting.setPrintGridLines(true);
- // ⑤是否打印行列番号
- setting.setPrintHeaders(false);
- // ⑥打印方向
- setting.setPageOrder(PageOrder.DOWN_THEN_RIGHT); // 从上往下
- setting.setPageOrder(PageOrder.RIGHT_THEN_DOWN); // 从左往右
- <pre> <span class="comment">// 设置页眉的文字</span>
- HeaderFooter header = new HeaderFooter();
- Contents contentsHeader = header.getRight();
- contentsHeader.setFontSize(10);
- contentsHeader.append(<span class="string">"系统时间"</span>);
- contentsHeader.appendDate();
- contentsHeader.append(<span class="string">" - "</span>);
- contentsHeader.appendTime();
- contentsHeader.append(<span class="string">" "</span>);
- contentsHeader.appendPageNumber();
- contentsHeader.append(<span class="string">" . "</span>);
- contentsHeader.appendTotalPages();
- setting.setHeader(header);
- <span class="comment">// 设置页脚的文字</span>
- HeaderFooter footer = new HeaderFooter();
- Contents contentsFooter = footer.getCentre();
- contentsFooter.setFontSize(10);
- contentsFooter.append(<span class="string">"打印时间"</span>);
- contentsFooter.appendDate();
- contentsFooter.append(<span class="string">" - "</span>);
- contentsFooter.appendTime();
- contentsFooter.append(<span class="string">" "</span>);
- contentsFooter.appendPageNumber();
- contentsFooter.append(<span class="string">" / "</span>);
- contentsFooter.appendTotalPages();
- setting.setFooter(footer);</pre> // 输出Excel <br>
- workbook.write(); <br>
- workbook.close();
- <pre></pre>
- <p></p>
- <pre></pre>
- <br>
- <br>
- <p></p>
- <br>