GetLocation
function GetLocation(): ApiRange | "null"Description
Returns a range that describes the frozen cells in the active worksheet view.
Returns
ApiRange | "null"Try It
Api.SetFreezePanesType('column');
var oWorksheet = Api.GetActiveSheet();
var oFreezePanes = oWorksheet.GetFreezePanes();
var oRange = oFreezePanes.GetLocation();
oWorksheet.GetRange("A1").SetValue("Location: ");
oWorksheet.GetRange("B1").SetValue(oRange.GetAddress());