Page 1 of 1

Get data from .xlsx file

Posted: Mon Mar 03, 2014 5:22 am
by Achkoune
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.

Re: Get data from .xlsx file

Posted: Mon Mar 03, 2014 8:58 am
by EViews Gareth
Use the Import command.

Re: Get data from .xlsx file

Posted: Thu Mar 06, 2014 4:53 am
by Achkoune
Use the Import command.
Can i get the right syntax using import command to replace the one above please.

Re: Get data from .xlsx file

Posted: Wed Mar 12, 2014 7:55 am
by Achkoune
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