FrozenRows Property

Gets or sets the number of frozen Rows in the Worksheet. Frozen Rows are always shown at the top of the SheetView when a user scrolls down.

Syntax

Visual Basic
C#

'Declaration

 

Public Property FrozenRows As Integer

'Usage

 

Dim instance As SheetView

Dim value As Integer

 

instance.FrozenRows = value

 

value = instance.FrozenRows

public int FrozenRows {get; set;}

Remarks

The freeze always starts with the first Row in the Worksheet.

The default value is 0, which unfreezes all Rows. However, the value can be a number between 0 and 1048576. A value of 1048576 would freeze all Rows in the Worksheet. If a value of 3 is used, the first three Rows of the Worksheet will be frozen and will always be seen at the top of the SheetView, no matter how far the user scrolls down.

Example

Freezes the first five rows and the first column:



using( var workbook = Workbook.Load( "test.xlsx" ) )

{

  // Freezes the first 5 rows and adds a Fill Background to them.



  worksheet.SheetView.FrozenRows = 5;

  worksheet.Rows[ 0, 4 ].Style.Fill.BackgroundColor = System.Drawing.Color.Turquoise;



  // Freezes the first column and adds a Fill Background to it.

  worksheet.SheetView.FrozenColumns = 1;

  worksheet.Columns[ 0 ].Style.Fill.BackgroundColor = System.Drawing.Color.Tan;



  // Saves the workbook to disk.

  workbook.SaveAs( "FreezeRowsColumns.xlsx" );

}

Requirements

Target Platforms: Windows 11, Windows 10, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

SheetView Class
SheetView Members