read data from xlsx files

For notifying us of what you believe are bugs or errors in EViews.
Please ensure your copy of EViews is up-to-date before posting.

Moderators: EViews Gareth, EViews Moderator

evs123
Posts: 6
Joined: Thu Apr 15, 2010 4:15 pm

read data from xlsx files

Postby evs123 » Fri Jun 24, 2011 6:20 am

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?

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

Re: read data from xlsx files

Postby EViews Gareth » Fri Jun 24, 2011 8:02 am

The READ command doesn't support XLSX files. Use WFOPEN or IMPORT instead.
Follow us on Twitter @IHSEViews


Return to “Bug Reports”

Who is online

Users browsing this forum: No registered users and 15 guests