Page 1 of 1
import data from xlsm files
Posted: Wed Feb 06, 2013 7:09 am
by giuseppe68
good morning, in the past I always used "read" command within programs to import some values frmo xls files, giving the reference of the sheet and of the single cell I wanted to import, now it seems this instruction doesn't work with xlsm files, so how could I do the same import from a xlsm file?
Thanks,
Giuseppe
Re: import data from xlsm files
Posted: Wed Feb 06, 2013 8:54 am
by EViews Gareth
Use WFOPEN or IMPORT instead of READ.
Re: import data from xlsm files
Posted: Wed Feb 06, 2013 9:17 am
by giuseppe68
how could I convert an isntruction like:
read(b3,nd=0,s=serie) "c:file.xls" serie
?
thanks,
giuseppe
Re: import data from xlsm files
Posted: Wed Feb 06, 2013 9:41 am
by EViews Gareth
Both the IMPORT and WFOPEN commands are documented in the Command Reference.