How can i get the relative-position-cell vlaue？

Ask in Your Language 中文
1

image
Like this Excel.
I want to find the “bowl” , then i want to change the “price”.
If i use For Each activity, For Each rows,I can only get the different column in the same row like changing the ID,but i can’t change the Price at next row.
How can i jumping column+2 and jumping row+1 at the same time?

2

Hi @lipenghui

u can give row.item(0).tostring.contains(“bowl”)

Based on this you can set the value

Thanks
Ashwin S

3

@AshwinS2
no,i want to get the row(0) column(1),and jumping the cell to change the row(1) column(3).
you can see the picture. “Item name” and “Price” not only at different Row,but also at the different Column.

4

hello @lipenghui
Please find the below attachment
ExcelTask.xaml (17.3 KB) Test.xlsx (8.6 KB)

5

@vickydas
It’s what i want,my problem solved.
Thank you for your help. :smiley:

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.