How to get Cell reference or Cell Number along with cell value from datatable

[nilesh.mahajan]

Hello,

I am trying to get the cell reference for which I am getting value in For Each activity. Ex - If I get value from C2 cell then same time need to get Cell reference or cell number ie. “C2” also.
I have done below activity but not getting output.

[ushu (Usha kiranmai)]

@nilesh.mahajan Use can use loop up data table to get the index number

Lookup Data Table

May I know are you looking for any specific value in the data table

[fernando_zuluaga]

hey

check this

dt.Rows.IndexOf(CurrentRow).ToString

regards

[nilesh.mahajan]

Hello Fernando,

Thanx for reply, I have tried this already which gives me 0 (Zero) as output for each iteration.

[fernando_zuluaga]

hey

its working

it returns the index from each cell correctly

regards

[ushu (Usha kiranmai)]

@nilesh.mahajan Its giving as zero because you might be keeping getting that index value within the for each of CurrentRow.ItemArray . Try to get that index within the for each of Got_it_Template_Dt

[nilesh.mahajan]

Hello,

Actually my requirement is to get the cell reference/Cell Name like A2, B2 for which I am getting value from data table.

Ex. If Item.Tostring giving me output as “ABC” then I need the same cell reference as A2 because "ABC in A2 column.

then B2 need to show along with “xyz” because it is in B2 column

[supermanPunch (Arpan)]

@nilesh.mahajan

If Item.Tostring giving me output as “ABC” then I need the same cell reference as A2

@nilesh.mahajan , Here A2 Indicates that it is the A Column and 2nd Row.

To Get the Row Index, We can use the index Property from the For Each Row.

As your Workflow uses another For Each Activity to loop through the current row’s values, we should be able to use it’s Index to get the Column Name.

In the Message Box, Use the Below Expression and Check if it gets you the Column Name :

UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(idx+1)

Here, idx is the index value from the For Each Activity

Let us know what is the outcome

[fernando_zuluaga]

so you can filter if the value matches, then get the values from the new dt

regards

[ushu (Usha kiranmai)]

@nilesh.mahajan Did you try with this . For each row in data table activity has some property called Index

[Wong_Chee_Mun (Chee Mun)]

Is this the output you want?

[nilesh.mahajan]

Yes, I want index and cell reference.

[Wong_Chee_Mun (Chee Mun)]

For “Cell A”, I hard code the cell reference.
Im not sure if the Excel current cell name is able to retrieve.

[PALKUMARI_PATEL]

Do we need to download any package for this activity? @ushu

Can you help me on some excel query?

[ushu (Usha kiranmai)]

@PALKUMARI_PATEL Do you want to get the cell index along with the cell value from the data table ?

[PALKUMARI_PATEL]

just the cell index and based on that I want to update particular cell from other column .

IF I took the A3 value and processed on my website, IF process complete then some screen will appear which I am getting by Element exist inside that Element Exits if condition will update status of Column D3 “Completed”

Let me know if you need further more detail.

Thanks

[PALKUMARI_PATEL]

I’ve got this Solution by using Lookup Range activity. Thanks Though