Page History

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.

{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}
{code:vb.net

|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}

{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:vb.net

}
Public Property FreezePanes() As Cell