How to freeze headers and a set of columns using PHPExcel
php, phpexcel
Solution
You can only have one single freezePane on any individual worksheet, so you set the address to cover both horizontal and vertical, e.g.
$sheet->freezePane( "D2" );
Problem
I want to freeze my page headers and columns like so: I can freeze my headers absolutely fine and dandy: ``` $highestRowCount = $sheet->getHighestRow(); $highestColumnCount = $sheet->getHighestColumn(); $sheet->freezePane( "{$highestColumnCount}2" ); ``` But when I then add another freeze on the columns: ``` $sheet->freezePane( "D{$highestRowCount}" ); ``` It breaks excels ability to scroll... How might I go about doing this?