Axolot Data

Posted: **Mon Nov 10, 2014 7:54 pm**

I was trying to get the page numbers to print, but there seems to problem:

XLS[SHEET].PrintSettings.HeaderFooter.OddHeader := '&[Page] of &[Pages]';

The result: 'Page] of Pages]'. The strange thing is that if I open the header in excel and click on it, then it displays the page numbers.

I have also tried:

Code: Select all

XLS[SHEET].PrintSettings.HeaderFooter.OddHeader := '\&\[Page] of \&\[Pages]';

Posted: **Mon Nov 10, 2014 8:12 pm**

Nevermind....found the answer in the XLSSheetData5 unit:

For anybody else looking it is:

Code: Select all

XLS[SHEET].PrintSettings.HeaderFooter.OddHeader := '&P of &N';

Axolot Data

HeaderFooter Page numbers?

HeaderFooter Page numbers?

Re: HeaderFooter Page numbers?