I am working on a project to out put formated data to an excel spredsheet. Currently I have the data wrtien to the spreadsheet and formatted correctly, all I want to do now is to add in a page break at a specific point. I am using the code below to add in
the page break, but it does not work even though I can not see anything wrong with the code.
//setting page break;
$sIndex = $sCol . $iRow;
I am currently using excel writer 5 and I am wrting to Excel 2007.
Many thanks in advance for your help
Nov 25, 2008 at 1:43 PM
Hmm... not sure what the problem is. I cannot reproduce the error.
Can you please try to run the following code snippet? It is working for me with both the Excel5 and Excel2007 writer.
$excel = new PHPExcel();When you print the above sheet, there should be a horizontal break below row 4, so that row 5 will go on second page.
$sheet = $excel->getActiveSheet();
$writer = new PHPExcel_Writer_Excel2007($excel);
$writer = new PHPExcel_Writer_Excel5($excel);
Your code worked perfectly.
I went back and had a look at my code around the page break and I was adding rows to $iRow to create a gap just before the page break, it turns out that this was causing the problem all along. I have now removed my gap code as I now no longer need it thanks
to the page break.
Thank you again for your help!