Read Excel Formula

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.

Hi @Aupe

Check out this post

Read cell Issue

1 Like

hi

It has error
string converter cannot convert from system.double

@Aupe
could you please upload your workflow ?

1 Like

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

1 Like

Main.xaml (249.1 KB)

Data.xlsx (12.3 KB)

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

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 ?
image

TY.

Hey @Aupe

Can you try to use “Read Cell Formula” Activity

1 Like

I GOT IT TODAY,

in assign activity I wrote formula.
image

then call formula in Terminal Set Field at position
image

Thank you for your support and responses
Aupe

1 Like

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