#Custom Software

1 messages · Page 1 of 1 (latest)

onyx temple
#

Hello,

I am trying to allow my GPT powered program to connect to Microsoft based programs (like excel and work) so it can make changes inside the document. Any advice?

Thank you

torpid yarrowBOT
#

Hi @onyx temple. I'm kapa.ai, your friendly support bot. I will try to answer your question by searching through the knowledge base. :wave:

#

Hello,

Based on the information provided in the extracts, it seems that GPT models can interact with files and databases through certain features and configurations. However, there's no specific mention of direct interaction with Microsoft-based programs like Excel or Word.

For file interactions, one user mentioned that GPTs can read files only when you enable the ‘Code Interpreter’ feature in the ‘Configure > Capabilities’ screen source (https://community.openai.com/t/495915). However, this seems to be more related to reading files rather than making changes inside a document.

For database interactions, it was mentioned that GPT Actions work with APIs. You need to have a server that acts as a proxy to your database and establishes a connection. Afterwards, you can create an OpenAPI document and provide it to GPT as an action source (https://community.openai.com/t/529309). This might be a way to interact with data stored in a database, but it's not clear if this could be used for interacting with Microsoft-based programs.

Unfortunately, without more specific information or examples related to interacting with Microsoft-based programs, it's hard to provide a more definitive answer. You might want to explore OpenAI's documentation or community forums for more information on this topic.

Note: you can ask me a follow up question by @ mentioning me again :speech_balloon:

#

@onyx temple kapa.ai is still learning and improving, please let us know how it did by reacting below

onyx temple
#

Can I still ask you questions after you respond @torpid yarrow

#

@torpid yarrow can I still ask questions here

torpid yarrowBOT
#

Let me check the knowledge base for you. One moment! :books:

#

Yes, you can definitely continue to ask questions here. I'm here to help answer any queries you have about OpenAI and its related technologies.

Note: you can ask me a follow up question by @ mentioning me again :speech_balloon:

#

@onyx temple kapa.ai is still learning and improving, please let us know how it did by reacting below

onyx temple
#

@torpid yarrow I am building a custom software that should be able to connect to other applications on a computer (specifically excel and word) and make changes inside the document my program is connected to. Are there any API I can use OR how can I make this possible

torpid yarrowBOT
#

Let me check the knowledge base for you. One moment! :books:

#

Based on the information provided in the extracts, OpenAI's GPT models don't directly interact with applications like Excel or Word. However, you can use APIs or libraries provided by these applications to interact with them programmatically.

For Excel and Word, Microsoft provides APIs that you can use:

  1. Excel: Microsoft provides the Excel JavaScript API that allows you to create, read, and modify Excel workbooks. You can find more information in the official documentation (https://docs.microsoft.com/javascript/api/overview/excel).

  2. Word: Microsoft provides the Word JavaScript API for interacting with Word documents. You can find more information in the official documentation (https://docs.microsoft.com/javascript/api/overview/word).

You can use these APIs to create a server that interacts with Excel and Word. Then, you can use OpenAI's GPT models to generate instructions for this server. However, please note that executing calls to 3rd party tools is not managed by OpenAI source (https://help.openai.com/en/articles/8550641-assistants-api#h_bbc2d1eecb).

For Python, there are libraries like openpyxl for Excel and python-docx for Word that you can use to interact with these applications. OpenAI provides a custom Python library (https://github.com/openai/openai-python) which makes working with the OpenAI API in Python simple and efficient source (https://platform.openai.com/docs/quickstart?context=python).

Please note that these are just starting points and you might need to do more research and development to achieve your specific use case.

Note: you can ask me a follow up question by @ mentioning me again :speech_balloon:

#

@onyx temple kapa.ai is still learning and improving, please let us know how it did by reacting below

onyx temple
#

@torpid yarrow I am building my software with electron js, anything for that?

torpid yarrowBOT
#

Let me check the knowledge base for you. One moment! :books:

#

Based on the information provided in the extracts, there's no specific mention of Electron.js. However, Electron.js is a popular framework for building desktop applications with JavaScript, HTML, and CSS.

For interacting with Excel and Word documents in an Electron.js application, you can use the Office JavaScript API, which is the same API used for Office Add-ins. You can find more information in the official documentation (https://docs.microsoft.com/javascript/api/overview/excel).

For using OpenAI's GPT models in a JavaScript environment, you can use the openai npm package. This package provides a simple way to interact with the OpenAI API. You can find more information in the official documentation (https://github.com/openai/openai-node).

Please note that these are just starting points and you might need to do more research and development to achieve your specific use case.

Note: you can ask me a follow up question by @ mentioning me again :speech_balloon:

#

@onyx temple kapa.ai is still learning and improving, please let us know how it did by reacting below

onyx temple
#

@torpid yarrow what can I look up to get more answers

torpid yarrowBOT
#

Let me check the knowledge base for you. One moment! :books:

#

To get more answers and information for your specific use case, you can explore the following resources:

  1. OpenAI Documentation: The OpenAI API documentation (https://platform.openai.com/docs/introduction) provides detailed information about how to use the API, including how to make requests, how to handle responses, and how to troubleshoot common issues.

  2. OpenAI Community Forum: The OpenAI Community Forum (http://community.openai.com) is a great place to ask questions, share tips, and connect with other developers who are using the OpenAI API.

  3. Office JavaScript API Documentation: The Office JavaScript API documentation (https://docs.microsoft.com/javascript/api/overview/excel) provides detailed information about how to interact with Excel and Word documents in a JavaScript environment.

  4. Electron.js Documentation: The Electron.js documentation (https://www.electronjs.org/docs) provides detailed information about how to build desktop applications with JavaScript, HTML, and CSS.

  5. Online Tutorials and Guides: There are many online tutorials and guides that can help you learn how to use the OpenAI API, the Office JavaScript API, and Electron.js. Websites like Stack Overflow, GitHub, and Medium often have useful articles and discussions.

Remember, building a custom software that interacts with other applications like Excel and Word involves a combination of different technologies and might require a good understanding of these technologies and some trial and error.

Note: you can ask me a follow up question by @ mentioning me again :speech_balloon: