Add full support for insertWorksheetsFromBase64 method for Excel on the Web
"The insertWorksheetsFromBase64 method does not support for Excel on the Web doesn't support source worksheets with PivotTable, Chart, Comment, or Slicer elements." https://docs.microsoft.com/en-us/office/dev/add-ins/excel/excel-add-ins-workbooks#insert-a-copy-of-an-existing-workbook-into-the-current-one
This is a major limitation.
2 Comments
DavidGreenwood : Do you have any update on this development? This is blocker for our add-in development.
We need to load excel containing charts. But currently as no support of chart with insertWorksheetsFromBase64, we are unable to load excel.
Also we can't use Excel.CreateWorkbook API as this API opens excel in new tab with no information about new tab context.
Kindly provide updates.
Thanks
Answer given in the https://youtu.be/ik9yBecsF3A?t=1352
"We don't have a plan to implement insertWorksheetsFromBase64 for Excel on the web at this time. There's a dependency on a feature we require that is not yet in Excel on the web. There's an existing idea request to implement insertWorksheetsFromBase64 here. We ask that any developers affected by this please upvote here. If you can provide comments, especially if you are blocked, this would be helpful to bump up the priority on this."@davidchesnut
