Import .xlsx files

For requesting general information about EViews, sharing your own tips and tricks, and information on EViews training or guides.

Moderators: EViews Gareth, EViews Moderator

Post Reply
RDS
Posts: 86
Joined: Thu Feb 17, 2011 9:50 am

Import .xlsx files

Postby RDS » Mon Oct 07, 2013 3:29 am

what is the command needed to import .xlsx files in Eviews 7?

To import .xls files I do the following and it works
read(b2,t=xls,s=worksheet) name1.xls

To import .xlsx files I do the following and it does not work
read(b2,t=xlsx,s=worksheet) name2.xlsx

I only get NA
Top
EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13312
Joined: Tue Sep 16, 2008 5:38 pm

Re: Import .xlsx files

Postby EViews Gareth » Mon Oct 07, 2013 6:44 am

Either wfopen or import
Follow us on Twitter @IHSEViews
Top
RDS
Posts: 86
Joined: Thu Feb 17, 2011 9:50 am

Re: Import .xlsx files

Postby RDS » Mon Oct 07, 2013 8:25 am

can you suggest a line of program?
Top
EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13312
Joined: Tue Sep 16, 2008 5:38 pm

Re: Import .xlsx files

Postby EViews Gareth » Mon Oct 07, 2013 8:28 am

Code: Select all

wfopen name2.xlsx
Follow us on Twitter @IHSEViews
Top
Post Reply

Return to “General Information and Tips and Tricks”

Who is online

Users browsing this forum: No registered users and 7 guests