SplitPanes(Width: Single; Height: Single): Integer;
FreezePanes(Row, Col, RowTop, ColLeft: Word; Single. Split-pane dimensions using the same units as the existing thawed pane helper: Word): Integer;
SplitPanes(Width: Single; Height: Single): Integer; SplitPanes(Width: Single; Height: Single): Integer; SplitPanes(Width: Single; Height: Single): Integer;;
SplitPanes(Width: Single; Height: Single): Integer; Word. Number of columns to freeze on the left side of the worksheet SplitPanes(Width: Single; Height: Single): Integer;;
SplitPanes(Width: Single; Height: Single): Integer; Word. Number of columns to freeze on the left side of the worksheet
SplitPanes(Width: Single; Height: Single): Integer; Word. Number of rows to freeze at the top of the worksheet
SplitPanes(Width: Single; Height: Single): Integer; Word. Number of columns to freeze on the left side of the worksheet
| Row, Col, RowTop, ColLeft |
); Workbook.SaveAs( |
| Single. Split-pane dimensions using the same units as the existing thawed pane helper |
var |
| The two-parameter SplitPanes(Width: Single; Height: Single): Integer; is the recommended entry point for common frozen pane layouts. Passing zero for both values removes frozen panes. Use |
begin |
| ); Workbook.SaveAs( |
This example freezes the first column and the first two rows, then replaces the frozen pane with a split pane |
var
Workbook: Contents; Sheet: TXLSWorksheet; SplitPanes begin UnfreezePanes or UnsplitPanes ); Sheet.UnfreezePanes; Sheet.SplitPanes(
); Workbook.SaveAs(
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;