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

Versions Compared

Old Version 1

changes.mady.by.user Wiki Administrator

Saved on

compared with

New Version 2

changes.mady.by.user Alison Bird [softartisans]

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Signature
vb.net
vb.net
Public Property FreezePanes() As Cell
Remarks
Wiki Markup

Freeze panes can only be applied to the first few rows or first few columns of a worksheet. 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.
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 Block
vb.net
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");