GetDefName
function GetDefName(defName: string = null): ApiName | "null"Description
Returns the ApiName object by the worksheet name.
Parameters
- defName
stringdefault: null The worksheet name.
Returns
ApiName | "null"Try It
var oWorksheet = Api.GetActiveSheet();
oWorksheet.GetRange("A1").SetValue("1");
oWorksheet.GetRange("B1").SetValue("2");
oWorksheet.AddDefName("numbers", "Sheet1!$A$1:$B$1");
var oDefName = oWorksheet.GetDefName("numbers");
oWorksheet.GetRange("A3").SetValue("DefName: " + oDefName.GetName());