Support for workbook.worksheets.addFromBase64 in Excel JS for Excel Online

%3CLINGO-SUB%20id%3D%22lingo-sub-2412167%22%20slang%3D%22en-US%22%3ESupport%20for%20workbook.worksheets.addFromBase64%20in%20Excel%20JS%20for%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2412167%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'd%20like%20to%20know%20about%20Excel's%20Product%20Team%20the%20plans%20to%20deliver%26nbsp%3B%3CSTRONG%3Eworkbook.worksheets.addFromBase64%3C%2FSTRONG%3E%20for%20Excel%20Online.%20Currently%2C%20it%20works%20only%20in%20Excel%20for%20Mac%20and%20Desktop%20(it%20doesn't%20work%20for%20iPad%20and%20Excel%20Online).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20been%20developing%20Office%20Addins%20for%20the%20last%205%20years%20and%20it%20is%20by%20far%20the%20most%20important%20API.%20Why%3F%20Because%20it%20is%20about%20%3CSTRONG%3Etemplates%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20the%20flow%20of%20all%20corporate%20Excel%20Addins%20I've%20developed%3A%3C%2FP%3E%3CP%3E-User%20opens%20the%20Addin%20and%20login%20in%20Addin%20Pane.%3C%2FP%3E%3CP%3E-User%20selects%20a%20spreadsheet%20model%20from%20its%20company%20in%20the%20Addin%20Pane.%3C%2FP%3E%3CP%3E-The%20model%20loads%20and%20then%20gets%20poulated%20via%20Excel's%20API%20from%20a%20database.%3C%2FP%3E%3CP%3E-User%20edits%20then%20click%20on%20save.%3C%2FP%3E%3CP%3E-Of%20course%2C%20there%20is%20a%20lot%20validation%20to%20save%20the%20data%20back%20to%20database.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20the%20flow%20with%20%3CSTRONG%3Eall%3C%2FSTRONG%3E%20of%20my%20corporate%20customers.%20I've%20never%20had%20any%20use%20of%20Office%20Addins%20for%20anything%20different%20from%20that.%20That's%20why%20it%20would%20be%20nice%20this%20API%20to%20work%20with%20Excel%20Online.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20don't%20want%20to%20%22recreate%20the%20wheel%22%20and%20use%20the%20API%20recreate%20a%20worksheet%20in%20Excel%20Online%2C%20it%20is%20simply%20too%20much%20work%20to%20do.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDon't%20get%20me%20wrong%2C%20as%20it%20works%20for%20both%20Excel%20and%20Mac%2C%20I%20can%20deliver%20great%20experience%20to%2095%25%2B%20of%20my%20customers.%20But%20there%20is%20always%20a%20customer%20that%20signs%20only%20Office%20E1%20and%20its%20employees%20use%20only%20Excel%20Online.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2412167%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2553544%22%20slang%3D%22en-US%22%3ERe%3A%20Support%20for%20workbook.worksheets.addFromBase64%20in%20Excel%20JS%20for%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2553544%22%20slang%3D%22en-US%22%3EHi%20Felipe%2C%20this%20API%20is%20now%20generally%20available%20for%20Web%2C%20Windows%2C%20Mac%3A%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fdev%2Fadd-ins%2Fexcel%2Fexcel-add-ins-workbooks%23insert-a-copy-of-an-existing-workbook-into-the-current-one%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fdev%2Fadd-ins%2Fexcel%2Fexcel-add-ins-workbooks%23insert-a-copy-of-an-existing-workbook-into-the-current-one%3C%2FA%3E%2C%20as%20part%20of%20the%20Excel%201.13%20Requirement%20set!%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2553562%22%20slang%3D%22en-US%22%3ERe%3A%20Support%20for%20workbook.worksheets.addFromBase64%20in%20Excel%20JS%20for%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2553562%22%20slang%3D%22en-US%22%3EP.s.%20If%20you%20have%20any%20issues%2C%20please%20post%20them%20on%20our%20github%20at%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fofficedev%2Foffice-js%2Fissues%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgithub.com%2Fofficedev%2Foffice-js%2Fissues%3C%2FA%3E%2C%20or%20ask%20questions%20on%20stack%20overflow%20with%20the%20tag%20%5Boffice-js%5D.%20We%20don't%20typically%20monitor%20tech%20community%2C%20so%20apologies%20on%20the%20delta%20in%20getting%20back%20to%20you.%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello!

 

I'd like to know about Excel's Product Team the plans to deliver workbook.worksheets.addFromBase64 for Excel Online. Currently, it works only in Excel for Mac and Desktop (it doesn't work for iPad and Excel Online).

 

I've been developing Office Addins for the last 5 years and it is by far the most important API. Why? Because it is about templates.

 

This is the flow of all corporate Excel Addins I've developed:

-User opens the Addin and login in Addin Pane.

-User selects a spreadsheet model from its company in the Addin Pane.

-The model loads and then gets poulated via Excel's API from a database.

-User edits then click on save.

-Of course, there is a lot validation to save the data back to database.

 

This is the flow with all of my corporate customers. I've never had any use of Office Addins for anything different from that. That's why it would be nice this API to work with Excel Online.

 

We don't want to "recreate the wheel" and use the API recreate a worksheet in Excel Online, it is simply too much work to do.

 

Don't get me wrong, as it works for both Excel and Mac, I can deliver great experience to 95%+ of my customers. But there is always a customer that signs only Office E1 and its employees use only Excel Online.

3 Replies
Hi Felipe, this API is now generally available for Web, Windows, Mac: https://docs.microsoft.com/en-us/office/dev/add-ins/excel/excel-add-ins-workbooks#insert-a-copy-of-a..., as part of the Excel 1.13 Requirement set!

P.s. If you have any issues, please post them on our github at https://github.com/officedev/office-js/issues, or ask questions on stack overflow with the tag [office-js]. We don't typically monitor tech community, so apologies on the delta in getting back to you.
Hi, I just saw your message. This is great news! Thanks for the good work!