(Update 2022-05-09: This code is no longer being maintained and there are no expectations that it will work. For the most up to date documentation on our API, consider visiting https://beta.openai.com/examples or https://github.com/openai/openai-python)
This repository contains an example OpenAI API integration for Excel. It allows users to query the API to automatically generate Excel tables about topics.
For more details see the API blog post
The integration is an Excel TaskPane Add-in, which is structured as an HTML / CSS / Javascript web app running in an iframe. See the following links for more info:
- https://docs.microsoft.com/en-us/office/dev/add-ins/overview/learning-path-beginner
- https://docs.microsoft.com/en-us/office/dev/add-ins/excel/excel-add-ins-core-concepts
Add your OpenAI API key and organization at the top of excel-addin/src/taskpane.js (search for ***KEY HERE*** and ***ORG HERE***)
To start the local development server from the excel-addin directory:
brew install node@12(Node LTS)npm installnpm run dev-server
Open Excel for the web. Click "Insert" Menu (Ribbon) > Click "Office Add-ins" > Click "Upload My Add-in" in the upper right corner > Select excel-addin/manifest.xml (source)
You should see a new "OpenAI API" command group on the "Home" ribbon; click the "Tabulate" button to open the sidebar with API commands
Added powershell script should be able to automate installation. Please refer to install.ps1