I want to map data from excel to web

Help
,
1

I want to map data from excel to web and click it.
Example: I want set row after MM-YYYY in excel = Start date
and row before total = end date

then send 2 value to web and robot choose for click.

image

2

Is type ‘b’ input present in same sheet?

3

No, Type B don’t have in sheet excel
But in web have type a and b , I must robot shoud a check start date , end date and click item.

4

@fairymemay Can you Explain the Process in the Normal Manual way you do it, Then It will be Easier to understand :sweat_smile:

5

image

step1 set row after MM-YYYY in excel = Start date
step2 row before total = end date
step3 value from step1,2 send to web and robot click this.

6

@fairymemay Ok, Can you provide us the Input Excel?

7

rpa.xlsx (9.9 KB)

8

@fairymemay Can you provide the Website where the Date should be Mapped?

9

sorry, internal website.

10

@fairymemay ok, Can you tell me what will be there in website so that i can map values from Excel ?

11

It Webpage Dialog is show data table.
I click mouse in row by type=a , start date= value from excel , start date= value from excel

image

12

@supermanPunch Are you understand me?

13

@fairymemay I think i understood your process,I am trying to build the Workflow :sweat_smile:

14

@fairymemay Have you tried designing your process, if yes, please send me that workflow, so that I can understand more

15

@fairymemay Check this if this is what you wanted to have :sweat_smile: GetStartDateAndEndDate.zip (10.0 KB)

1 Like
16

yes.
And i want in web click row this.

17

Great Expression…Could you please explain how this works?

18

if i copy in my rpa it show.

image

19

@fairymemay Did you run my Workflow?

20

I run your workflow pass.
but i copy your workflow in my workflow , it error