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.
Hey @Uddynitjh
I understood like, You want to enter data in Excel row by row.
Is that the requirement pls ?
Thanks
#nK
Yes, enter the data in Excel line by line
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
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.
Any screenshots please for better understanding ?
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
I don’t quite understand. Can you send a flow picture? thank you very much.
Could you please show the selector of the type into ?
Yes, Kindly open in Ui-Explorer please…
Thanks
#nK
Hey @Uddynitjh
I can completely understand. Don’t worry please…
That’s why we are here
Yes you are in the right direction. So when you highlight this selector which row it is highlighting
Thanks
#nK
It highlights the place I chose, that is, because I chose that input box, it has been entered in that input box.
Clear, Is it directly a input box or you click on the table cell to make that input box appear on the screen ?
It clicks before typing. I think the problem is the loop, but I don’t know how to do it.
Test data.xlsx (8.4 KB)
Can you test it? Fill the Excel data into the web page in order, thank you @Nithinkrishna
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
Great!!! You solved my problem perfectly!!! I really appreciate your help. This problem has bothered me for many days. You are wonderful!!! @Nithinkrishna