The data analysis AI only writes python code.
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.