The API is in preview for Excel Desktop and Mac now!
This feature is not be able to GA due to this API is not available on Excel online due to the Excel online cannot insert worksheet from the external workbook, so Team is now working on investigating on Excel online. and figure out the features that we can support now and our strategy is to build addFromBase64 for Excel Online with a limited supported feature, which allow us to GA this API. and then we will continue iterating this API to support more features
For Excel Desktop and Mac beta preview. you could use our Beta CDN, more info on this here https://aka.ms/excelapiopenspec
Here is a sample code snippet using the API
key line of code context.workbook.worksheets.addFromBase64(mybase64)
send an xlsx (base64 encoded)
please use it and send us feedback!
An error occurred while saving the commentBowei Han commented
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?
509 votesUnder review · 28 comments · Feature Requests and Feedback » Add-in: UX · Flag idea as inappropriate… · Admin →Bowei Han supported this idea ·