Importing data from an xlsx file
Posted: Mon Apr 09, 2018 9:56 am
I want to write a program file that imports time series data from an excel (xlsx) file, but am having problems with how I write the command in the program. I understand that I need to use the import command, but could someone tell me the exact command that I need to use.
- the data is in a file called test.xlsx
- columnn A has the date (annual data from 1990 to 2017)
- columns B to BF contains the data (i.e. 57 data series)
- Rows 1 and 2 have text describing the data in each column
- Row 3 has the series name (a short text name of between 3 and 6 digits) that I want to use in eviews
I have managed to get the import command to work and read some of the data into a work file. HOWEVER:
- it only reads in some of the data (I don't know what or where the argument goes, to say that I want it to read in 57 series (or all the series in the file)
- it seems to assign what's in row 2 as the series title (which is a very long text description of the data). I want it to use the 3 - 6 digit name I've given in row 3, but don't know what I have to use to do this.
Thank you, in advance, for your assistance!
I'm using eviews 8
Chris
- the data is in a file called test.xlsx
- columnn A has the date (annual data from 1990 to 2017)
- columns B to BF contains the data (i.e. 57 data series)
- Rows 1 and 2 have text describing the data in each column
- Row 3 has the series name (a short text name of between 3 and 6 digits) that I want to use in eviews
I have managed to get the import command to work and read some of the data into a work file. HOWEVER:
- it only reads in some of the data (I don't know what or where the argument goes, to say that I want it to read in 57 series (or all the series in the file)
- it seems to assign what's in row 2 as the series title (which is a very long text description of the data). I want it to use the 3 - 6 digit name I've given in row 3, but don't know what I have to use to do this.
Thank you, in advance, for your assistance!
I'm using eviews 8
Chris