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?
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');
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With