Get value of a variable

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.

image001.jpg

image002.jpg

image007.jpg

image008.jpg

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”

image001.jpg

image002.jpg

image007.jpg

image008.jpg

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

image001.jpg

image002.jpg

image007.jpg

image008.jpg

I assume you want to get values of variables declared in your workflow, e.g. like variable below
image

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