{"action":"opened","issue":{"url":"https://api.github.com/repos/OfficeDev/office-js-docs/issues/376","repository_url":"https://api.github.com/repos/OfficeDev/office-js-docs","labels_url":"https://api.github.com/repos/OfficeDev/office-js-docs/issues/376/labels{/name}","comments_url":"https://api.github.com/repos/OfficeDev/office-js-docs/issues/376/comments","events_url":"https://api.github.com/repos/OfficeDev/office-js-docs/issues/376/events","html_url":"https://github.com/OfficeDev/office-js-docs/issues/376","id":170052926,"number":376,"title":"Add and delete NamedItem in Excel?","user":{"login":"chewspot","id":4828474,"avatar_url":"https://avatars.githubusercontent.com/u/4828474?v=3","gravatar_id":"","url":"https://api.github.com/users/chewspot","html_url":"https://github.com/chewspot","followers_url":"https://api.github.com/users/chewspot/followers","following_url":"https://api.github.com/users/chewspot/following{/other_user}","gists_url":"https://api.github.com/users/chewspot/gists{/gist_id}","starred_url":"https://api.github.com/users/chewspot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chewspot/subscriptions","organizations_url":"https://api.github.com/users/chewspot/orgs","repos_url":"https://api.github.com/users/chewspot/repos","events_url":"https://api.github.com/users/chewspot/events{/privacy}","received_events_url":"https://api.github.com/users/chewspot/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-08-08T23:57:42Z","updated_at":"2016-08-08T23:57:42Z","closed_at":null,"body":"I've had a look at Excel API v1.3, but other than the new namedItemCollection.getItemOrNull(), there's nothing in the API to support adding/deleting named items.\r\n\r\nIs this functionality hidden somewhere else in the API? If not, can I suggest it be added?\r\n\r\n    // Adding new names?\r\n    let name: Excel.NamedItem = ctx.workbook.names.add(\"accountNum\", \"Sheet1!B3\");\r\n    let name: Excel.NamedItem = ctx.workbook.names.add(\"accountNum\", rangeObject);\r\n\r\n    // maybe with a parameter object for future extension?\r\n    let name: Excel.NamedItem = ctx.workbook.names.add({ name: \"accountNum\", refersTo: rangeObject });\r\n\r\n    // Deleting names\r\n    name.delete();\r\n"}}
{"actor":{"display_login":"chewspot"}}