Using read command with Excel 2010?

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

reto2410
Posts: 5
Joined: Wed Jan 27, 2010 8:52 am

Using read command with Excel 2010?

Postby reto2410 » Thu Apr 25, 2013 7:10 am

Hey There.

I work with EViews 7 and now have a problem with importing date from a Excel 2010 .xlsm file. Up to now I worked with Excel 2003, and i used the read command like
read(t,b2,s=TY) estimdat.xls 8
read(t,b2,s=VS) estimdat.xls 5
read(t,b2,s=ES) estimdat.xls 10
read(t,b2,s=TC) estimdat.xls 3
which imported for all defined Sheets in the Excelfile the number of series spezified. The series are in rows (see the attached file)

Now I have Excel 2010 (.xlsm) and I tried to change the code to
read(t,b2,s=TY) estimdat.xlsm 8
But this did not work.

Now my questions:
1. Does the read command support .xlsx/.xlsm documents
2. If not, does the read command in EViews 8 support .xlsx/.xlsm files
3. If not, Is there a way to use the import command with Excelfiles (.xlsx/.xlsm) when the series are in rows

Thanks for help!
Reto
Attachments
estimdat.xls
(39 KiB) Downloaded 482 times

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

Re: Using read command with Excel 2010?

Postby EViews Gareth » Thu Apr 25, 2013 7:27 am

READ does not support .XLSX/XLSM files.

IMPORT supports by row in EViews 8, but not in EViews 7.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests