vittorianicolosi1994
Regular Member
- Jan 17, 2024
- 279
- 81
Need a function that import the output of my question from Chatgpt into specific excel cell using API
found this excel plugin:
deepanshu88/excelChatGPT/
This Functions of ChatGPT's Excel Add-in could resolve my problem:
AIAssistant_QnA(query, passage) : It provides an answer to a question from within a custom large text you provided.
- query : Specify the cell containing a question.
- passage : Specify the cell containing a large text.
But i dont have already the data " containing the large text"
Which function cuold :
.AIAssistant(text, [word_count]) : Generates output for the search query using ChatGPT.
- text : Text you want to search
- word_count : Optional. Specify the maximum number of words for the output generated by ChatGPT.
AIAssistant_Chat(text, [reset]) : Converse like ChatGPT website remembers prior conversations.
- text : Text you want to search
- reset : Optional. Start/Reset chat session.
AIAssistant_FillData(rng_existingdata, rng_fill) : Fill incomplete data by training ChatGPT on existing data.
- rng_existingdata : Range of training data
- rng_fill : Specify cell that needs to be filled in.
AIAssistant_Extractor(prompt, keyword) : Extract key data from the text you provided. Key Data can be Name, Place, Organization details etc.
- prompt : Specify the cell which contains text from which you want to extract key data.
- keyword : keyword can be name, place, organisation etc
-
AIAssistant_Insights(rng_data, [prompt]) : It generates data insights from the provided dataset.
- rng_data : Specify cells containing data (including the header).
- prompt : Optional. Provide specific information you want about the data.
AIAssistant_QnA(query, passage) : It provides an answer to a question from within a custom large text you provided.
- query : Specify the cell containing a question.
- passage : Specify the cell containing a large text.
found this excel plugin:
deepanshu88/excelChatGPT/
This Functions of ChatGPT's Excel Add-in could resolve my problem:
AIAssistant_QnA(query, passage) : It provides an answer to a question from within a custom large text you provided.
- query : Specify the cell containing a question.
- passage : Specify the cell containing a large text.
But i dont have already the data " containing the large text"
Which function cuold :
.AIAssistant(text, [word_count]) : Generates output for the search query using ChatGPT.
- text : Text you want to search
- word_count : Optional. Specify the maximum number of words for the output generated by ChatGPT.
AIAssistant_Chat(text, [reset]) : Converse like ChatGPT website remembers prior conversations.
- text : Text you want to search
- reset : Optional. Start/Reset chat session.
AIAssistant_FillData(rng_existingdata, rng_fill) : Fill incomplete data by training ChatGPT on existing data.
- rng_existingdata : Range of training data
- rng_fill : Specify cell that needs to be filled in.
AIAssistant_Extractor(prompt, keyword) : Extract key data from the text you provided. Key Data can be Name, Place, Organization details etc.
- prompt : Specify the cell which contains text from which you want to extract key data.
- keyword : keyword can be name, place, organisation etc
-
AIAssistant_Insights(rng_data, [prompt]) : It generates data insights from the provided dataset.
- rng_data : Specify cells containing data (including the header).
- prompt : Optional. Provide specific information you want about the data.
AIAssistant_QnA(query, passage) : It provides an answer to a question from within a custom large text you provided.
- query : Specify the cell containing a question.
- passage : Specify the cell containing a large text.