Import string lists from excel

[morak5]

Hi,

I'm trying to create some string lists using lists of variables stored in an excel file.

For example in the attached excel file, I have a list of country names in the "Country" worksheet and sector names in the "Sector" sheet and I would like to create %country and %sector string lists in my workfile so that I can loop through them. There must be an easy way to do this, but I just couldn't figure it out.

Any tip would be much appreciated.

M.

Eviews Version: 8E

[EViews Gareth]

The only real way to do this is to open up those sheets as new pages in your workfile, bringing them in as alpha series. Then convert the alpha series to an svector (using @convert), then copy the svector over to your data page and loop through the elements of it.

[morak5]

I see. Many thanks, Gareth.