Worksheet.FreezePanes

FreezePanes(int, int, int, int)

Freezes panes at the specified cell in the worksheet.

public void FreezePanes(int row, int column, int freezedRows, int freezedColumns)
ParameterTypeDescription
rowInt32Row index.
columnInt32Column index.
freezedRowsInt32Number of visible rows in top pane, no more than row index.
freezedColumnsInt32Number of visible columns in left pane, no more than column index.

Remarks

Row index and column index cannot all be zero. Number of rows and number of columns also cannot all be zero.

The first two parameters specify the froze position and the last two parameters specify the area frozen on the left top pane.

See Also


FreezePanes(string, int, int)

Freezes panes at the specified cell in the worksheet.

public void FreezePanes(string cellName, int freezedRows, int freezedColumns)
ParameterTypeDescription
cellNameStringCell name.
freezedRowsInt32Number of visible rows in top pane, no more than row index.
freezedColumnsInt32Number of visible columns in left pane, no more than column index.

Remarks

Row index and column index cannot all be zero. Number of rows and number of columns also cannot all be zero.

See Also