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

RDS
Posts: 85
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

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 12314
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

RDS
Posts: 85
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?

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 12314
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


Return to “General Information and Tips and Tricks”

Who is online

Users browsing this forum: No registered users and 9 guests