office-jsoffice-addinsadd-inexcel-addins

How to get or copy Office settings from another workbook?


I am developing an Excel add-in and storing workbook & add-in details in the Office settings to get the workbook settings whenever I share a workbook with someone. I have followed this steps to implement functionality.

Now I want to copy these settings from one workbook to another workbook using Office JS Excel add-in. Could you please guide me on how to implement this functionality or tell me that is it possible or not?


Solution

  • This cannot be done in an Excel add-in. With a few very limited exceptions, an add-in is in a world where there is only one workbook; the one that is currently open. It can read and write the open workbook, but it cannot reach out to some other workbook and write to it.