Read Excel Formula

Aupe · April 13, 2019, 2:32am

I’m using Terminals Activities

in my Excel I have Formula which calculate The Discounted Price.
It has error when I call the Specific cell,

He only read the cell but Formula not.

ty.

Lahiru.Fernando · April 13, 2019, 3:18am

Check out this post

Aupe · April 13, 2019, 3:40am

hi

It has error
string converter cannot convert from system.double

rahatadi · April 13, 2019, 3:49am

@Aupe
could you please upload your workflow ?

Lahiru.Fernando · April 13, 2019, 3:53am

So you are trying to get the number value of the calculated field right? Can you show me the properties of that activity…

Aupe · April 13, 2019, 4:36am

Main.xaml (249.1 KB)

Data.xlsx (12.3 KB)

Please see File below
go to Navigate JDA → Discount → then Excel Application Scope

Aupe · April 13, 2019, 8:19am

i change the flow of my Project
where i will Implement formula in Write Cell
What if i do this
EXAMPLE : ((D * E) - F)

basecount = 12
D = “D”+basecount.ToString
E = “E”+basecount.ToString
F = “F”+basecount.ToString

How to do this in write cells ?

TY.

Purvi · April 13, 2019, 3:26pm

Can you try to use “Read Cell Formula” Activity

Aupe · April 15, 2019, 4:01am

I GOT IT TODAY,

in assign activity I wrote formula.

then call formula in Terminal Set Field at position

Thank you for your support and responses
Aupe

system · April 18, 2019, 4:01am

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.