Worksheet::freezePanes -- Set panes and mark them as frozen.
Beschrijving
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
+ menu command.
Note
Deze functie kan niet statisch worden aangeroepen.
Voorbeeld
Voorbeeld 39-1. Using freezePanes()
<?php
$worksheet =& $workbook->addWorksheet("Some Worksheet");
/* ... */
/* This freezes the first six rows of the worksheet: */
$worksheet->freezePanes(array(6, 0));
/* To freeze the first column, one must use the following syntax: */
$worksheet->freezePanes(array(0, 1));
?>
|
If one needs to further specify the scrolling region, the
following syntax can be used:
<?php
/* Freeze the first six rows and start the scrollable region at row nine: */
$worksheet->freezePanes(array(6, 0, 9, 0));
?>
|
|
