How to get the values instead of formulas

Help Studio
, ,
1

Hi ,
I have an excel and each cells contains formula ,
Using formula I performed calculation and add to add data row, I’m getting the value,
But when I’m storing that formula to a variable, I’m not getting values instead of that I’m getting formula.
eg: Var=“=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

Hello @Chippy_Kolot

You need to use the value from the data row instead of the formula. what you can do is after adding the data to datatable, then use that data to insert to database.

Thanks

3

In add data row itself we are providing formulas.