Feature Requests and Feedback
-
Add User Defined function support to the Apps for Office Excel APIs
Add User Defined function support to the Apps for Office Excel APIs so that users can enter formulas in excel. User Defined Functions are one of the most powerful features of Excel (and some competitor spreadsheets products now available in the web). They are critical for us to make our Apps for Office product as powerful as our legacy on premise product.
333 votesCustom functions are officially in Preview! Try them! more info in https://aka.ms/customfunctions
-
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.
149 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!
-
Add Abitility to create pivot Table via Office Javascript API
In the current version of the office javascript api I can see that the setSelectedDataAsync method allow only inserting text, matrix and table into excel spreadsheet.
I would like to see the javascript api enhanced and allow inserting pivot Table also. In this way I can use pivot Table helpers (such as slicer, fields list ....) and also refresh pivot table programmatically.
87 votesHappy to report that some of the functionalities are already in the product (all the basics for creating Pivots!) and some in preview (i.e. advanced filtering, calculated fields) .
please see the details here.https://docs.microsoft.com/en-us/office/dev/add-ins/excel/excel-add-ins-pivottables
-
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.76 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.
33 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.
13 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?