GetParent

返回指定集合的父对象。

语法

expression.GetParent();

expression - 表示 ApiAreas 类的变量。

参数

此方法没有任何参数。

返回值

number

示例

从区域集合追溯到其在电子表格中所属的原始范围。

// How do I find the range that owns an areas collection in a spreadsheet?

// Navigate up from a group of areas to the single range that contains them all in a spreadsheet.

let worksheet = Api.GetActiveSheet();
let range = worksheet.GetRange("B1:D1");
range.SetValue("1");
range.Select();
let areas = range.GetAreas();
let parent = areas.GetParent();
let type = parent.GetClassType();
range = worksheet.GetRange('A4');
range.SetValue("The areas parent: ");
range.AutoFit(false, true);
worksheet.GetRange('B4').Paste(parent);
range = worksheet.GetRange('A5');
range.SetValue("The type of the areas parent: ");
range.AutoFit(false, true);
worksheet.GetRange('B5').SetValue(type);