I have to implement a complex excel validation loginc in UiPath. Instead of doing, I think if I can load excel filled with formula, puts my input data and get the new output data.
is there a way to load an excel filled with formula at run time, puts some value in specific Column and retrieve the formula calculated other column value at Run time.
I am having few formula/logic for input data number in an excel. Like If No of Occurance 13. It falls on 10-20 Bracket. And I am validating all 13 records programmatically. Now If 4 out 13 are failed I will be taking additional occurrence based on excel formula and will validate again.
Pls suggest right approach to do this.