Import excel data with empty cols

[loulouviews]

Hi,

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.

[EViews Gareth]

You're kind of out of luck. You either have to tell EViews both the upper left corner and bottom right corner of the data, or only the upper left and have no blank rows/columns.

[loulouviews]

Ok :?
Thank you for answer !