Read cell value from excel that contains a formula while you need the final value

Help
1

HI!
I have this problem wjen I extract excel cell value using read Cell activity. This specific cell contains string that is the result of a formula . I Get wrong value each time.
What to do ?
PS :I tried using “Conserve Format " property”.

2

I’m not sure why you get wrong value, read cell activity does exactly what it says, just read what is in the cell. If you want to get the formula, you would need read cell formula activity. Can you provide examples?

3

It s a business exception , I got it ! Thanks for help

1 Like