Import/read excel column as alpha series

[jsemeano]

Hello,

I am trying to attach the description and units to a group of series.

I would like to read the names of the series, descriptions and units from an excel file to 3 alpha series in an attribute change (to follow what's described in http://forums.eviews.com/viewtopic.php?t=4369).

The excel file looks as follows:
A B C
1 ser_1 desc_1 units_1
2 ser_2 desc_2
3 ser_3 desc_3 units_3

I have been trying with the import and read functions but so far haven't managed.

Could you please give me some guidance on how to do the import?

Thank you in advance.

[EViews Gareth]

Could you provide the file?

[jsemeano]

Yes

Book1.xls

series names and description example

(23.5 KiB) Downloaded 531 times

[EViews Gareth]

Assuming your data page is called "Untitled":

Code: Select all

pageload(page=attr) book1.xls colhead=1 pageselect untitled importattr(mode=overwrite, name=names) attr

[jsemeano]

Perfect. Cheers, Gareth