Freeze Method

Freezes rows and columns.

Syntax

[VB.NET]
Public Sub Freeze(ByVal RowCount As Integer, ByVal ColumnCount As Integer)

[C#]
public void Freeze(int rowCount, int columnCount);

Remarks

This method freezes the specified number of rows and/or columns.

//Freeze a single row
ExcelDoc1.Freeze(1,0);

//Freeze a single column
ExcelDoc1.Freeze(0,1);

//Freeze multiple rows and columns
ExcelDoc1.Freeze(2,2);

To find how many rows or columns are currently frozen query FrozenRows and FrozenColumns. To unfreeze all rows and columns see Unfreeze.