navvigate to excel cell dynamically using blue prism

[soraj]

Hi,
I need to get a particular cell value from an excel sheet. I can not pass the cell address directly as it may vary from sheet to sheet. But the cell is always the bottom right cell, and has a complete blank row and column around it. Can you give any ideas how to reach that cell and get the cell value?

 

[RavitejaKiran]

Hi Soraj,

As per my understanding you want to get a cell value which is at the bottom row of a sheet but wanted to know which cell it is to get the value.
If it is so .

1. Get Data into Collection.
2. Reverse the collection.
3. Copy first row into a temp collection.
4. Now Transpose the temp collection and remove empty rows.

which will leave only one cell which has value and that value is what you require.

Please let me know if that worked.

 

[soraj]

No actually there are more values in cell after the blank rows and columns.View attachment Capture.PNG
Here i want to get the bottom most value 0.00% in a data item.

 

[RavitejaKiran]

Hi Soraj, Which 0.00% you are trying to get? The one beside 35,002 value? or the one beside 1,379,630?

If it is beside 1,379,630, will it have only one empty row above it as shown in the pic?

 

[soraj]

yes the one beside 1,379,630. see this is the complete pic. and the sheet is having multiple data like these.View attachment 1550568614081.png