之前在网上搜了很久,也没有搜到具体页脚页数的答案,最后还是在官方api文档上找到了答案:
HSSFPrintSetup printSetup = (HSSFPrintSetup) sheet.getPrintSetup(); printSetup.setPaperSize(HSSFPrintSetup.A5_PAPERSIZE); // 纸张 sheet.setMargin(HSSFSheet.BottomMargin,( double ) 0.5 );// 页边距(下) sheet.setMargin(HSSFSheet.LeftMargin,( double ) 0.1 );// 页边距(左) sheet.setMargin(HSSFSheet.RightMargin,( double ) 0.1 );// 页边距(右) sheet.setMargin(HSSFSheet.TopMargin,( double ) 0.5 );// 页边距(上) sheet.setHorizontallyCenter(true);//设置打印页面为水平居中 sheet.setFitToPage(false); Footer footer = sheet.getFooter(); footer.setCenter( "第" + HeaderFooter.page() + "页,共 " + HeaderFooter.numPages()+"页" );
附上官方api文档地址:http://poi.apache.org/spreadsheet/quick-guide.html#FooterPageNumbers