topic RE: Get cell address from Excel in Product Forum

Get cell address from Excel

Digital_WorkerB — Tue, 03 Nov 2020 09:00:00 GMT

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.

RE: Get cell address from Excel

shashank.kumar280 — Tue, 03 Nov 2020 09:47:00 GMT

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
------------------------------

RE: Get cell address from Excel

vivek.kumar.goel — Thu, 05 Nov 2020 04:45:00 GMT

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
------------------------------

RE: Get cell address from Excel

AndreyKudinov — Thu, 05 Nov 2020 16:14:00 GMT

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
------------------------------