0

[What I want to do]

  • To get Workbook object from Excel file online.
  • Equivalent to Google Apps Script > SpereadsheetApp.OpenByUrl() or OpenById().

[Why I have to do it]

  • To copy some template worksheets owned by me into the users' workbook by Office Add-ins | JavaScript API.
  • My template workbook and the users' workbook are in different context and I cannot find the method to access the workbooks existing online from JavaScript API.

So far, my solution would be to store the template workbooks as base64 string in the database and access the string data from Office Add-in JavaScript by API and insert to the users' workbook.

It is really appreciated if you can give me some insights. Thanks!

Eugene Astafiev
  • 47,483
  • 3
  • 24
  • 45
Daisuke Mori
  • 31
  • 3
  • I think that's correct to use base64 to access a workbook through Excel API. Currently not support get workbook directly using url. – Dongqi Lv Feb 27 '23 at 03:43

0 Answers0