Excerpt |
---|
Freezes panes in a worksheet or returns the cell at which the panes are split. Set the property to a Cell object. The cell specified in Worksheet.FreezePanes is the first unfrozen cell; freeze panes will be applied to all rows above the cell and all columns to the left of the cell. |
Signature |
---|
C# | C# | Wiki Markup |
---|
{description}
{excerpt}Freezes panes in a worksheet or returns the cell at which the panes are split. Set the property to a [Cell|Cell] object. The cell specified in {{Worksheet.FreezePanes}} is the first unfrozen cell; freeze panes will be applied to all rows above the cell and all columns to the left of the cell. {excerpt}
{signature:C#}
public Cell FreezePanes{ get; set; }
|
Signature |
---|
{signature}{signature:vb.net | vb.net | }
Public Property FreezePanes() As Cell
|
Remarks |
---|
Freeze panes can only be applied to the first few rows or first few columns of a worksheet. This is a limitation of Excel and not ExcelWriter.
Web only |
---|
. | . | Image Removed |
Example |
---|
Code Block |
---|
| csharp | csharp |
title | C# |
---|
{signature}
{remarks}
Freeze panes can only be applied to the first few rows or first few columns of a worksheet. This is a limitation of Excel and not ExcelWriter.
{web-only:.}!Excel_FreezePane_Options.png!{web-only}
{remarks}
{example}{code:csharp|title=C#}
//--- Get FreezePanes
Cell freezeCell = ws.FreezePanes;
//--- Set FreezePanes for rows 1-5 and columns A, B
ws.FreezePanes = ws.Cells["C5"];
Code Block |
---|
{code}
{code:vb.net
vb.net | title | |title=vb.net
}
'--- Get FreezePanes
Dim freezeCell As Cell = ws.FreezePanes
'--- Set FreezePanes for rows 1-5 and columns A, B
ws.FreezePanes = ws.Cells("C5");
{code}
{example}