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.
