xlsx to EViews

For requesting general information about EViews, sharing your own tips and tricks, and information on EViews training or guides.

Moderators: EViews Gareth, EViews Moderator

ecofin
Posts: 180
Joined: Fri May 10, 2013 11:24 am

xlsx to EViews

Postby ecofin » Sun Jul 29, 2018 7:16 am

Hi everybody
1/I have xlsx file named exchange_rate with three sheets named ( USD_DZD, EURO_DZD, GBP_DZD) from 01/01/2008 to 20/07/2018 every sheet have six columns (Date, Price, Open, Hight, Low, Change) and 2769 rows.
How can import the three sheets directly in my workfile with the three pages?. (all the sheets in the same time).

2/Suppose now i have three sheets named USD_DZD, EURO_DZD, GBP_DZD, every sheet have six columns:
sheet1 named: USD_DZD with six columns (Date, Price1, Open1, Hight1, Low1, Change1)
sheet2 named: EURO_DZD with six columns(Date, Price2, Open2, Hight2, Low2, Change2)
sheet3 named: GBP_DZD with six columns (Date, Price3, Open3, Hight3, Low3, Change3)
date (from 01/01/2008 to 20/07/2018)
How can import the three sheets in the same page in my workfile? (my workfile should contain 16 series.)
and happy holidays for everyone. :)

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 11850
Joined: Tue Sep 16, 2008 5:38 pm

Re: xlsx to EViews

Postby EViews Gareth » Sun Jul 29, 2018 11:56 am

Drag the Excel file onto EViews. On the first tab of the Excel import dialog, specify which sheet you want. You'll have to do it once for each sheet.
Follow us on Twitter @IHSEViews

ecofin
Posts: 180
Joined: Fri May 10, 2013 11:24 am

Re: xlsx to EViews

Postby ecofin » Sun Jul 29, 2018 12:52 pm

Oups! i missed this idea (Drag the Excel file onto EViews...etc), Thank you so much.


Return to “General Information and Tips and Tricks”

Who is online

Users browsing this forum: No registered users and 3 guests