I would like some ideas on how to use ChatGPT to identify specific cells in Excel.
I have an Excel sheet where fields like product names and raw materials are entered, but the location of these fields varies depending on the client. I want ChatGPT to determine the cell for these input fields.
For example, I would upload an Excel sheet and ask, “Which cell is for the product name?” and it would respond, “A2.”
I plan to handle this via the API, but I believe OpenAI Assistants’ file search tools do not support Excel. Is it possible to read an Excel sheet with Python, pass the resulting DataFrame to an OpenAI Assistant, and get an answer about the column and row position of the blank field next to the product name?
I am unsure how to write the code for this—any guidance would be appreciated.