Writing to xlsx, skip X # of rows before continuing write?

Topics: User Forum
Nov 10, 2014 at 8:00 PM
PHPExcel: 1.8.0
PHP: 5.5.9

I have a setup to where I have an excel sheet template I'm wanting to use to return the results of registered users from a MySQL query.

The template is setup so each printed page has 20 records on it. Is there a way to have PHPExcel pause it's writing to the sheet, go down 6 rows, then continue inserting the results? The # of rows will be unknown...

I've looked through the documentation but I couldn't find anything that related to this...

Here's how the template looks:


Thank you for any guidance!
Nov 10, 2014 at 8:34 PM
PHPExcel does not provide any specific functionality to do this: your script will have to keep track of which row it is writing, and adjust the position where it writes accordingly

The alternative would be to define those rows to skip as part of a print heading
Nov 11, 2014 at 8:15 PM
Ok, thank you for the information Mark!

I'll have to play around with it some and see what I can come up with.