Importing attributes from excel

[jtb35962]

I am attempting to import attributes from Excel. I read that it is possible using importattr, but upon cursory attempts from reading the help options after importing a second work file with potential attributes, I cannot correctly use the command box make it work. This is likely do to my inexperience. Are there any tutorials or example programs to do this?

[EViews Gareth]

No, but if you post your files I'm sure we can help out.

[jtb35962]

Should I provide an example file instead? This is for making databank updates for IHS markit.

[EViews Gareth]

Whatever you're comfortable with.

[jtb35962]

I have included a test file and the associated excel. I am not sure that the excel is set up correctly, but it is a start.
Thanks

[jtb35962]

I update these and others monthly and even more series quarterly, so I need to replicate the process regularly and on a large scale.
They key is replicating something similar to Aremos banks that data can digest. Mnemonics, data update and other attributes updated.
Thanks

[EViews Gareth]

Just using this Excel file:

Code: Select all

'open the data, ignoring the attribute rows
wfopen cpwbank_2016_12b.xlsx colhead=5 namepos=first

'open the attribute as a second page
pageload(page=attr) cpwbank_2016_12b.xlsx range=sheet2!b1:pe5 byrow colhead=0 names=(name, bank, dataedge, forecastdate, longlabel)

'switch back to data page
pageselect cpwbank_2016_12b

'import attributes
importattr attr


[jtb35962]

Thank you very much. This looks like it is working and I should be able to replicate this code easily to other properly formatted excel files.
I will send a test file to the data group soon. I think this is what they are hoping to receive.
Thank you again!