I'm pretty new to EViews and I was trying to import an excel file using this code:
Code: Select all
import "a.xlsx" byrow colhead=2 namepos=first @freq a 1971
It throws this error when I run it:
File'C:\Users\b\AppData\ev_temp\evxlsx\[content_types].xml' does not match expected format in "IMPORT "A.XLSX" BYROW COLHEAD=2 NAMEPOS=FIRST @FREQ A 1971".
I'm not too sure what it means.
Here's some additional information:
That a.xlsx is created by converting a .csv file to a.xlsx using a Python script (because EViews couldn't read the entire time series due to formatting issues in the .csv file).
I tested the same code with a different Excel file (that I manually renamed from .csv to .xlsx) and it worked.
Using EViews 9.5
Any help is appreciated.
Thanks!