GPT-4 (Advanced Data Analysis/Code Interpreter)work with excel files.
When there are merged cells in an Excel file, chatgpt is very stupid and produces endless errors. Briefly: cells move out, chatgpt is mistaken when there are merged cells in the file, it does not perceive them
The python code it writes must use python libraries capable of importing data. The AI can’t see the contents of the Excel file before the use of these libraries, code which may have poor translation of excel cells into python structures if they use advanced formatting.
Ask ChatGPT how to solve this problem with the python libraries it uses and the code it writes.