Page 1 of 1

Import excel data with empty cols

Posted: Fri Jan 12, 2018 4:10 am
by 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.

Re: Import excel data with empty cols

Posted: Fri Jan 12, 2018 9:06 am
by 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.

Re: Import excel data with empty cols

Posted: Tue Jan 16, 2018 9:58 am
by loulouviews
Ok :?
Thank you for answer !