Search found 8 matches

by gkomba
Fri Jul 31, 2015 6:16 pm
Forum: Data Manipulation
Topic: Importing Multiple Excel Worksheets in EViews7
Replies: 13
Views: 11940

Re: Importing Multiple Excel Worksheets in EViews7

Dear Startz,

Thank you so much for your help. I have finally been successful.


My regards,

Gabriel
by gkomba
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?
by gkomba
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...
by gkomba
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...
by gkomba
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...
by gkomba
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...
by gkomba
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...
by gkomba
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...

Go to advanced search