Page 1 of 1

keep the frequency argument when importing data

Posted: Sun Feb 28, 2016 12:37 am
by gyw1028
Dear all,
I want to create a workfile with frequency argument, and import excel data.
When I create a workfile by using the following code:
wfcreate test d5 2013-7-1 2014-8-31
I can obtain a workfile with frequency argument, just like picture one:
one.png
one.png (2.41 KiB) Viewed 1938 times
When I import excel data by using the following code:
wfopen d:\dpr.xls range="Sheet1!B2:C428" names=(purchase,redeem)
The frequency argument is disappeared, just like picture two:
two.png
two.png (1.71 KiB) Viewed 1938 times
How can I keep the frequency argument when I import excel data?
Thanks!

Re: keep the frequency argument when importing data

Posted: Mon Feb 29, 2016 9:19 am
by EViews Gareth
EViews obtains the frequency information from the Excel file. If there is no frequency information in the Excel file, EViews won't be able to find it, so you'll need to use the pagestruct command to impose it.

Re: keep the frequency argument when importing data

Posted: Wed Mar 09, 2016 10:06 pm
by gyw1028
EViews obtains the frequency information from the Excel file. If there is no frequency information in the Excel file, EViews won't be able to find it, so you'll need to use the pagestruct command to impose it.
Thank you very much :D