Put a value from an Excel cell in a weblist

Help Activities
, ,
1

Hi guys,

I want to put a value from an Excel cell in a weblist. In the flow, I open the excel file,read the cell,open the list on the site but I can’t put the value in.

image

For example : if the value is " 18 - CHER" , I want to choise “18 - CHER” in the list.

You can help me.

Thanks Alex.

2

Try to use Macro for it

3

Hi @Al_Bert
which activity did u tried for this ?

4

I tried select item. But nothing.

5

A Macro?

6

Did it thrown any error ?

7

no, in fact, I don’t know to do it.

8

Use select item activity and pass the value in select item which u need to select. If select item won’t work, use click actvitie to achieve that

9

Yes I used the select item activity but how do I do to put my selection from Excel cell?

10

Hi @Al_Bert
for example

you got the data from excel and store in a variable ex1, now in select item actvity, put this variable where u had to provide the option u need to select.

Hope it helps you

Regards,
Nived N
Happy Automation

11

Hi Nived,

I did that:

image
image1076×514 21.3 KB

But that didn’t resolve my problem.

12

@Al_Bert
you have to use ReadDataDt.Rows(0).ToString
Or
You have use foir each row activity and it will go on selecting the next item currentRow(0).ToString

1 Like
13

I find the solution :
image

Thanks a lot for you help guys.

1 Like
14

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