I would like to add automatic page numbers to the footer of a worksheet. Such can be done in excel by setting the footer text to "&[Page] of &[Pages]". However, when I try this:
outSheet = outBook.getActiveSheet();
outSheet.getPageSetup().setCenterFooter("&[Page] of &[Pages]");
My footer prints out as: "Page] of Pages]"
Is it possible to include automatic page number in the footer of an excel sheet? If so, how?