Feedback by UserVoice

I suggest you ...

Ability to open/replace workbook with Excel JS API in a similar way Word API can with insertFileFromBase64

We have a requirement to load a workbook from a remote source from within the add-in. User logs in, selects from a list and workbook template loads.

With the Word JS API we can load a template remotely using an AJAX call that returns the workbook as a base64 string and then insert the response into the current workbook using the replace option. AFAIK this doesn't exist for the Excel API and we download the workbook and then instruct the user to open from the download pane.

149 votes
Vote
Sign in
(thinking…)
Password icon
Signed in as (Sign out)
You have left! (?) (thinking…)
Mark shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

Hello! the API is in preview now! Make sure to have the latest insiders fast and use our Beta CDN, more info on this here https://aka.ms/excelapiopenspec

Here is a sample code snippet using the API

https://gist.github.com/jipyua/caec8eb5fddc0f611c43a1dbb356fa2a

key line of code context.workbook.worksheets.addFromBase64(mybase64)

send an xlsx (base64 encoded)

please use it and send us feedback!

11 comments

Sign in
(thinking…)
Password icon
Signed in as (Sign out)
Submitting...
  • Divisha commented  ·   ·  Flag as inappropriate

    Hi! We also tried using context.workbook.worksheets.addFromBase64(mybase64) and it gives This operation is not implemented error. We have Beta CDN for Office JS and excel-web-16.00.js. Are we missing something here?

  • Aaron Nwabuoku commented  ·   ·  Flag as inappropriate

    Hi! Is there a timeline of when this is expected to be stable and released? We tried using the API, following https://gist.github.com/jipyua/caec8eb5fddc0f611c43a1dbb356fa2a but received a "Not Implemented" error. We would like to send OOXML fragments from our remote servers to our Office Online Add-in going forward and this endpoint would be instrumental for that approach. Thanks!

  • Bowei Han commented  ·   ·  Flag as inappropriate

    We are trying to do something similar but the API - context.workbook.worksheets.addFromBase64(mybase64) - is throwing a "Not Implemented" exception for us even though we have the Beta CDN in office online. In the documentation it says that replace workbook is a beta feature - https://github.com/OfficeDev/office-js-docs - but the API is not included in the exhaustive list - https://github.com/OfficeDev/office-js-docs/blob/ExcelJs_OpenSpec/betaMembers.md. Is there something that we are missing?

    Thanks.

  • Tara commented  ·   ·  Flag as inappropriate

    This is an important feature for our development across Word, Excel and PowerPoint and we need for it to be aligned as soon as possible please. It would be very helpful if it came with future Office apps that support Add-In as well. Thank you.

  • Cory Isaacson commented  ·   ·  Flag as inappropriate

    This will be a very important feature. It is also important to be able to load a sheet into a workbook using Open XML so that the application can provide this on the fly.

  • Adin Schmahmann commented  ·   ·  Flag as inappropriate

    Additionally, aside from inserting the workbook from a base64 string it would be quite useful to insert the workbook from OOXML and generally Get/Set Excel (and PowerPoint) content from OOXML

  • Andy commented  ·   ·  Flag as inappropriate

    We would like something like insertSheetFromBase64; which would also require method to getSheetBase64. Would include all sheet content, including images, rangeNames, formatting, charts, etc.

Feedback and Knowledge Base