跳到主要内容

GetLocation

Returns a range that describes the frozen cells in the active worksheet view.

Syntax​

expression.GetLocation();

expression - A variable that represents a ApiFreezePanes class.

Parameters​

This method doesn't have any parameters.

Returns​

ApiRange | null

Example​

This example freezes first column and get pastes a freezed range address into the table.

Api.SetFreezePanesType('column');
let worksheet = Api.GetActiveSheet();
let freezePanes = worksheet.GetFreezePanes();
let range = freezePanes.GetLocation();
worksheet.GetRange("A1").SetValue("Location: ");
worksheet.GetRange("B1").SetValue(range.GetAddress());