How can we assign a formula to a variable

Help Studio
, ,
1

Hi ,
I have an excel template and each cells contains formula ,
eg: 1) C= “=A”+cell.Tostring+“*B”+cell.Tostring,
2) D= “=B”+cell.Tostring + “=C”+cell.ToString
In add data row { “=A”+cell.Tostring+“*B”+cell.Tostring, “=B”+cell.Tostring + “=C”+cell.ToString}
So while writting to excel I’m getting proper value.

But if I’m assigning that formula to a variable ,in message box I’m getting formula only instead of value.
eg: data= “=A”+cell.Tostring+“*B”+cell.Tostring,
message box:
eg:“=A”+cell.Tostring+“*B”+cell.Tostring.

I have passed the same formula to sql query I have to enter that value to database then also formulas are getting in the table.
Can any one help me to fix this issue.

2

Hi @Chippy_Kolot

Are you passing the formula to variable? If yes then variable will have formula only…it wont have a values as that formula pertains to excel…

Can you show thw workflow that you are trying to execute and also the input and output that provides more details on what you need and what is happening

Cheers

4

Sorry I cant post workflow here, its confidential.

5

Hi @Chippy_Kolot

If you want the value to be in the variable…you can try like this…after writing the formula to excel use a read cell value activity to get the value that is calculated in excel and same value can be used to post in datatable as well

Cheers