{"id":3624,"date":"2019-11-04T06:00:09","date_gmt":"2019-11-04T14:00:09","guid":{"rendered":"https:\/\/developer.microsoft.com\/en-us\/office\/blogs\/?p=3624"},"modified":"2021-10-18T11:03:02","modified_gmt":"2021-10-18T18:03:02","slug":"office-365-developer-platform-at-ignite-2019","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/office-365-developer-platform-at-ignite-2019\/","title":{"rendered":"Office 365 Developer Platform at Ignite 2019"},"content":{"rendered":"

Microsoft Ignite 2019<\/a> is over, but you can still stay on top of all the news. In this blog post, we share updates and new capabilities across Office 365 development that we announced at Ignite.<\/p>\n

Excel \u2013 continuing to enable new scenarios<\/h3>\n

Office Add-ins for Excel<\/h4>\n

With the Office.js Excel 1.10 requirement set, available now in the most recent monthly channel update, you have expanded capabilities to validate and audit existing spreadsheets and enable greater collaboration with Excel. For example, you can use the comments APIs to check items or assign them to people for review from your add-in. For enhanced interactivity, you can create Slicers for your reports, or even enable drill-down capabilities. The 1.10 API set brings our Excel JavaScript API count to over 2000 different APIs\u2013making now a great time to create Office Add-ins that leverage comprehensive Excel capabilities.<\/span><\/p>\n

\"picture<\/p>\n

New platform capabilities for custom functions<\/h4>\n

Custom functions, which became generally available at Microsoft Build 2019<\/a>, has some new capabilities in preview to try out. When creating custom functions you can now return built in errors with custom messages, for example: “#N\/A”, “Please sign in to access this resource.” Excel will display \u201cPlease sign in to access this resource\u201d in a tooltip to let the users of your custom function\u00a0 understand how to easily fix the error that occurred. There are also updates that introduce the ability to share state between a taskpane and a custom function, which enables full CORS support. To learn more about creating custom functions for Excel, see our documentation in the Office Dev Center<\/a>.<\/p>\n

Office Scripts \u2013 automation for Excel on the web<\/h4>\n

We announced a new feature coming to public preview by the end of 2019: Office Scripts for Excel on the web, which you can read more about it on the Excel blog<\/a>. One exciting part of the announcement is that Office Scripts uses the same technology and platform tools that Office Add-ins uses. We will continue to work to enable the best experience possible across the platform and look forward to seeing how you use Office Scripts to accomplish automation in Excel on the web.<\/p>\n

\"a<\/p>\n

Outlook Actionable Messages \u2013 always up to date, available everywhere<\/h3>\n

Outlook Actionable Messages continues\u00a0 to expand platform\u00a0 support, with Mac support rolling out starting at the end\u00a0 of 2019. Actionable Messages will now deliver productivity enhancing email on any platform \u2013 web, mobile, Windows, and Mac. Developers also now have the ability to auto-invoke a refresh of the Adaptive Card when an Actionable Message is first opened. This allows the most up to date content, no matter what platform you are on or how long it took to open the message by the recipient.<\/p>\n

A new\u00a0 tool you can use is the Actionable Messages<\/span>\u00a0 Designer. The designer is a new experience that lets you choose how you want to start designing your Adaptive Card to use in the Actionable Message.<\/p>\n

\"A<\/p>\n

You start by choosing a template or a blank card. Editing your choice is accomplished using the visual editor to drag and drop elements to where they are needed and updating their properties, seeing the updates to the content as you make them. The designer has a view function with a rendering of the content in both standard and mobile forms, letting you make design decisions with confidence. You can also send the message you created to yourself, making getting started on your Actionable Message journey simple. Learn more about Actionable Messages<\/a> and start designing them today using the Actionable Message Designer<\/a>.<\/p>\n

Finishing up<\/h3>\n

If you missed Microsoft Ignite 2019, there’s always next year! Please stop at the Office Extensibility booth in the Microsoft 365 Developer Platform area of the Hub and say hello to some of the people who work on these features. We’d love to hear from you!<\/p>\n

The Office Extensibility team<\/p>\n","protected":false},"excerpt":{"rendered":"

Microsoft Ignite 2019 is happening now – If you are attending in Orlando, watching remotely, or just trying to stay on top of the news, we are excited to share updates and new capabilities across Office 365 development.<\/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":[132,18,12],"class_list":["post-3624","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office-add-ins","tag-add-ins","tag-excel","tag-outlook"],"acf":[],"blog_post_summary":"

Microsoft Ignite 2019 is happening now – If you are attending in Orlando, watching remotely, or just trying to stay on top of the news, we are excited to share updates and new capabilities across Office 365 development.<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/posts\/3624","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=3624"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/posts\/3624\/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=3624"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/categories?post=3624"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/tags?post=3624"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}