Feature Requests and Feedback
-
Expose Workbook events via Excel JavaScript API
Similar to Document.SelectionChanged event, the following Workbook-level events would be useful to have exposed via the JavaScript API (in no particular order):
Activate,Deactivate
BeforeSave,AfterSave
BeforeClose
Shutdown
SheetActivate,SheetDeactivate
SheetBeforeDoubleClick
SheetBeforeRightClick
SheetChange
SheetSelectionChange154 votesGlad to report that Many of the events asked here are GA!
please check this pageto see details;
https://docs.microsoft.com/en-us/office/dev/add-ins/excel/excel-add-ins-eventsWe are still to provide (other are in, please try them!)
BeforeSave,AfterSave
BeforeClose
Shutdown
SheetBeforeDoubleClick
SheetBeforeRightClickthanks!
-
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 votesYes! We announced GA for Custom Functions @ Build 2019. Please give it a try!
http://aka.ms/customfunctions -
Custom properties for Excel Addin
We can read/update custom properties in Word. It would be great if we can have similar function in Excel also.
27 votes -
Worksheet password protection
We are also concerned about the issue mentioned on this post:
http://stackoverflow.com/questions/38847193/excel-office-add-in-api-worksheet-protection-password
Currently we are able to protect and unprotect a worksheet. What we need is an API for password protection of worksheets which the end user would not know as this is will make the worksheets on OneDrive more secure for use.
21 voteswe now support both workbook and sheet pwd protection
chek https://docs.microsoft.com/en-us/javascript/api/excel/excel.worksheetprotection?view=office-js#protect-options--password-enjoy!!!
-
Make O365 user identity available in Excel Add In
I need to know the identity of the user who is invoking my Excel-based add-in so that I can rigorously and securely associate various external data access levels with them. It doesn't matter if they are not signed in - the app defaults to a Guest User and can encourage the user to sign into their excel client.
Specifically, I spent the last 2 days picking my way through the wilderness of ADAL and MSAL options and have concluded that I cannot use them within the confines of an Excel task pane app AND provide a satisfactory user experience. This…
4 votesSingle sign in is now in product/GA! Thanks for your suggestion. Let us know if you encounter any issues by going to https://github.com/OfficeDev/office-js/issues and opening a new issue. Thanks, Microsoft 365 developer platform team.
-
Allow Officejs to open external excel workbook programatically
There should be a way to open a external excel workbook by providing URL for that file on excel online via officejs. so that user can open a template stored on some other server which contains desired formatting and named-ranges which can be modified on Excel Online
51 votesThis API is now available in production!
Here is a sample snippet
https://gist.github.com/JuaneloJuanelo/399608d6928f6183b474af8f1f7e1c8aKey instruction: Excel.createWorkbook(mybase64);
please enjoy!!!
-
Implement Conditional Formatting Editing
The ability to edit conditional formatting in OfficeJS Excel API.
21 votesWe shipped this as part of 1.6. Extensive support for conditional formatting.
check https://docs.microsoft.com/en-us/javascript/api/excel/excel.range?view=office-js#conditionalformats
-
Excel - Add CopyWorksheet
We have a need to repeat the same formatted Worksheet over and over based on selections made by the user. It would be great to setup a template so that same worksheet can be copied. The worksheet has all formatting including printing stuff in place already. Be great to just be able to copy that and fill in the data.
44 votesThis is now available in the API! check
https://docs.microsoft.com/en-us/javascript/api/excel/excel.worksheet?view=office-js#copy-positiontype--relativeto-we also have in preview inserting sheets from other workbooks, please check this sample (remember is PREVIEW)
https://gist.github.com/jipyua/caec8eb5fddc0f611c43a1dbb356fa2a -
Add a method to copy a sheet with all data and formatting because there are no back-up or undo options for add-ins.
Since there is no way to cancel the changes made by an add-in, we need to provide users with backup options.
The current version of JavaScript API for Excel doesn't have a method for copying a sheet with its data and formatting, there are no elegant and fast workarounds available.
Could you please let us know if it's possible to add this method to JavaScript API for Excel?
114 votesnow we have this API please use it!
here the details: https://github.com/OfficeDev/office-js-docs/blob/ExcelJs_OpenSpec/reference/excel/worksheet.md#copypositiontype-worksheetpositiontype-relativeto-worksheetworksheetObject.copy(positionType, relativeTo);
Copy a worksheet and place it at the specified position. Return the copied worksheet.
Enjoy!
-
Allow Office Add-in in Excel to configure a cell so that user chooses value from a list of values
Enhance the Office JavaScript APIs (for Excel 2016+) to expose a mechanism (perhaps a Validation relationship or property) that allows the developer to configure a cell so that the end-user selects the value for the cell by picking from a list of values. The list of values might be specified by some other range. In a VSTO add-in (and native Excel) this can be achieved by configuring the Data Validation properties on a cell/range.
37 votesthis was shipped as part of our Data Validation feature! please try it!
https://docs.microsoft.com/en-us/javascript/api/excel/excel.listdatavalidation?view=office-js -
Provide access to CustomXMLParts for Excel via JS APIs
It will be good to have access to CustomXmlParts for Excel via JS APIs. Currently it supported only by Word. It allows developers to provide coolest plug-ins for Excel 365.
18 votesThis is shipped as part of 1.5!
https://docs.microsoft.com/en-us/javascript/api/excel/excel.workbook?view=office-js#customxmlparts
Enjoy!!!
-
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 votesRecently GA as part of the 1.9 requirement set announced at Build!
- Don't see your idea?