You're very welcome, Mihael Zivkovic - your support helps me a lot 😍 You're more than welcome at my Discord, where we're 5800+ RPA developers networking and solving problems: th-cam.com/video/xWFz-S96XGo/w-d-xo.html
HI! I currently keep watching your video because it is super easy to understand and make me understand the very basic of every function. Now i am still learning on this video tho, hopefully i can master it soon because it hink i am a slow learner huhuh. Good work for you, you did a great job here ! Give me even many people chance to understand better ! Very Useful! I am going to make you as my main source for learning uipath, thank you! Really appreciate your efforts here!
Haha, Shinta - I'm so glad to hear 🥰 You're very welcome on my Discord, where we solve UiPath problems and network: discord.gg/d8KQpTUvFD Kind regards, Anders
Hi Anders, thank-you for such clear videos. How can I change the Number Format of an entire column in an Excel sheet to Text? As a user, I would normally highlight the whole column, right-click and select the Format Cells command. I would then select Text from the Category panel in the Number Format tab of the Format Cells dialog. Many thanks in advance!
Hey Shaun. Then you can replicate that, but that seems like much of hard work for work shy people like you and me :D I would recommend reading it all into a DT, then iterate through it and write it back into the DT (the exact same data). Write it back to Excel and now we have it as text. Let me know, if that helps. You're also welcome on the Discord, where we solve problems and chat around UiPath and automation in general. Link is on my channel page. Have a great weekend. Kind regards, Anders
Hey Anders !. Your videos are very helpful for beginners. I want to know from where to learn basic dot net commands which will be helpful to learn in Automation. Thnx Nimi
Hi Andres, I am new to UiPath. And I had few queries regarding the read excel and write excel by row or column. Prior to that I worked for Pega RPA. Thank you for this video.
Hey Rakesh 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
hi Anders, May I know how to print out every column instead of using "row.item(2).ToString" from excel? If I got 20 column wanna output, it's quite stupid using "row.item(0).ToString + row.item(1).ToString + row.item(2).ToString etc..."
Thank you Anders, just a question. Is it posible to add a row in the same sheet (not adding a "Updated Data")? It will add the row whenever Uipath finds an empty row, I am not sure about this.. Thank you for your videos!! Manuel.
Hey Manuel, thank you 🙂 So you want to add a new empty row, if we reach an empty row in our For Each Row, we want to add a new empty row? Kind regards, Anders
@@andersjensenorg @Anders Jensen Sorry Anders, I may not explained correctly. I mean I do have a list in Excel what I fill in every day, adding new raws everyday, there won´t be empty row/cells, just want the next day keep filling the excel list with a new raw just below the row that was filled the day before. What do you think is the best way? Thank you so much for your answer! Regards, Manuel.
@@manuelcaballero5827 You could follow the steps Anders showed in the video, but when using the activity " Write Range", don't write in a new sheet, but rather in the sheet where your data currently are. All values will be overwritten.
Is it possible to make a video on UiPath determining expiration dates from one column in excel, finding the corresponding contractor email address found in another column then set up UIPath to email these contractors within a predetermined time (ex. 45 days before expiration date)?
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Hi Anders, thanks for the detailed explanations for every videos. I have a question about for each row function. I am trying to get some data tables from a website with using “each row” function and paste them into a sheet in an excel file. Related data tables' row quantity can change, some of them less than 10 rows the others can be more than 30 but columns are always same. Robot is working, but it’s pasting all datas one of the top of the other. So after process has finished, I can just get latest searched datas in related excel sheet. How can I manage that these results will come one under the other without overlapping?
Hey Mehmet. Thanks for the question and sorry for the late reply. 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
Thanks a lot for your wonderful instructions. I'm a beginner of uipath rpa and I've been learning many things thru your videos. Just one question. What is the most effective way to change header (colume names) by uipath? There are times when you get some data sheets from the internet using Extracting DT activity and you don't like the header, so you want to change it after or as soon as you generate an excel sheet using write range activity. How would you do it?
Hey WONSIK CHOI 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 yann 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 Decortec. 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
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 4900+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
HI Anders , I am beginner in RPA.Your video is very simple and useful. I am getting following error Error ERROR Validation Error Compiler error(s) encountered processing expression "DoubleParse(row.item("Total").ToString)>1000". 'DoubleParse' is not declared. It may be inaccessible due to its protection level. Main.xaml Pls. Reply
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 5800+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Is there a way, using uipath, to determine the location of the current cell? For example: if using filtered data, some rows are hidden and the row number will be unknown.
Hey Athena Ellis 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
Do you have a video to demp comparing two columns from excel 1 to two columns in excel 2 and updating excel 1 with data from excel 2 if match is found?
Hey mrsjaya. Thanks for the question and sorry for the late reply. 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
Hey ItsMe Chethan 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 Sern Chiew Han 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 Rohan. Great question. Because you want to keep the same syntax with the vb framework. E.g. when you want to change a cell with an assign, you need to both use the row and item to adress the correct cell. But if you fine can differentiate, by all means go for that 🙂 Kind regards, Anders
Man, this is better than UIPath Academy beginner wise
You're very welcome, Tom Cat - your support helps me a lot 😍
thanks! Now I figured out the Add Column! Keep up the great videos! They are really helpful!
Hey Tony, thanks a lot 🙂 I'm very glad reading your comments. Kind regards, Anders
Hi Anders, thank you for making so helpful videos!
You're very welcome, Mihael Zivkovic - your support helps me a lot 😍 You're more than welcome at my Discord, where we're 5800+ RPA developers networking and solving problems: th-cam.com/video/xWFz-S96XGo/w-d-xo.html
Thanks, Anders, a lot for your wonderful instructions. You make best videos!
Hey Анастасия. I really appreciate your support (it also help me to grow). Have a great day. Kind regards, Anders
HI! I currently keep watching your video because it is super easy to understand and make me understand the very basic of every function.
Now i am still learning on this video tho, hopefully i can master it soon because it hink i am a slow learner huhuh.
Good work for you, you did a great job here ! Give me even many people chance to understand better ! Very Useful!
I am going to make you as my main source for learning uipath, thank you! Really appreciate your efforts here!
Haha, Shinta - I'm so glad to hear 🥰 You're very welcome on my Discord, where we solve UiPath problems and network: discord.gg/d8KQpTUvFD Kind regards, Anders
Wonderful instruction! Thank you for your video.
Hey D Muirheid. Thank you very much 😊 Let me know, if you have ideas and/or questions for videos. Kind regards, Anders
These elaborations are so transparent and clear in understanding that i want to see more and more :) you tell it clearly and
understandable! Super!
Wow, thank you very much, Lukasz 😊
Thanks for the help!
My pleasure, Chris V 😊 Have a great weekend! Kind regards, Anders
Hi Anders, thank-you for such clear videos. How can I change the Number Format of an entire column in an Excel sheet to Text? As a user, I would normally highlight the whole column, right-click and select the Format Cells command. I would then select Text from the Category panel in the Number Format tab of the Format Cells dialog. Many thanks in advance!
Hey Shaun. Then you can replicate that, but that seems like much of hard work for work shy people like you and me :D I would recommend reading it all into a DT, then iterate through it and write it back into the DT (the exact same data). Write it back to Excel and now we have it as text. Let me know, if that helps. You're also welcome on the Discord, where we solve problems and chat around UiPath and automation in general. Link is on my channel page. Have a great weekend. Kind regards, Anders
Hey Anders !. Your videos are very helpful for beginners. I want to know from where to learn basic dot net commands which will be helpful to learn in Automation.
Thnx
Nimi
Thanks a lot, Nimisha! I'm so happy that you took your time to reply. Kind regards, Anders
Hi Andres, I am new to UiPath. And I had few queries regarding the read excel and write excel by row or column. Prior to that I worked for Pega RPA. Thank you for this video.
Hey Rakesh
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
hi Anders,
May I know how to print out every column instead of using "row.item(2).ToString" from excel? If I got 20 column wanna output, it's quite stupid using "row.item(0).ToString + row.item(1).ToString + row.item(2).ToString etc..."
Hey Leung. Sure. Use a Output DataTable, create output as string and then use a Write Line with the string. Kind regards, Anders
@@andersjensenorg Thx so much man.
Thank you Anders, just a question. Is it posible to add a row in the same sheet (not adding a "Updated Data")? It will add the row whenever Uipath finds an empty row, I am not sure about this..
Thank you for your videos!!
Manuel.
Hey Manuel, thank you 🙂 So you want to add a new empty row, if we reach an empty row in our For Each Row, we want to add a new empty row? Kind regards, Anders
@@andersjensenorg @Anders Jensen Sorry Anders, I may not explained correctly. I mean I do have a list in Excel what I fill in every day, adding new raws everyday, there won´t be empty row/cells, just want the next day keep filling the excel list with a new raw just below the row that was filled the day before. What do you think is the best way? Thank you so much for your answer!
Regards,
Manuel.
@@manuelcaballero5827 You could follow the steps Anders showed in the video, but when using the activity " Write Range", don't write in a new sheet, but rather in the sheet where your data currently are. All values will be overwritten.
@@cedricpendji4972 Thank you!!
@@cedricpendji4972 and if i just want to do not ecrase my data , i just want to add a new row everyday
Is it possible to make a video on UiPath determining expiration dates from one column in excel, finding the corresponding contractor email address found in another column then set up UIPath to email these contractors within a predetermined time (ex. 45 days before expiration date)?
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Hi Anders, thanks for the detailed explanations for every videos. I have a question about for each row function. I am trying to get some data tables from a website with using “each row” function and paste them into a sheet in an excel file. Related data tables' row quantity can change, some of them less than 10 rows the others can be more than 30 but columns are always same. Robot is working, but it’s pasting all datas one of the top of the other. So after process has finished, I can just get latest searched datas in related excel sheet. How can I manage that these results will come one under the other without overlapping?
Hey Mehmet. Thanks for the question and sorry for the late reply. 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
Thanks a lot for your wonderful instructions. I'm a beginner of uipath rpa and I've been learning many things thru your videos. Just one question. What is the most effective way to change header (colume names) by uipath? There are times when you get some data sheets from the internet using Extracting DT activity and you don't like the header, so you want to change it after or as soon as you generate an excel sheet using write range activity. How would you do it?
Hey WONSIK CHOI
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
thx ; but iwant to know how to ad a new column to the excel sheet when we add a new name
a new row
Hey yann
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.Q1: how can i make filter ondate in row but the filter must take the the date of the seme day i run the Robot.
Hey Decortec. 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
How do you suppress the message that says the data has been modified. This is when using the For each row in Data Table source? Thanks
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 4900+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
HI Anders , I am beginner in RPA.Your video is very simple and useful. I am getting following error Error
ERROR Validation Error Compiler error(s) encountered processing expression "DoubleParse(row.item("Total").ToString)>1000".
'DoubleParse' is not declared. It may be inaccessible due to its protection level. Main.xaml
Pls. Reply
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 5800+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Is there a way, using uipath, to determine the location of the current cell? For example: if using filtered data, some rows are hidden and the row number will be unknown.
Hey Athena Ellis 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
Do you have a video to demp comparing two columns from excel 1 to two columns in excel 2 and updating excel 1 with data from excel 2 if match is found?
Hey mrsjaya. Thanks for the question and sorry for the late reply. 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
I have a Question
How to automate the Azure data lake please make a tutorial on this it will help to us
need to create a folder and upload the file
Hey ItsMe Chethan
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, can you show me how to use auto increments in add data column.
Sure, what's the purpose of the auto increasements?
I can't find any excel option under activities, I searched online for the reasons why but I can't find anything. What should I do?
Hey nikos, check this: studio.th-cam.com/users/postUgkxD9AC7X3GLmEloN5J6iAdTEM1fXwXZ_sj/edit Kind regards, Anders
@@andersjensenorg Link is not working it goes to a blank page. Edit: I removed studio and edit in the end and its ok now. Thanks for your reply
Sorry, check this: th-cam.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgkxD9AC7X3GLmEloN5J6iAdTEM1fXwXZ_sj
could we delete the column we do not want?
Hey Sern Chiew Han
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
why to use row.Item("column_name")
If row("column_name") works
Hey Rohan. Great question. Because you want to keep the same syntax with the vb framework. E.g. when you want to change a cell with an assign, you need to both use the row and item to adress the correct cell. But if you fine can differentiate, by all means go for that 🙂 Kind regards, Anders
@@andersjensenorg Great! Thanks!