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.

144 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    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!

    10 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base