poi设置打印页页脚和页数设置

之前在网上搜了很久,也没有搜到具体页脚页数的答案,最后还是在官方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

原文地址:https://www.cnblogs.com/SimonHu1993/p/8405395.html