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
Using read command with Excel 2010?
Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason
Using read command with Excel 2010?
- 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?
READ does not support .XLSX/XLSM files.
IMPORT supports by row in EViews 8, but not in EViews 7.
IMPORT supports by row in EViews 8, but not in EViews 7.
Who is online
Users browsing this forum: No registered users and 2 guests
