Store a key like LABS.GENERATIVEAI

[chengtie]

Hello,

We have published several Excel add-ins, we would like to enable users to use their own OpenAI kpi key in our tools as LABS.GENERATIVEAI of Excel Labs does:

"This OpenAI account key is stored in your machine's local Excel settings and is shared across workbooks on your machine, but it's not saved in the workbook or shared with other users who open the workbook." ==> Does anyone know which JavaScript Excel API enables a saving of key like that?

Thank you

[guoms1]

Hi, @chengtie

Thank you for reaching out! Based on the behavior you described—storing a key in a machine's local Excel settings and sharing it across workbooks without embedding it into the workbook—it’s worth noting that this isn’t a standard feature of the Office JavaScript API for Office Add-ins.

However, you can achieve similar functionality using custom local storage mechanisms. Specifically, you can leverage the browser's localStorage or IndexedDB in Excel desktop apps (which use an embedded web browser for running add-ins). This approach allows you to store keys locally on the machine and share them across workbooks, but they won’t be accessible to other users or devices.

Here’s an example of how this can be implemented with localStorage:

// Save a key to localStorage
localStorage.setItem("apiKey", "your-api-key");

// Retrieve the key
const apiKey = localStorage.getItem("apiKey");
console.log("Retrieved API key:", apiKey);

Let me know if you have any questions or need further guidance. I’d be happy to help!

Best regards,

[guoms1]

I believe your issue has been resolved so I'll go ahead and close this issue for now, but please don't hesitate to reopen it or create a new issue if you have further questions or need additional assistance.

Have a great day!