Feature Requests and Feedback
-
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!!!
-
Method for determing which Office Application an Add-In is running in
Currently, an Add-In can be setup to be runnable in Excel, Word, PowerPoint, etc...
There are certain API features that are available to some of the Office Applications but not others; In addition, the availability of these features differ based on platform (fat clients, web, ipad, etc...). As such, we may choose to use TableData for an Add-In that is loaded in Excel, but HTML for the same Add-In loaded in Word.
Right now, we use the context.document.url property to determine the application, looking for the ",xls" extension in it.It's not a complete solution but it is getting us by…
17 votesHi Paul, thank you for the suggestion. This information is already available on the API. There’s more information in the documentation at: https://github.com/OfficeDev/office-js-docs/blob/master/reference/shared/context.md
Thanks,
Office Extensibility Team -
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!
-
Provide a feature which enable access to custom properties exists in the doc/workbook
Can you please provide a feature which enable access to custom properties exists in the doc/workbook ?,This will helps to make use of existing custom properties and will fill up the gap between OfficeJs and VSTO
18 votesThis feature is already supported in Word and Excel .
Please give it a try!!
https://docs.microsoft.com/en-us/javascript/api/excel_release/excel.customproperty?view=office-jshere is an example on how to use it in Word
async function insertNumericProperty() {
await context.sync(); console.log(“Property added”); });
await Word.run(async (context) => {
context.document.properties.customProperties.add(“Numeric Property”, 1234);}
async function insertStringProperty() {
await context.sync(); console.log(“Property added”); });
await Word.run(async (context) => {
context.document.properties.customProperties.add(“String Property”, “Hello World!”);}
async function readCustomDocumentProperties() {
await context.sync(); for (var i = 0; i < properties.items.length; i++) console.log( “Property Name:” + properties.items[i].key + “; Type=” + properties.items[i].type + “; Property Value=” + properties.items[i].value ); });
await Word.run(async (context) => {
let properties = context.document.properties.customProperties;
properties.load(“key,type,value”);}
-
Publish an official and up-to-date NuGet package for Exchange Web Services Managed API
NuGet is the quickest, easiest and best way to manage library dependencies. There are currently older published versions on NuGet with several /thousand/ downloads each that are not published by Microsoft. Please support the platform and provide us with official bits!
5 votesThanks for sharing this feedback. We have published the latest version of Exchange Web Services Managed API (2.2.1.1) via NuGet on 5/1/2018. Do give it a try. https://www.nuget.org/packages/Exchange.WebServices.Managed.Api/
Apologies for not updating this uservoice request, we are still doing some house cleaning as growing team.
- Don't see your idea?