Hello,
I'm having trouble with reading data into eviews from excel spreadsheet. I'm using Eviews 7.2 (updating regularly) and Excel 2007.
When I use the following command to read data into a workfile, no thing works. The workfile is created created, and but there is no series read in.
But once, I saved my data spreadsheets as xls (purely changing the file type), and change "xlsx" to xls in the below command lines. It works perfectly. All the data get imported perfectly.
So what went wrong with xlsx spreadsheets (or my codes probably)?
[wfcreate (wf=dataall, page=HH) q 1988q2 2011q1
read(b5, s=HH) "DAT - BOP - Net lending - Financial accounts basis qtrly.xlsx" 50
delete ser*][/code]
Can someone please help?
read data from xlsx files
Moderators: EViews Gareth, EViews Moderator
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13323
- Joined: Tue Sep 16, 2008 5:38 pm
Re: read data from xlsx files
The READ command doesn't support XLSX files. Use WFOPEN or IMPORT instead.
Follow us on Twitter @IHSEViews
Who is online
Users browsing this forum: No registered users and 15 guests