Page 1 of 1
Import text from Excel to string-variable
Posted: Wed Feb 18, 2009 12:53 am
by Jay
Hello, I want to import text-data from an excel-sheet to a string-variable, e.g. for assigning this text as a legend.
Is there any possibility to get this working with EViews 5.1 programming?
Re: Import text from Excel to string-variable
Posted: Thu Feb 19, 2009 12:16 pm
by jthodge
In the import dialog box or on the READ command, enter a "$" after the name of your alpha series.
Re: Import text from Excel to string-variable
Posted: Mon Feb 23, 2009 2:59 am
by Jay
That's not my problem, but how to get the text from the alpha series to an variable...
[edit]
As far as I've tested up to now, @elem(alpha, 1) generates a numeric value ... quite useless, when the content should be "UBS" or something.
Is there any similar function to @elem for my alpha series to extract a string from it?
Re: Import text from Excel to string-variable
Posted: Mon Feb 23, 2009 9:12 am
by EViews Gareth
try @elem(alpha,"1") (assuming your workfile is undated)
Re: Import text from Excel to string-variable
Posted: Tue Feb 24, 2009 3:06 am
by Jay
Yesterday I found out, that %string=alpha(1) works (the description was not that clear in the manual). But your hint works as well, though I don't understand, why the quotation marks are undocumented.