Adds a new name to a range of cells.
Name | Type | Description |
sName | string | The range name. |
sRef | string | The reference to the specified range. It must contain the sheet name, followed by sign ! and a range of cells. Example: "Sheet1!$A$1:$B$2". |
isHidden | boolean | Defines if the range name is hidden or not. |
builder.CreateFile("xlsx"); var oWorksheet = Api.GetActiveSheet(); oWorksheet.GetRange("A1").SetValue("1"); oWorksheet.GetRange("B1").SetValue("2"); Api.AddDefName("numbers", "Sheet1!$A$1:$B$1"); oWorksheet.GetRange("A3").SetValue("We defined a name 'numbers' for a range of cells A1:B1."); builder.SaveFile("xlsx", "AddDefName.xlsx"); builder.CloseFile();