GrapeCity.Documents.Excel.IWorksheet.FreezePanes

FreezePanes Method

FreezePanes(int, int)

Freezes panes at the specified row and column positions.

Use this method to keep the rows above the specified row position and the columns to the left of the specified column position visible while scrolling the worksheet.

Declaration

void FreezePanes(int row, int column)

Sub FreezePanes(row As Integer, column As Integer)

Parameters

Type	Name	Description
int	row	The frozen row position.
int	column	The frozen column position.

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Name", "Value"},
    {"A", 100},
    {"B", 200},
    {"C", 300}
});
worksheet.FreezePanes(1, 1);