How to set custom settings for worksheet using Exc

Question

I can set settings for whole workbook like here:

Office.context.document.settings.set("myKey", JSON.stringify(myValues));

Is there way to do the same but for specific worksheet ?

Answer 1

You should retrieve the Worksheet.id property and include it as part of each key you set.

(Worksheet names are also exposed to the API, but the user can change them, so id is recommended here.)

-Michael (PM for Office add-ins)