Worksheet::freezePanes

Worksheet::freezePanes – Set panes and mark them as frozen.

Synopsis

require_once "Spreadsheet/Excel/Writer.php";

void Worksheet::freezePanes (
array $panes
)

Description

Set panes and mark them as frozen. One can use this method to mark
certain regions in the worksheet so that they are
"frozen" in the sense that when scrolling through the
worksheet these regions are not affected by the scrolling and
remain where they are on the screen. This is the same
functionality as provided by Microsoft Excel through the
->Window->Freeze
Panes menu command.

User Notes:

Be aware of param syntax, or you may experience some strange excel rendering issues. I.e., you want to freeze everything from 4th row, the following syntax is correct:
$worksheet->freezePanes(4, 0, 4, 0); //fifth param is not neccessary