I want to import data from Excel files (.xlsx) into EViews.
I can't change the excel files and I can't know in advance the number of columns and rows (or in other words, I want my prg to work for any number of rows and columns).
I am currently using
Code: Select all
import(t=excelxml) %file range=%page colhead=1 namepos=first @smpl %debData %lastData
My problem is that some Excel files contains empty columns between columns with data and the EViews parser stop when encountering such empty column, leaving columns on the right not imported.
Is there any way to circumvent this problem ?
Many thanks
PS : I have attached an Excel file which I can't import.