As like the Selection.Range.InsertXMl I need the option in excel also. It will be helpful for adding contents using openxml

I want to build RTD in office js, but can't found a way to define the RTD.

only found old VSTO with RTD server and so on.

Does we have a way to define a RTD function?

Just like 'freeze top row', in MS Excel please provide 'freeze bottom row' option in Freeze Pan menu

Our add-in uses cell patterns extensively and our functionality limited in a critical way without access to these properties.

Excel-js currently have new functionality to open up a new workbook using "Excel.createWorkbook", this opens up a new document with the workbook. I would like to suggest functionality where the workbook is not open in a new document, but instead in the same document as the add-in.

When designing and developing a VBA the developer can be reasonably sure that all the Excel APIs that are required for the project are available.
If the developer wants to convert an existing VBA project to Excel-JS there is currently no easy way to find out if the VBA APIs being used exist in the restricted subset of Excel-JS APIs.

It would be extremely useful to have a tool that analysed a VBA project and produced a unique list of all the VBA OM calls.

We would like to have array formula support available in the office.js API. We use these heavily in our VSTO Excel Add-in in combination with user defined functions to display function output in multiple cells. Having this feature available would allow us to build the Excel Office Add-in we would like to build.

For other forum browsers, here is an example of an array formula.
https://www.ablebits.com/office-addins-blog/2015/02/25/array-formulas-functions-excel/#array-formula-intro

Please note that while Binding.setDataAsync() in the office.js API supports adding formulas to a range of cells, you cannot see or edit the formula after adding.

I'd like to be able to access the username listed under Account -> User Information in my add-in in Microsoft Office Excel 2016.

Besides being able to customize the add-in experience and address the user by first name, having the full name would allow me to look up internal users and perform more advance functions like looking up permissions or recording their userId along with actions they perform.

As in VBA : for example :

Range("D2:E8").Subtotal GroupBy:=1, Function:=xlSum, TotalList:=Array(2), _
Replace:=True, PageBreaks:=False, SummaryBelowData:=True

Enable Visual Studio Mac to use the VBA hierarchy.
This will enable VB.Net to automate Excel Mac.
This will provide a relatively painless, powerful migration path for VBA devs.

It's a big user interface improvement if a user and can and drop cells and data between the task pane and Excel. I found a way to get this functionality working in the Excel 2016 desktop client (and it's wonderful!) but as far as I can tell, there's no way to do it in the browser-based client. This means that I have to detect whether or not Excel is 'win32' or 'web' and then use an equivalent but much less intuitive menu-based interface for the 'web' case.

One of the most annoying parts of working with office is that the worksheets and workbooks still behave the same as they did in the 90s. I want to be able to rip out workbooks and worksheets into their own window, to better make use of my multi-monitor or wide-monitor setup.

Function/ability to trace precedents and dependents with the office.js API (similar to GetPrecedents in VBA).

Allow transparent colors like rgba (not only hex #xxxxxx)

Add possibilities to disable screen updating to speed up things (Application.ScreenUpdating)

It could be interesting to develop the compatibility the macros for Android. More processes could be implemented easily

Excel defaults to calendar year when grouping in pivot table. There should be an option to change this to fiscal year and then selecting month that fiscal year should start. Although you can calcualte this through a formula, this is not helpful when you have pivot reports embedded in a CRM system. You don't want to have to recreate the wheel everytime a user wants an update