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?
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.