Programatically open a excel document using javascript office api

Question

How to programatically open a document using javascript office api ?

Is there a way to insert a document using javascript office api Or to get access to the document xml ? Something like this

Excel.run(function (ctx) { 
    var application = ctx.workbook.application;
    application.load('newXmlWorkbook', worbookInXmlFormat);
    return ctx.sync().then(function() {
        console.log(application.calculationMode);
    });
}).catch(function(error) {
        console.log("Error: " + error);
        if (error instanceof OfficeExtension.Error) {
            console.log("Debug info: " + JSON.stringify(error.debugInfo));
        }
});

No, I have an Excel add-in built with javascript office api and I have a cloud storage with documents, I want when I click the document from my add-in, to load the document in Excel — Nicu
– Nicu, Commented Mar 8, 2016 at 14:35
In a similar scenario, we open documents within a new instance of Word with this JS code window.open('ms-word:ofv|u|' + filename); For Excel, window.open('ms-excel:ofv|u|' + filename);. — Miro J.
– Miro J., Commented Sep 8, 2016 at 15:41

Michael Saunders · Accepted Answer · 2016-03-09 19:41:34Z

3

In Word an add-in can insert an entire document with the Document.insertFileFromBase64() method.

In Excel this API isn't available. As an alternative, you can enable a download of the file instead of a replacement: for example, you can add an HTML link to the file and let the user download it or you can trigger the download yourself in JavaScript.

-Michael (PM for Office add-ins)

answered Mar 9, 2016 at 19:41

Michael Saunders

2,6781 gold badge15 silver badges21 bronze badges

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

3 Comments

Victor Suzdalev Over a year ago

Hi, Michael! Could you take a look at the question: stackoverflow.com/questions/36063158/…

Amitabh Over a year ago

Is Document.insertFileFromBase64() still valid?

JohnnyAW Over a year ago

@Amitabh looks like the method moved to Body class: dev.office.com/reference/add-ins/word/body

Collectives™ on Stack Overflow

Programatically open a excel document using javascript office api

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related