import data from xlsm files

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason

giuseppe68
Posts: 2
Joined: Wed Feb 06, 2013 7:02 am

import data from xlsm files

Postby giuseppe68 » Wed Feb 06, 2013 7:09 am

good morning, in the past I always used "read" command within programs to import some values frmo xls files, giving the reference of the sheet and of the single cell I wanted to import, now it seems this instruction doesn't work with xlsm files, so how could I do the same import from a xlsm file?
Thanks,

Giuseppe

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13604
Joined: Tue Sep 16, 2008 5:38 pm

Re: import data from xlsm files

Postby EViews Gareth » Wed Feb 06, 2013 8:54 am

Use WFOPEN or IMPORT instead of READ.

giuseppe68
Posts: 2
Joined: Wed Feb 06, 2013 7:02 am

Re: import data from xlsm files

Postby giuseppe68 » Wed Feb 06, 2013 9:17 am

how could I convert an isntruction like:
read(b3,nd=0,s=serie) "c:file.xls" serie
?


thanks,

giuseppe

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13604
Joined: Tue Sep 16, 2008 5:38 pm

Re: import data from xlsm files

Postby EViews Gareth » Wed Feb 06, 2013 9:41 am

Both the IMPORT and WFOPEN commands are documented in the Command Reference.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 1 guest