A question about circular entry of Excel data

Help Studio
, ,
1

How to realize the functions in the video? I cyclically input the data in Excel. I searched all the tutorials but could not find a solution. I hope you can help me solve it, thank you.

1 Like
2

Hey @Uddynitjh

I understood like, You want to enter data in Excel row by row.

Is that the requirement pls ?

Thanks
#nK

3

Yes, enter the data in Excel line by line

1 Like
4

Cool @Uddynitjh

Yes possible.

You can just use a foreach loop to achieve the same by placing write excel actions inside loop.

Else you can first form the data table and finally write it back to excel.

Thank you
#nK

5

I use For Each to traverse the data and enter the data in Excel, but it only loops in the first cell. I don’t know what went wrong. Thank you.

1 Like
6

Any screenshots please for better understanding ?

7

image
image519×617 53 KB

This is my process.

1 Like
8

Ok clear.

Check in the selector is there any row no… It should be thr

You need to use it dynamically by replacing the value with a variable.

Thanks
#nK

9

I don’t quite understand. Can you send a flow picture? thank you very much.

1 Like
10

Could you please show the selector of the type into ?

11

image
image1002×776 87.5 KB

Is this it?

1 Like
12

Yes, Kindly open in Ui-Explorer please…

Thanks
#nK

13

image
image1600×786 186 KB

Is this it? Please forgive me for just getting in touch with uipath.

1 Like
14

Hey @Uddynitjh

I can completely understand. Don’t worry please…

That’s why we are here :slightly_smiling_face:

Yes you are in the right direction. So when you highlight this selector which row it is highlighting

Thanks
#nK

15

It highlights the place I chose, that is, because I chose that input box, it has been entered in that input box.

1 Like
16

Clear, Is it directly a input box or you click on the table cell to make that input box appear on the screen ?

17

It clicks before typing. I think the problem is the loop, but I don’t know how to do it.

1 Like
18

Test data.xlsx (8.4 KB)

Web:Test web page-表单大师

Can you test it? Fill the Excel data into the web page in order, thank you @Nithinkrishna

1 Like
19

Hey @Uddynitjh

Hope this helps you.

WebDataEntryLoop_09012022_1444.zip (9.5 KB)

This depicts the same as you need, read excel and enter all the row data into the web app.

Thanks
#nK

20

Great!!! You solved my problem perfectly!!! I really appreciate your help. This problem has bothered me for many days. You are wonderful!!! @Nithinkrishna

1 Like