Question3Replies307Views HIJUNGL5 Member since 2017 1 post baml Posted: 2 years agoLast activity: 2 years 10 months ago Closed (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*** Robotic Process Automation ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question. Posted: 2 years agoHIJUNGL5 baml replied to HIJUNGL5 Posted: 2 years agoManasR02 ANZ replied to HIJUNGL5Hi, This is easier to do in a .net. I suggest write this logic in .net component and use that in OpenSpan use excel.interop Regards, Manas Posted: 2 years agoHIJUNGL5 baml replied to ManasR02so you mean, in Pega - there's no way to do so in itself ..? if so, it's a surprise actually. we'd like to avoid the case to involve another hidden layer of code/logic.