Dear Startz,
Thank you so much for your help. I have finally been successful.
My regards,
Gabriel
Search found 8 matches
- Fri Jul 31, 2015 6:16 pm
- Forum: Data Manipulation
- Topic: Importing Multiple Excel Worksheets in EViews7
- Replies: 13
- Views: 11940
- Fri Jul 31, 2015 5:02 pm
- Forum: Data Manipulation
- Topic: Importing Multiple Excel Worksheets in EViews7
- Replies: 13
- Views: 11940
Re: Importing Multiple Excel Worksheets in EViews7
how do i get to the program window please?
- Fri Jul 31, 2015 4:48 pm
- Forum: Data Manipulation
- Topic: Importing Multiple Excel Worksheets in EViews7
- Replies: 13
- Views: 11940
Re: Importing Multiple Excel Worksheets in EViews7
Okay Gareth, This is how I wrote the code. open "C:\Users\HUBS\PhD HULL MAIN\Market Efficiency and Corporate Governance\Behavioural Finance\Chapter 4_Herding\data\demo.wf1" import "C:\Users\HUBS\PhD HULL MAIN\Market Efficiency and Corporate Governance\Behavioural Finance\Chapter 4_Her...
- Fri Jul 31, 2015 3:13 pm
- Forum: Data Manipulation
- Topic: Importing Multiple Excel Worksheets in EViews7
- Replies: 13
- Views: 11940
Re: Importing Multiple Excel Worksheets in EViews7
You don't need 1. and 2. They do nothing. %names = @tablenames("Demo kn_p kn_cap.xlsx") %n = @word(%names,1) wfopen "Demo kn_p kn_cap.xlsx" range=%n for !i=2 to @wcount(%names) %n = @word(%names, !i) import "Demo kn_p kn_cap.xlsx" range=%n next Gareth- I first tried th...
- Fri Jul 31, 2015 1:37 pm
- Forum: Data Manipulation
- Topic: Importing Multiple Excel Worksheets in EViews7
- Replies: 13
- Views: 11940
Re: Importing Multiple Excel Worksheets in EViews7
Dear Gareth, I am stuck again. I decided to practice using your data on "Re: How to enter data into a panel workfile" posted on Fri Jan 08, 2010 3:04 pm, but could not generate any output. This is how I wrote the program %filename=C:\Users\HUBS\sheetpanel.xlsx %sheetnames = @tablenames(&qu...
- Fri Jul 31, 2015 10:09 am
- Forum: Data Manipulation
- Topic: Importing Multiple Excel Worksheets in EViews7
- Replies: 13
- Views: 11940
Re: Importing Multiple Excel Worksheets in EViews7
Hello Gareth, Below are the steps I have done so far: 1. wfcreate(wf=demo) d(1-5) 12/31/1999 7/15/2015 2. wfsave "C:\Users\HUBS\PhD HULL MAIN\Market Efficiency and Corporate Governance\Behavioural Finance\Chapter 4_Herding\data\demo" 3. wfopen "C:\Users\HUBS\PhD HULL MAIN\Market Effic...
- Fri Jul 31, 2015 9:50 am
- Forum: Data Manipulation
- Topic: Importing Multiple Excel Worksheets in EViews7
- Replies: 13
- Views: 11940
Re: Importing Multiple Excel Worksheets in EViews7
Hi Gareth, Thanks for the quick response, it has worked out. However, my other issues was how to import multiple worksheets into a sing WF page. I have seen in one of your responses of Tue May 21, 2013 8:11 am; "Re loading multiple worksheet excel files programatically" that: ..........&qu...
- Fri Jul 31, 2015 8:14 am
- Forum: Data Manipulation
- Topic: Importing Multiple Excel Worksheets in EViews7
- Replies: 13
- Views: 11940
Importing Multiple Excel Worksheets in EViews7
Hi, I have never used the command window before when importing data from excel to EViews. I have learnt that there is a way of importing several worksheets at a go in EViews user forum, but failed to follow the commands provided by the contributors. What I need is to upload all excel worksheets into...
