Prathamesh,
Of course but how do I get Currency in the second item? Currency is the value of row(“Variable”) and that value comes in the datatable and not the value of Currency.
Prathamesh,
Of course but how do I get Currency in the second item? Currency is the value of row(“Variable”) and that value comes in the datatable and not the value of Currency.
Dear Use variable in which those values are stored
EUR
15
2000
BE-NL
3 months
Prathamesh,
That is just the problem. I have the variable name in my excel and datatable. How can I use that name in the script?
I can put the name in an other variable but I can not get the value of that variable.
I can set a message box with “Currency” resulting in EUR, the value of Currency, but when I set row(“Variable”) , containing Currency, I get “Currency” and not “EUR”
That is because in your excel in Variable column Currency is present not EUR
Prathamesh,
But that is just the problem. In the excel in the “Variable” column you find all NAMES of the variables of my script.
Now I need a procedure to get the VALUE of these variables.
I import the excel in my script in to a datatable FieldsDT via a “read range”.
Then I’m going through the table with a “For each row” and display the result in a maessage box; but this only gives me the name of the variable not the value.
MessageBox” row(“Variable”) gives me the NAME not the VALUE
I assume you want to get values of variables declared in your workflow, e.g. like variable below
There is no simple way to get variable value by it’s name.
You would need to use some VB .NET code (specifically using System.Reflection) to achieve this.
Cheers