Thanks for the info Anders! If you wanted to highlight the excel row after the data has been loaded correctly how would you do that? I've managed to get the first row to highlight but not the following rows.
Hey MyAdventureHat Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: th-cam.com/video/C6xmGfEL07I/w-d-xo.html Have a great day. Kind regards, Anders
Thank you for the videos. One question though, I have a excel containing list of url. I want them to open one by one. Did try assign a datatable value to a variable but don't know how to pass it to the open browser url field. I tried entering just the variable name but it does not work. Please help
Thank you for your feedback 😊 Use a For Each Row and within you can use a row.item("strYourColumnName".ToString to get the content of each row. E.g. place it in a Type Into or a Browser scope. Kind regards, Anders
Hi Jensen, once i get the result from web browser i want to copy into excel next column how do i do so? From your example, column A + Column B = Column C . I want to have the result in column C. Thank you!
Hi Anders, how would you edit this workflow to log in to a website several times using user ids and passwords in an excel sheet? Trying to do this for our time recording system at work, having issues passing arguments between workflows - ie for each row in the table, take the employee id, then pass that to the next workflow which is opening the timesheet and entering the employee id. Any tips?
Hey Whitevanqueen. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: th-cam.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
Hi Anders, I have a question. I want to read the excel sheet and then I want to loop through the data in that sheet, while looping, when I loop through the first row of main spreadsheet I want the process to enter spreadsheet1 and get some data, do some operations and get back to main worksheet, loop through second row and enter to spreadsheet2 get some data there do some actions and then get back to main spreadsheet and so on. I want this to happen for all the rows which has data in main worksheet. Can you help??
Hey Anu Negler Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: th-cam.com/video/C6xmGfEL07I/w-d-xo.html Have a great day. Kind regards, Anders
Hello Anders, I liked the video and replicated the same in my code but I am getting error "ui element not initialized". It is selecting the column values in the sheet but not displaying in web page as Set Text. Please let me know if you have any solutions.
Hey Purushottam Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or simply just hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: th-cam.com/video/C6xmGfEL07I/w-d-xo.html Have a great day. Kind regards, Anders
@@andersjensenorg thank you... But instead of workbook I used excel scope and for each and used infinite while loop to continuously repeat process and it worked
I created a process to execute on multiple excel rows using “for each row”. It works fine except that it doesn’t repeat for the next rows. The process involves submitting one form and then it loads another page after which I’m done with one row. I added an activity to go back to the first page after the first row tasks are done. However, it still doesn’t repeat. When I remove the form submission on page one, the process repeats for all rows (form filling of all rows on single page minus submission and second page activities). What do you think I’m missing here?
Hey Taranveer. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 26th of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: th-cam.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
I really appreciate you teach me a lot, I have already subscribe and like your videos. By the way, do you have any tutorial about passing data from one excel file to other excel file in "If then else" statement? As I want to get some data from one excel file and do some data filtering, then write to other excel file, I don't know how to define a variable to store the data from the excel file then pass to the new excel file. Would you please give me a hand?
Hey Leung. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: th-cam.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
Hi had one scenario will it possible to provide a solution plz 1.i had multiple excel files in data folder 2.how to read the multiple excel files as a transaction data table and transaction Item using Reframe work ..if possible can u make a video tutorials plz Thanks in advance
Hey Vasudevan. Check this REFramework tutorial, where I do transaction with a Data Table: th-cam.com/video/LP5y51_n6BY/w-d-xo.html Kind regards, Anders
If we have no 4 rows and and many columns if in some rows value is condersider as null sobthat we should keep the status as not eligible how should do in uipath .. can any one help me out
Hey Ramya Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: th-cam.com/video/C6xmGfEL07I/w-d-xo.html Have a great day. Kind regards, Anders
Hey DaddyAIZEN💜 Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: th-cam.com/video/C6xmGfEL07I/w-d-xo.html Have a great day. Kind regards, Anders
Hey BobforLyfe Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: th-cam.com/video/C6xmGfEL07I/w-d-xo.html Have a great day. Kind regards, Anders
Hey Dan Sumail Cannon Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: th-cam.com/video/C6xmGfEL07I/w-d-xo.html Have a great day. Kind regards, Anders
Check this playlist with all about Excel and Data Tables in UiPath: th-cam.com/play/PLXXz88_TPiHp_1N1pRURUpXnEt_quLyag.html
This is an awesome video!
Thanks a lot 🙌😎 Kind regards, Anders
+1 for specifying the column name, thanks!
Thank you, Alvin 😊
Hi Anders
Thanks for your excellent videos
Thank you, Vasudevan! 😊
Very Helpful ...!
You're very welcome, SUDERSHAN TIWARI - your support helps me a lot 😍
Thanks, very helpful
Hey Rosmyster. Thanks a lot for letting me know - it's really helping me a lot. Kind regards, Anders
Thanks for the info Anders! If you wanted to highlight the excel row after the data has been loaded correctly how would you do that? I've managed to get the first row to highlight but not the following rows.
Hey MyAdventureHat
Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: th-cam.com/video/C6xmGfEL07I/w-d-xo.html
Have a great day.
Kind regards,
Anders
Good Job :)
Hey Mar, thanks a lot :) Kind regards, Anders
Thank you for the videos.
One question though, I have a excel containing list of url. I want them to open one by one. Did try assign a datatable value to a variable but don't know how to pass it to the open browser url field. I tried entering just the variable name but it does not work.
Please help
Thank you for your feedback 😊 Use a For Each Row and within you can use a row.item("strYourColumnName".ToString to get the content of each row. E.g. place it in a Type Into or a Browser scope. Kind regards, Anders
Hi Jensen, once i get the result from web browser i want to copy into excel next column how do i do so? From your example, column A + Column B = Column C . I want to have the result in column C. Thank you!
Hey Harry. How's tricks in Mainframe? 😀 To target Column C, we have an assign with row.item("yourColumnCName") = "result" Kind regards, Anders
Hi Anders, how would you edit this workflow to log in to a website several times using user ids and passwords in an excel sheet? Trying to do this for our time recording system at work, having issues passing arguments between workflows - ie for each row in the table, take the employee id, then pass that to the next workflow which is opening the timesheet and entering the employee id. Any tips?
Hey Whitevanqueen. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: th-cam.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
Soo cool
Thanks a lot, Peter 😀👍
Hi Anders, I have a question. I want to read the excel sheet and then I want to loop through the data in that sheet, while looping, when I loop through the first row of main spreadsheet I want the process to enter spreadsheet1 and get some data, do some operations and get back to main worksheet, loop through second row and enter to spreadsheet2 get some data there do some actions and then get back to main spreadsheet and so on. I want this to happen for all the rows which has data in main worksheet. Can you help??
Hey Anu Negler
Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: th-cam.com/video/C6xmGfEL07I/w-d-xo.html
Have a great day.
Kind regards,
Anders
Hello Anders, I liked the video and replicated the same in my code but I am getting error "ui element not initialized". It is selecting the column values in the sheet but not displaying in web page as Set Text. Please let me know if you have any solutions.
Hey Purushottam
Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
I've created my UiPath Groups, where we all can post and solve problems or simply just hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: th-cam.com/video/C6xmGfEL07I/w-d-xo.html
Have a great day.
Kind regards,
Anders
Does it work if excel Is open in background and changing, please reply
Hej Suraj. Unfortunately not. Then you have to run it again :) Kind regards, Anders
@@andersjensenorg thank you... But instead of workbook I used excel scope and for each and used infinite while loop to continuously repeat process and it worked
@@andersjensenorg and thank you so much for your video, because of your videos I was able to fully automate my day stock trading with excel
I created a process to execute on multiple excel rows using “for each row”.
It works fine except that it doesn’t repeat for the next rows.
The process involves submitting one form and then it loads another page after which I’m done with one row. I added an activity to go back to the first page after the first row tasks are done.
However, it still doesn’t repeat. When I remove the form submission on page one, the process repeats for all rows (form filling of all rows on single page minus submission and second page activities).
What do you think I’m missing here?
Hey Taranveer. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 26th of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: th-cam.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
I really appreciate you teach me a lot, I have already subscribe and like your videos. By the way, do you have any tutorial about passing data from one excel file to other excel file in "If then else" statement? As I want to get some data from one excel file and do some data filtering, then write to other excel file, I don't know how to define a variable to store the data from the excel file then pass to the new excel file. Would you please give me a hand?
Hey Leung. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: th-cam.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
Hi had one scenario will it possible to provide a solution plz
1.i had multiple excel files in data folder
2.how to read the multiple excel files as a transaction data table and transaction Item using Reframe work ..if possible can u make a video tutorials plz
Thanks in advance
Hey Vasudevan. Check this REFramework tutorial, where I do transaction with a Data Table: th-cam.com/video/LP5y51_n6BY/w-d-xo.html Kind regards, Anders
If we have no 4 rows and and many columns if in some rows value is condersider as null sobthat we should keep the status as not eligible how should do in uipath .. can any one help me out
Hey Ramya
Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: th-cam.com/video/C6xmGfEL07I/w-d-xo.html
Have a great day.
Kind regards,
Anders
Great!
You're very welcome, uipath bachir - your support helps me a lot 😍
my uipath doesnt have .item() function. please help me on how i can get that
Hey DaddyAIZEN💜
Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: th-cam.com/video/C6xmGfEL07I/w-d-xo.html
Have a great day.
Kind regards,
Anders
Can u post a video on "Loop through rows adding in excel sheet"
Hey Piraisoodan, what do you mean by adding in excel sheet? Kind regards, Anders
thx , teacher
You're very welcome, Nick Sun - your support helps me a lot 😍
Do you know loop condition if there is no more excel sheets, stop the loop
Hey BobforLyfe
Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: th-cam.com/video/C6xmGfEL07I/w-d-xo.html
Have a great day.
Kind regards,
Anders
if it's date how do you do it
Hey Dan Sumail Cannon Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: th-cam.com/video/C6xmGfEL07I/w-d-xo.html Have a great day. Kind regards, Anders
Volumes of thanks.
Hey Sudershan. Thank you very much for taking you time to let me know 😊 Kind regards, Anders