How to freeze headers and a set of columns using PHPExcel

Question

I want to freeze my page headers and columns like so:

enter image description here

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?

`$sheet->freezePane('{$highestColumnCount}{$highestRowCount}');` Tried that? — James McClelland, Jul 03 '14 at 11:41
possible duplicate of [phpexcel freeze row and columns](http://stackoverflow.com/questions/23423964/phpexcel-freeze-row-and-columns) — flu, May 20 '15 at 12:19

score 22 · Accepted Answer · answered Jul 03 '14 at 11:42

22

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" );

answered Jul 03 '14 at 11:42

Mark Baker

209,507
32
346
385

Spot on.. and from the development team themselves :D what an honour :D – Jimmyt1988 Jul 03 '14 at 11:43

score 2 · Answer 2 · answered Sep 24 '20 at 07:08

Freeze fourth column and first line :

$sheet = $spreadsheet->getActiveSheet(); //get current active sheet (first sheet)

$sheet->freezePane('D2');

And if you want to Freeze first column and first line:

$sheet->freezePane('B2');

Freeze first column only:

$sheet->freezePane('B1');

Freeze till second column:

$sheet->freezePane('C1');

Freeze first line(row) Only:

$sheet->freezePane('A2');

Freeze til second line(row):

$sheet->freezePane('A3');

How to freeze headers and a set of columns using PHPExcel

2 Answers2