Data conversion from Excel

[terrya]

I'm using EV8.

I have data in an Excel table that has Years in rows and Months in columns. Currently, there are 1203 observations.

Is it possible to import this data and convert it into a time series in a single column?

At present, I save it as a text file (just the raw data) and import this to EV. This works but is annoying as I would like to write a programme that imports the data straight from Excel and convert it to the single column, enabling me to process it further.

[EViews Gareth]

Code: Select all

wfopen monthyear.xlsx @rename * m_* pagestack m_? alpha yearmonth = @str(year) + "/" + var01 series date = @dateval(yearmonth, "YYYY/MONTH") pagestruct @date(date)

[terrya]

Thanks