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.
April 11, 2022, 6:19am
@nilesh.mahajan Use can use loop up data table to get the index number
May I know are you looking for any specific value in the data table
Thanx for reply, I have tried this already which gives me 0 (Zero) as output for each iteration.
it returns the index from each cell correctly
April 11, 2022, 6:38am
@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
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
@nilesh.mahajan , Here
A2 Indicates that it is the
A Column and
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 :
idx is the index value from the
For Each Activity
Let us know what is the outcome
so you can filter if the value matches, then get the values from the new dt
April 11, 2022, 7:06am
@nilesh.mahajan Did you try with this . For each row in data table activity has some property called Index
Is this the output you want?
Yes, I want index and cell reference.
For “Cell A”, I hard code the cell reference.
Im not sure if the Excel current cell name is able to retrieve.
Do we need to download any package for this activity?
Can you help me on some excel query?
July 3, 2022, 7:03am
@PALKUMARI_PATEL Do you want to get the cell index along with the cell value from the data table ?
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.
I’ve got this Solution by using Lookup Range activity. Thanks Though