Get cell address from Excel

[Digital_WorkerB]

I know how to count rows and columns, but how can I get the address of a cell (for example, J8)?

I need the address for the 'Get ws range as collection' object

Thanks

--------------------------------------------------
Disclaimer: This content was auto-posted from Stackoverflow. The original Stackoverflow question is here Stackoverflow Post, posted by Dylan.

[shashank.kumar280]

Hi,

You can use the Get Active Cell action to get a cell reference for the active cell.

------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------

[VivekGoel]

Hi,

try using the method mentioned in the post : https://rpatools.com/2019/05/blue-prism-find-any-value-inside-a-collection/

This could basically return the row and column index of a particular value inside a collection. Doing a bit of reverse engineering , you could be able to achieve what you nede

------------------------------
Vivek Goel
Submit Your Built solution for "The" RPACULT 2020- The Unique RPA Hackathon of 2020.
http://therpacult.com
------------------------------

[AndreyKudinov]

This is a automated crosspost from stackoverflow, you better answer there if you want Dylan to read your answer 🙂

------------------------------
Andrey Kudinov
Project Manager
MobileTelesystems PJSC
Europe/Moscow
------------------------------