Ashley Winden (AshleyW5)
AshleyW5 Member since 2016 5 posts
Posted: January 28, 2020
Last activity: January 28, 2020
Posted: 28 Jan 2020 11:27 EST
Last activity: 28 Jan 2020 11:27 EST

Pega Robotics: Get formula text from filtered excel document

I am building an automation that needs to filter 3 columns of an excel document - after this is done only one row of the document should be remaining. In that remaining row, one of the cells contains a complex formula (picture of the structure of the formula is attached as formula.png) which contains a hyperlink that I need to parse out. I am able to filter the excel document and set the background color of the remaining cells in pink, and then get the range of the single remaining cell that contains a formula and highlight that in green. An image of the final filtered excel document is attached (excel.png) as well as the automation that I am using to filter the excel (automation.png). Now, I am looking to get the formula text from that final green range (rangeProxy5) so I can extract the link and launch it in a separate window/adapter. But, I can only seem to find methods that get the value from a specific cell (not formulas or hyperlinks). Is there any way that this can be done? Also when I hover over the cell it gives me the final concatenated hyperlink, is there any way I can get this value instead of having to concat the hyperlink together myself?

Robotic Process Automation
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.