本文概述
Apache POI允许我们在工作表的页脚设置页码。要设置页码,getFooter()方法创建页脚,而page()和numPages()都用于设置页码。
在下面的示例中,我们首先创建一个页脚,然后向其中添加页码。
Apache POI页码示例
package poiexample;
import java.io.FileOutputStream;
import java.io.OutputStream;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.usermodel.HeaderFooter;
import org.apache.poi.ss.usermodel.Footer;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
public class PageNoExample {
public static void main(String[] args) {
try (OutputStream os = new FileOutputStream("srcmini.xls")) {
Workbook wb = new HSSFWorkbook();
Sheet sheet = wb.createSheet("Sheet");
Footer footer = sheet.getFooter();
footer.setRight( "Page " + HeaderFooter.page() + " of " + HeaderFooter.numPages() );
wb.write(os);
}catch(Exception e) {
System.out.println(e.getMessage());
}
}
}
输出: