Office Extensibility: Build 2019
As thousands of developers arrive in Seattle for the Microsoft Build conference, we’re excited to share with the community what we’ve been working on in Office Extensibility. You can also catch up with news around Microsoft 365, Microsoft Graph, and Microsoft Teams in separate blog posts.
Mobile devices are a large part of our day-to-day life, and we’re using these devices to accomplish an ever growing number of tasks. When working on a mobile device, however, it can be cumbersome to context switch and move between services and applications. Actionable messages with Adaptive Cards, announced for Outlook on the web and Outlook for Windows at Build 2018, have allowed users to get more done from their desktop. Today, we’re excited to share we’ve added support to Outlook mobile for actionable messages, to help people increase their productivity while on their mobile device. Actionable messages let your users take action from within their email to complete tasks, such as approve expenses, grant access to permission request, and comment on tasks.
Actionable messages can use Adaptive Cards to surface information and support interactions in different canvases across Microsoft products, including Microsoft Teams, Outlook, and more. When sending actionable messages with Adaptive Cards, you don’t need to design for different experiences across platforms – the card will automatically render the experience that is contextually appropriate. In addition to support in Outlook for Windows and Outlook on the web, new support for Outlook mobile means that now is a great time to start building actionable messages and reaching your users where they are.
Working with data in Excel
- Volatile functions (which calculates every time Excel recalculates)
- Optional parameters
- The ability to get the cell address of the caller
- Any data types (including numbers, Boolean, strings)
To get started, go to https://aka.ms/customfunctions.
We’re always working to add highly requested API properties and methods to empower deep solutions in Excel. Since 2016, we’ve nearly quadrupled the number of APIs available for web add-ins in Excel.
COM:Web Add-in Bridge
We know that on Windows PCs, a COM or VSTO Add-in forms the primary experience of many integrations. The COM:Web Add-in Bridge makes it easy to register and seamlessly connect a complementary web add-in experience to your VSTO add-ins, so that developers can create great experiences across devices, including Mac and Android.
In this mode, your users can get the best of both worlds from both VSTO/COM and web add-ins. On Excel for Windows, your users can continue to use the existing VSTO/COM add-ins they all know and love. On Mac or Excel Online, they can take advantage of our modern experiences and platform reach through Office 365 web add-ins.
Learn more at https://aka.ms/com-web-bridge.
EdgeHTML-based webview for Office Add-ins
Office Add-ins allow you to create solutions that extend Office 365 and interact with content in documents, using web technologies. When running on Windows, Office Add-ins currently use a webview control as the runtime, provided by Internet Explorer 11. To better support modern browser standards, we are moving to an updated control. The new EdgeHTML-based control has better performance when compared to Internet Explorer 11 and supports modern HTML 5 and ECMAScript 2015+ capabilities. The EdgeHTML-based control is coming soon and will work with updated versions of Office 365 and Windows 10.
We’re also showing a preview of the next step in this journey at Build this year – a new control that is based on the next version of Microsoft Edge, built on Chromium. We’re committed to bringing standards-compliant controls to developers. To do this, we’re partnering with the Microsoft Edge team to make our work surface in Office 365. As we collaborate on the integration, we’ll continue to develop and share more information about what’s next for the WebView that powers Office Add-ins on Windows.
For more information, see Web viewers used by Office Add-ins.
Office 365 Developer Program – build solutions across Office 365
The Office 365 Developer Program, launched in April of 2018, helps you build experiences across Office 365. The program not only includes a way to get your own Office 365 E3 developer subscription, but also access to resources like community calls with experts, training, and community events. The program is also launching new content packs this summer that you can use to automatically populate your subscription with sample data. This will be a great way for you to explore building solutions with Office 365 data and learn how to integrate it with your solution. The data packs will include user profiles and mail, calendar, and contact data. We will continue to add data packs to enable you to try out scenarios in your developer subscription.
With the features that the Office 365 Developer Program provides, it has never been easier to build integrations across Microsoft 365. We’re excited to have you along with us on this journey and can’t wait to see what you build.
The Office Extensibility team