Question3Replies323Views×Close popoverHIJUNG LEE (HIJUNGL5) baml baml SG View ProfileSend Message HIJUNGL5 Member since 2017 1 post baml Posted: November 7, 2017Last activity: November 7, 2017Posted: 7 Nov 2017 5:27 ESTLast activity: 7 Nov 2017 22:33 EST 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: 3 years agoPosted: 7 Nov 2017 5:36 EST×Close popoverHIJUNG LEE (HIJUNGL5) baml baml SG View ProfileSend MessageHIJUNGL5 baml replied to HIJUNGL5 Posted: 3 years agoPosted: 7 Nov 2017 6:07 EST×Close popoverManas Rout (ManasR02) ANZ ANZ IN View ProfileSend MessageManasR02 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: 3 years agoPosted: 7 Nov 2017 22:33 EST×Close popoverHIJUNG LEE (HIJUNGL5) baml baml SG View ProfileSend MessageHIJUNGL5 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.