Freezes the left columns e top rows of a classic XLS worksheet, creates split panes, o removes pane settings from the worksheet
Sintassi
funzione FreezePanes(ARow: Word; ACol: Word): Integer; overload;
funzione FreezePanes(Row: Word; Col: Word; RowTop: Word; ColLeft: Word): Integer; overload;
funzione UnfreezePanes: Integer;
funzione SplitPanes(Width: Single; Height: Single): Integer;
funzione UnsplitPanes: Integer;
| ARow |
Word. Number of rows to freeze at the top of the worksheet |
| ACol |
Word. Number of columns to freeze on the left side of the worksheet |
| Row, Col, RowTop, ColLeft |
Word. Valori BIFF di basso livello dei riquadri per i chiamanti che hanno bisogno di posizioni di scorrimento esplicite |
| Width, Height |
Single. Dimensioni dei riquadri divisi usando le stesse unità dell'helper esistente per i riquadri sbloccati |
Osservazioni
The two-parameter overload is the recommended entry point for common frozen pane layouts. Passing zero for both values removes frozen panes. Usa SplitPanes to create a movable split instead of locked rows o columns. Usa UnfreezePanes o UnsplitPanes when code should explicitly clear any existing pane record
Esempio
This example freezes the first column e the first two rows, then replaces the frozen pane with a split pane
var
Workbook: IXLSWorkbook;
Sheet: TXLSWorksheet;
begin
Workbook := TXLSWorkbook.Create;
Sheet := Workbook.Worksheets.Add;
Sheet.FreezePanes(2, 1);
Sheet.UnfreezePanes;
Sheet.SplitPanes(4, 5);
Workbook.SaveAs('freeze-panes.xls');
end;