pkabirrvelixo
Oct 24, 2024Iron Contributor
Status:
New
API call to move or copy a single worksheet to a new workbook
In our legacy COM add-in, we have a very frequent use case when a user does a "data drill-down" operation, which produces a detailed data view on a separate worksheet called "Drilldown". ...
pkabirrvelixo
Oct 30, 2024Iron Contributor
AdrianWu as discussed, I explored the possibility of using the insertWorksheetsFromBase64 function, thanks for this suggestion!
While this is likely work, it still requires us to pass the entire source workbook's base64 through some sort of MessageChannel or BroadcastChannel before we discard most of it and append only one worksheet.
It would be more efficient and savvy if Excel.createWorkbook could accept the same options object, allowing us to only pick a subset of the source workbook's worksheets.