Glad to report that Many of the events asked here are GA!
please check this pageto see details;
We are still to provide (other are in, please try them!)
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 votes
Yes! We announced GA for Custom Functions @ Build 2019. Please give it a try!
We can read/update custom properties in Word. It would be great if we can have similar function in Excel also.27 votes
We are also concerned about the issue mentioned on this post:
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 votes
we now support both workbook and sheet pwd protection
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 Online51 votes
This API is now available in production!
Here is a sample snippet
Key instruction: Excel.createWorkbook(mybase64);
The ability to edit conditional formatting in OfficeJS Excel API.21 votes
We shipped this as part of 1.6. Extensive support for conditional formatting.
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 votes
This is now available in the API! check
we also have in preview inserting sheets from other workbooks, please check this sample (remember is PREVIEW)
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.
now 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-worksheet
Copy a worksheet and place it at the specified position. Return the copied worksheet.
this was shipped as part of our Data Validation feature! please try it!
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 votes
This is shipped as part of 1.5!
Recently GA as part of the 1.9 requirement set announced at Build!
- Don't see your idea?