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:vb.net} Public Property FreezePanes() As Cell {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} |
Page History
Overview
Content Tools