Assign cell value to variable

Help
1

hello there…
I want to assign particular cell to my variable
propID :- Cell “E18”
name :- E19"
I tried to use index of it taking whole
there is possibility to each cell may not have that cell data so i want to assign that cell no whatever value is there…

image
image1270×546 19.9 KB

in above img steps contain detail and testdata values i have to assign to my variable step 1&2 dont have testdata

2

@prashantP Have you tried with read cell activity

3

hey thanks for quick replay…

no havent try it can you pls explain brief??
how I can select cell no E18,E19,E21

4

@prashantP There is read cell activity you can use that and pass cell range in that activities

image

1 Like
5

Great…
so every time I have to use excel scope + read cell + assign to variable
similar to below pic ?

image
image494×571 10.6 KB

6

@prashantP If cell range does not change means than you can use read cell activity

7

Cell range is fixed…
thank you so much… :pray:

on more suggestion pls…

instead of using separate cell for each value.
what if I separate them by “,” in one cell ??
what activity should i use ?
and how?

8

@prashantP By comma it wont works you needs to use separate read cell activity

1 Like
9

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