How to update javascript excel Api set to 1.4

Question

I am developing an Office Excel Javascript addin using Microsoft Visual Studio 2015 Community Edition. I have installed Microsoft Excel 2016 for Windows. Now my addin needs to run certain methods which require Excel Api: Api Set 1.4. Now currently Visual Studio is using Api Set 1.1. What I want to know is how can I use the latest Api set which is 1.4 in Visual Studio so that I will get access to the latest methods.

This is what I have tried so far,

if(Office.context.requirements.isSetSupported("ExcelApi", 1.4){
//some code
}else {
console.log("Not supported");
}

which gives me "Not Supported".

I am referencing this office.js from the cdn:

script src="https://appsforoffice.microsoft.com/lib/1/hosted/Office.js" type="text/javascript"

Does anybody have any insights about this?

Rick Kirkham · Accepted Answer · 2017-03-10 18:32:57Z

0

Excel 2016 (installed with MSI) will not support Excel API 1.4 (See the note at the bottom of Add-in Availability.) You need the subscription (click-to-run) version of Excel that is in Office 365. Also, replace the "1" in your script link with "beta". See this page for details: Excel API Requirement Sets.

answered Mar 10, 2017 at 18:32

Rick Kirkham

9,9172 gold badges16 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Michael Zlatkovsky · Accepted Answer · 2017-03-10 18:59:06Z

0

To add to Ricky's answer:

As noted by Ricky, Office 2016 is different from the subscription-based Office 365, with only the latter getting updates to APIs. The Office host-application versioning and API versioning are both described in detail in the book "Building Office Add-ins using Office.js", available at https://leanpub.com/buildingofficeaddins/. (Full disclosure, I am the author of said book; but I do think you'll find plenty of very useful information therein, esp. about the APIs themselves).
The 1.4 APIs in particular are about a week or two away from being on the production CDN; so yes, right now you would need to use "beta", but the usual Office.js CDN URL will be good to use for 1.4 APIs in the near future.
Even if you are on the Office 365 subscription, it takes some time between the API team being "done" with a particular API set, and it being publicly available (generally about 1.5 months). So for 1.4 in particular, which was part of the January fork, looks like it's only rolling out publicly right now. If you're on an Office 365 enterprise subscription and are on the deferred channel (again, see more info in the book), you may be even further out. You'll know that your client supports it once isSetSupported("ExcelApi", 1.4) returns true.

answered Mar 10, 2017 at 18:59

Michael Zlatkovsky

8,7301 gold badge35 silver badges46 bronze badges

2 Comments

Ashay Over a year ago

We have E3 subscription of Office 365 and from there we have downloaded Office 2016 which has the deferred channel: Version 1609(Build 7369.2118)

Michael Zlatkovsky Over a year ago

Ok. Then it's still Office 365 (technet.microsoft.com/en-us/library/mt592918.aspx). But unless you do the "first release of deferred channel", it looks like you're still a few months away from a build that supports 1.4.

Collectives™ on Stack Overflow

How to update javascript excel Api set to 1.4

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related