The Single Sign-on API is currently supported in office.js preview.42 votes
• Looks like bookmark support is being introduced in Word API 1.4
• This is currently available in Insider Preview builds and beta version of Office.js.
Please let us know when will this be available in production108 votes
I would like to be able to access the page layout properties of the document so that I can set the print area.22 votes
pagelayout object is in preview! pelase try it and send us feedback.
Check out https://aka.ms/excelapiopenspec
Please improve the dialog, it should allow to:
- set modality (right now the dialog is not modal!)
- have bidirectional communication, i.e. to have possibility to pass information directly from dialog to task pane and vice versa.
There are many use cases valid for both requirements:
- when you need to retrieve data from task pane (e.g. lazy loading)
- you have html where you fill the content, right now you need to pass them in URL which is not really nice solution.203 votes
Thank you for your feedback, we are happy to announce that the capability to message a dialog from the task pane is now available in preview. Please follow this link to get further information: https://docs.microsoft.com/en-us/office/dev/add-ins/develop/parent-to-dialog
With this API, the task pane can now message the dialog as well, pairing with the existing API allowing the dialog to message the task pane.
Ability to open/replace workbook with Excel JS API in a similar way Word API can with insertFileFromBase64
We have a requirement to load a workbook from a remote source from within the add-in. User logs in, selects from a list and workbook template loads.
With the Word JS API we can load a template remotely using an AJAX call that returns the workbook as a base64 string and then insert the response into the current workbook using the replace option. AFAIK this doesn't exist for the Excel API and we download the workbook and then instruct the user to open from the download pane.158 votes
The API is in preview for Excel Desktop and Mac now!
This feature is not be able to GA due to this API is not available on Excel online due to the Excel online cannot insert worksheet from the external workbook, so Team is now working on investigating on Excel online. and figure out the features that we can support now and our strategy is to build addFromBase64 for Excel Online with a limited supported feature, which allow us to GA this API. and then we will continue iterating this API to support more features
For Excel Desktop and Mac beta preview. you could use our Beta CDN, more info on this here https://aka.ms/excelapiopenspec
Here is a sample code snippet using the API
key line of code context.workbook.worksheets.addFromBase64(mybase64)
send an xlsx (base64 encoded)
please use it and send us feedback!
Please follow this link to get further information: https://docs.microsoft.com/en-us/office/dev/add-ins/excel/show-hide-add-in
Authenticated O365 users shall not be prompted to login again when they want to use Word Add-In. At the moment any Word Add In secured using O365 directory need to prompt users to enter their credential again despite that they have logged in to O365.
The goal is to provide a better user experience with this single sign on.89 votes
We’re happy to announce that single sign-on is now in preview. You can find more information here:
Office Extensibility Team
- Don't see your idea?