Reading Data from XLSM file

For questions regarding programming in the EViews programming language.

Moderators: EViews Gareth, EViews Moderator, EViews Jason, EViews Matt

Post Reply
seoulmember
Posts: 1
Joined: Mon Dec 03, 2012 12:50 am

Reading Data from XLSM file

Postby seoulmember » Mon Dec 03, 2012 12:58 am

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.
Top
EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13604
Joined: Tue Sep 16, 2008 5:38 pm

Re: Reading Data from XLSM file

Postby EViews Gareth » Mon Dec 03, 2012 7:43 am

The READ command doesn't support Excel 2007 file formats. Use WFOPEN or IMPORT instead.
Top
Post Reply

Return to “Programming”

Who is online

Users browsing this forum: No registered users and 2 guests