{"id":1318,"date":"2018-05-18T22:12:32","date_gmt":"2018-05-19T06:12:32","guid":{"rendered":"https:\/\/officedevblogs.wpengine.com\/?p=1318"},"modified":"2018-05-18T22:12:32","modified_gmt":"2018-05-19T06:12:32","slug":"excel-javascript-api-1-7-goes-ga","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/excel-javascript-api-1-7-goes-ga\/","title":{"rendered":"Excel JavaScript API 1.7 goes GA"},"content":{"rendered":"<h3><b>Excel JavaScript API 1.7 goes GA!<\/b><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/h3>\n<p>We&#8217;re pleased to announce that the Excel JavaScript 1.7 API is now generally available! We received lots of great feedback on the design of the APIs during the beta period and we appreciate your active participation. Our mission to provide a richer JavaScript library for Excel remains unchanged; you can look forward to new and enhanced APIs in the near future. Today we are excited to announce that more than four hundred new\u00a0APIs\u00a0 are\u00a0now available for you to use to create and amaze your customers with more powerful Excel add-ins!<span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<h3><b>What&#8217;s new in\u00a0<\/b><b>1.7?<\/b><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/h3>\n<ul>\n<li data-aria-level=\"1\" data-aria-posinset=\"1\" data-listid=\"7\" data-font=\"Symbol\" data-leveltext=\"\uf0b7\">Events &#8211; Enrich your Excel add-in experiences with new\u00a0coauth-proofed events. In 1.7 we\u00a0added\u00a0\u00a0<b>onChanged<\/b>,\u00a0<b>onSelectionChanged<\/b>,\u00a0<b>onAdded<\/b>, and\u00a0<b>onActivated<\/b>\/<b>onDeactivated<\/b>\u00a0to many Excel objects.<span data-ccp-props=\"{&quot;134233279&quot;:true,&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-aria-level=\"1\" data-aria-posinset=\"2\" data-listid=\"7\" data-font=\"Symbol\" data-leveltext=\"\uf0b7\">Customize chart elements &#8211; We added new APIs for charts to enable richer visualizations. With these APIs, add-ins can change\u00a0the appearance of a chart and\u00a0add series, trendlines, axis, titles and more.<\/li>\n<li data-aria-level=\"1\" data-aria-posinset=\"2\" data-listid=\"7\" data-font=\"Symbol\" data-leveltext=\"\uf0b7\">Custom and built-in\u00a0document properties &#8211; Create, read, delete,\u00a0and\u00a0update\u00a0 custom\u00a0document properties, as well as built-in document properties.<span data-ccp-props=\"{&quot;134233279&quot;:true,&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-aria-level=\"1\" data-aria-posinset=\"2\" data-listid=\"7\" data-font=\"Symbol\" data-leveltext=\"\uf0b7\">Styles &#8211; Apply built-in styles or create and apply your own custom styles.<span data-ccp-props=\"{&quot;134233279&quot;:true,&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-aria-level=\"1\" data-aria-posinset=\"2\" data-listid=\"7\" data-font=\"Symbol\" data-leveltext=\"\uf0b7\">More worksheet capabilities &#8211; Copy worksheets, as well as other worksheet properties\u00a0such as setting tab colors, within your workbook.<span data-ccp-props=\"{&quot;134233279&quot;:true,&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-aria-level=\"1\" data-aria-posinset=\"2\" data-listid=\"7\" data-font=\"Symbol\" data-leveltext=\"\uf0b7\">Password\u00a0protection for\u00a0workbooks.<span data-ccp-props=\"{&quot;134233279&quot;:true,&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<\/ul>\n<p>Check the sheet\u00a0<a href=\"https:\/\/dev.office.com\/reference\/add-ins\/requirement-sets\/excel-api-requirement-sets\">in this page<\/a>\u00a0for the full list of new APIs!<span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<h3><b>How to get a try<\/b><b>?<\/b><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/h3>\n<p>Office 365 users can get the benefit of these new APIs today! To use our new API, upgrade Excel to version 1801 (Build 9001.2171) or later.\u00a0You can also try these APIs on Excel\u00a0Online.\u00a0For\u00a0iOS\/Mac\/Online minimum versions, see\u00a0<a href=\"https:\/\/dev.office.com\/reference\/add-ins\/requirement-sets\/excel-api-requirement-sets\">requirement sets page<\/a>.<span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p>Do you want to participate in the design of upcoming Excel JavaScript preview APIs?\u00a0Excellent! Visit the\u00a0<a href=\"https:\/\/github.com\/OfficeDev\/office-js-docs\/blob\/ExcelJs_OpenSpec\/README.md\">Excel JavaScript <\/a>API Open Specification.<span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p>You can also try out the new API features by using the built-in code snippets that are available in Script Lab. In Script Lab, you&#8217;ll find samples that use preview APIs listed in the Preview APIs category.<span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p>We encourage you to try out the new APIs and tell us what you think. You can post questions about the APIs on\u00a0<a href=\"https:\/\/stackoverflow.com\/questions\/tagged\/office-js\">Stack Overflow<\/a>\u00a0(tag with\u00a0office-js), make suggestions for the docs on\u00a0<a href=\"https:\/\/github.com\/OfficeDev\/office-js-docs\/issues\">GitHub<\/a>, or suggest new API features on\u00a0<a href=\"https:\/\/officespdev.uservoice.com\/\">UserVoice<\/a>.<span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>We&#8217;re pleased to announce that the Excel JavaScript 1.7 API is now generally available! We received lots of great feedback on the design of the APIs during the beta period and we appreciate your active participation.<\/p>\n","protected":false},"author":69076,"featured_media":25159,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[11],"tags":[18],"class_list":["post-1318","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office-add-ins","tag-excel"],"acf":[],"blog_post_summary":"<p>We&#8217;re pleased to announce that the Excel JavaScript 1.7 API is now generally available! We received lots of great feedback on the design of the APIs during the beta period and we appreciate your active participation.<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/posts\/1318","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/users\/69076"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/comments?post=1318"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/posts\/1318\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/media\/25159"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/media?parent=1318"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/categories?post=1318"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/tags?post=1318"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}