TRY NEW VERSION

Try now New API BETA

Try out the new view and capabilities of the API documentation

START

FreezeAt

FreezeAt(frozenRange)

Sets the frozen cells in the active worksheet view. The range provided corresponds to the cells that will be frozen in the top- and left-most pane.

Parameters:

Name Type Description
frozenRange ApiRange | String

A range that represents the cells to be frozen.

Returns:

This method doesn't return any data.

Example

Copy code
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
var oFreezePanes = oWorksheet.GetFreezePanes();
var oRange = Api.GetRange("H2:K4");
oFreezePanes.FreezeAt(oRange);
builder.SaveFile("xlsx", "FreezeAt.xlsx");
builder.CloseFile();

Resulting document