OfficeWriter Documentation
.
ExcelWriter v8 Docs
Space Shortcuts
Page tree
ConfigureSpace tools

Versions Compared

Old Version 9

changes.mady.by.user Whitney Sternberg [softartisans]

Saved on

compared with

New Version Current

changes.mady.by.user Whitney Sternberg [softartisans]

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Description

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#
 public Cell FreezePanes{ get; set; }
{signature}{signature:
}
Signature
vb.net
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:.}
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#}

Example
Code Block
csharp
csharp
titleC#


          //--- Get FreezePanes
          Cell freezeCell = ws.FreezePanes;

          //--- Set FreezePanes for rows 1-5 and columns A, B
          ws.FreezePanes = ws.Cells["C5"];
{code} {code:
 Code Block
vb.net
|title=
vb.net
titlevb.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}