Page 1 of 1

Reading Data from XLSM file

Posted: Mon Dec 03, 2012 12:58 am
by seoulmember
Hi there,

I have difficulties reading data from XLSM files. For some reason only a whole bunch of "serXX" series are created with no data included. I am using the "following command:

read(t=xlsm,b2,Sheet=EViews5) "Address\file.xlsm" 73

The file itself has the usual structure, i.e. dates in column-A, series-names in row-1 etc.

Cannot find any solution in the documentation. Would be great if someone could help. Many thanks in advance.

Re: Reading Data from XLSM file

Posted: Mon Dec 03, 2012 7:43 am
by EViews Gareth
The READ command doesn't support Excel 2007 file formats. Use WFOPEN or IMPORT instead.