Page Break not working as expected.

Topics: Developer Forum
Nov 29, 2010 at 2:50 PM

I have followed the instructions and example given in

but the default page breaks still exist after I output the excel workbook. I am using Excel 2007 format.

I tried using setFitToPage, but it only works for worksheets with less than 100 rows. If the worksheet has more than 100 rows, then each cell becomes a separate page.

Ideally what is needed, is that columns A-H should be the width of each page. and at each 100 Rows a page break should occur.


Thank you for any assistance.



PHPExcel  1.7.4

PHP Version: 5.2.10

Centos 5.5