Get data from .xlsx file

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

Moderators: EViews Gareth, EViews Moderator

Achkoune
Posts: 3
Joined: Fri Jun 07, 2013 1:49 am

Get data from .xlsx file

Postby Achkoune » Mon Mar 03, 2014 5:22 am

Hi

i need to read data from .xlsx file, i already search on the forum and some suggest to use the wfopen command but it is used to read data when we already an opened workfile so what i have to do to make that command work like this one (this command work on xls):

Read(S=TCE,T,c3) "E:\DMHOCP1981200.xls" 5

Thanks in advance.

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

Re: Get data from .xlsx file

Postby EViews Gareth » Mon Mar 03, 2014 8:58 am

Use the Import command.

Achkoune
Posts: 3
Joined: Fri Jun 07, 2013 1:49 am

Re: Get data from .xlsx file

Postby Achkoune » Thu Mar 06, 2014 4:53 am

Use the Import command.
Can i get the right syntax using import command to replace the one above please.

Achkoune
Posts: 3
Joined: Fri Jun 07, 2013 1:49 am

Re: Get data from .xlsx file

Postby Achkoune » Wed Mar 12, 2014 7:55 am

any help please how to use the import command to open xlsx file, i already use a script that use the read command :

Code: Select all

Read(S=TCE,T,c3) "E:\DMHOCP1981200.xls" 5
how to convert the syntax above using the import command.

Thanks in advance for your help


Return to “General Information and Tips and Tricks”

Who is online

Users browsing this forum: No registered users and 2 guests