EViews.com

I'm trying to import an excel file that I created using Python, but am having trouble getting Eviews to recognize it. I use an API in Python to connect to a website and automatically pull all the data I need and then export that data to the correct directory, but Eviews doesn't seem to be finding it unless I go into the Excel file after exporting from Python and save it (without making any changes). This is the error I get if I don't go in and save it:

File 'C:\Users\OLEVIA~1.SHA\AppData\ev_temp\evxlsx1\xl//xl /worksheets/sheet1.xml' does not exist in "IMPORT
R:\FORECASTING\CHR\DATA\MORTGAGERATES_TEST.XLSX @FREQ M 1971:4" on line 10.

This is the code I use to import:
This may be an issue on the Python side, but I wanted to double check and see if this was a problem others have had or if there were any solutions on the Eviews side. Thanks!

Sounds like the Python code is creating a file that isn’t 100% compliant with the xlsx file format. Excel is able to handle the lack of compliance better than EViews is.

Easiest fix might be to save as csv from Python instead.

Switching to CSV worked! Thanks!