PHPExcel Print current page in a cell

Question

I'm using PHPExcel and I have the next issue:

In the template I'm using, I must print the current page and total pages in some cells and this goes in a custom header that are IN the rows and not the header itself because the complex of the template.

I know, I can print those values in the header and footer but, is it possible to print the current page or total pages in a cell with PHPExcel?

Ok, so we're not talking about worksheets here, but your data with some pagination that you've defined? Wouldn't printing the page number in a cell be like printing any other data, then? (Which I assume you know how to do :)) — Torbjörn Stabo, Aug 29 '16 at 18:54
Explain how you would work it out in MS Excel itself, and then perhaps we can figure out if/how you can do it using PHPExcel — Mark Baker, Aug 29 '16 at 19:22

score 0 · Answer 1 · edited May 23 '17 at 12:08

I assume that when you say 'pages' you mean worksheets.

To get the amount of worksheets in PHPExcel try the following snippet:

$objPHPExcel->getSheetCount()

To get the name/index of your current sheet, you just need to keep track of your navigation between sheets, since switching between them is done by index, or by name, like this.

If it help you can get the current sheet's name using

$sheetName = $objPHPExcel->getActiveSheet()->getTitle();

as mentioned here, and according to this documentation you can get the active sheet's index using

$sheetIndex = $objPHPExcel->getActiveSheetIndex();

Good luck!

PHPExcel Print current page in a cell

1 Answers1