Feature Requests and Feedback
-
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.
164 votesHello! the API is in preview now! Make sure to have the latest insiders fast and use our Beta CDN, more info on this here https://aka.ms/excelapiopenspec
Here is a sample code snippet using the API
https://gist.github.com/jipyua/caec8eb5fddc0f611c43a1dbb356fa2a
key line of code context.workbook.worksheets.addFromBase64(mybase64)
send an xlsx (base64 encoded)
please use it and send us feedback!
-
Ability to manipulate Excel comments
Please add the ability to create, delete, and modify Excel Comments on specific cells using Office.js
153 votesThe comments API is in BETA now! please give a try! install insiders fast, use our beta CDN and try it!
let us know your feedback! -
Add bookmark Support in Word API 1.4
• 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 production
105 votes -
Make O365 user identity available in Word 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 votesWe’re happy to announce that single sign-on is now in preview. You can find more information here:
https://docs.microsoft.com/en-us/office/dev/add-ins/develop/sso-in-office-add-insThanks!
Office Extensibility Team -
Special Cells method
In Excel API, I can't choose cells based if they have formulas or values.
In VBA, I can do that by using Range.SpecialCells method. Also, I can specify if I want to get only text values, numbers, errors and/or booleans.
Please, support this for Excel JavaScript API, because currently, I'm looping all the worksheet's used range rectangle to get the values, and my loops spend a lot of time skipping blank cells.
39 votes -
Enable single sign-on (SSO) for Office Add-ins
The Single Sign-on API is currently supported in office.js preview.
28 votes -
Page Setup API
I would like to be able to access the page layout properties of the document so that I can set the print area.
14 votespagelayout object is in preview! pelase try it and send us feedback.
Check out https://aka.ms/excelapiopenspec
https://github.com/OfficeDev/office-js-docs/blob/ExcelJs_OpenSpec/reference/excel/pagelayout.md
- Don't see your idea?