(Pega Robotics Studio) Excel formual and some other questions ?
Hi, I've tried to refer the help link but it's not detail enough so, hope someone can please help ?
as explained above :
Q1) for case 1 - how can we run formula & SetCellValue looping for all rows ?
Q2) for case 2 - filtering out above case, and then => open another excel and lookup, only when D is specific value ?
Q3) for case 4 - filtering out above case, and then => how to launch specific apps (that's not built in the studio, it's our own internal apps), go to specific UI, and search for D ?
understand that we can use macro for Q1,Q2 but we're not allowed to use excel macro - Thanks for the prompt advice in advance.
***Updated by moderator: Lochan to add Categories***