converting excel file into workfile

[oykuyel]

Hello,
I have a monthly CPI data from 2003 to 2013 in excel I want to create a workfile in Eviews but I fail. First of all, when I open the excel file in eviews and create the data, workfile contains every year seperately. But I need only one file combined each year with each month because when it comes to estimate, I want to estimate 2003-2013 but it shows 2003sep-2003dec. So I don't know what to do. I tried to organize excel file but the same problem happens every time when i open it in eviews. How can i fix this problem?
Thx in advance

[EViews Gareth]

Can be done interactively or programmatically. Here's the program code:

Code: Select all

wfopen cpi.xlsx pagestack january february march april may june july august september october november december alpha date = var01 + " " + @str(series01) pagestruct @date(@dateval(date)) rename var02 cpi d id01 series01 var01 date pagedelete cpi