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?
Import text from Excel to string-variable
Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason
Re: Import text from Excel to string-variable
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
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?
[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?
-
EViews Gareth
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13600
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Import text from Excel to string-variable
try @elem(alpha,"1") (assuming your workfile is undated)
Re: Import text from Excel to string-variable
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.
Who is online
Users browsing this forum: No registered users and 2 guests
