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.
xlsx to EViews
Moderators: EViews Gareth, EViews Moderator
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: xlsx to EViews
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
Re: xlsx to EViews
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 15 guests