A very good video, Anders If you can please to update your videos to the new version of UiPath Studio because is pretty different from the version you have here. Thank you for your work
Thank you for this content! I got a question: How do I change/update a formula from all cells in a sheet? I used the Find/Replace but is not allowing to change the text from Excel formula and in Excel comments. Thank you in advance Jens and more power!
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 10,000+ 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
Hey HengeNaavu TV 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 very much for all the valuable videos. I am looking for excel operation where I need to remove a part of text in columns and replace. Ex: if a column has text "LOAD ABCD", I want to remove the word LOAD and keep ABCD. This for all the cells in the column. Is it possible? Thank you very much.
Hey Vrunda. I made a UiPath book guide once and the best book to understand the coding language (VB.NET) in UiPath is definately this, amzn.to/3d2x3NE To strings in UiPath, I have made this th-cam.com/play/PLXXz88_TPiHrsQDDFImamh94ULuGF9G3b.html and I made 4-5 videos about files/folders. So now I managed to answer your questions without giving you an answer (providing you with articles) 😏 I hope it helps anyway. Kind regards, Anders
Any suggestions on how to change values of cells on grids in Windows Forms? I don't see anything online. Everything is about Excel. If i have a two columns, how do i copy one value from one cell column to the adjacent column next to it? The rows will vary. Some will have 1 row other 20+. I had hoped i could use arrow keys but it said there was a scope issue. Thanks
Hey K Stevenson. I never used Windows Forms, but I assume it's .NET based. Can you use UI activitives? Then I would just: Get Text, Output it to a string in properties, then use a Type Into and type the string, where you want it. Let me know, if thats possible? If yes, we can easily make a loop :) Have a great day. Kind regards, Anders
@@andersjensenorg I so appreciate your giving me feedback. So with GetText you have to Indicate on screen. If i don't, Get Text gives me an error when i run it. How do get the text when i move to the next cell below the current number? There could be N number of rows. What i was trying to do was tie it to the row count and use arrow keys. But if i copy and paste, i don't know how to get the copy into a variable. Thanks so much.
Is there any easy way using the DataTable.Rows assign that you used, to instead of just filling one row with DataTable.Row(0), to fill all all of the rows in that column with the same string?
Hey Jesse. You can make a 'For Each Row' of your DataTable and simply just use an assign, where row.item("NameOfYourColumn") = "SameString". Does that make sense? Kind regards, Anders
@@andersjensenorg Thanks that's great. Question, if I have a column that is dates but showing up as numbers, is there an easy way to change the whole column to the date format?
Hey Tana Storm 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 Muhammad Zuhairi 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
How can I find a specific value in row and them delete the cell to shift the cell up? Eg- I want to find text Zone in the row , once found I want to delete the cell and shift the remaining cells up.
Hey Prateek. 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
A very good video, Anders If you can please to update your videos to the new version of UiPath Studio because is pretty different from the version you have here. Thank you for your work
Hey Andrei. Thanks a lot. I will update it this week :) Kind regards, Anders
Thank you for this content!
I got a question: How do I change/update a formula from all cells in a sheet? I used the Find/Replace but is not allowing to change the text from Excel formula and in Excel comments.
Thank you in advance Jens and more power!
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 10,000+ 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
very good! saved me again! Thank you very much for the explanation, best regards.
You're very welcome, Fernando Galvao - your support helps me a lot 😍
Hi , how can I enter the data of some output into excel without overwrite.
Data should write in A1 A2 accordingly
Hey HengeNaavu TV
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
@@andersjensenorg thank you sir
I wish.. you do videos on real time scenario.
Hey Ponna. That is not a bad idea. Why do you think it is better? Just curious ☺ Kind regards, Anders
@@andersjensenorg your doing well. It would be helpful us to know realtime environments of uipath
Thank you! I like your videos!
Hey Анастасия. Thanks for the outstanding support you're showing me. Kind regards, Anders
Thank you very much for all the valuable videos. I am looking for excel operation where I need to remove a part of text in columns and replace. Ex: if a column has text "LOAD ABCD", I want to remove the word LOAD and keep ABCD. This for all the cells in the column. Is it possible?
Thank you very much.
Hey Raja. You can do "LOAD ABCD".Replace("LOAD ",""). Check the Replace method here: th-cam.com/video/1Rs6WfSk7p8/w-d-xo.html Kind regards, Anders
Thank you very much Anders
Can you please suggest good articles related to string functions and files/folders?
Hey Vrunda. I made a UiPath book guide once and the best book to understand the coding language (VB.NET) in UiPath is definately this, amzn.to/3d2x3NE To strings in UiPath, I have made this th-cam.com/play/PLXXz88_TPiHrsQDDFImamh94ULuGF9G3b.html and I made 4-5 videos about files/folders. So now I managed to answer your questions without giving you an answer (providing you with articles) 😏 I hope it helps anyway. Kind regards, Anders
Any suggestions on how to change values of cells on grids in Windows Forms? I don't see anything online. Everything is about Excel. If i have a two columns, how do i copy one value from one cell column to the adjacent column next to it? The rows will vary. Some will have 1 row other 20+. I had hoped i could use arrow keys but it said there was a scope issue.
Thanks
Hey K Stevenson. I never used Windows Forms, but I assume it's .NET based. Can you use UI activitives? Then I would just: Get Text, Output it to a string in properties, then use a Type Into and type the string, where you want it. Let me know, if thats possible? If yes, we can easily make a loop :) Have a great day. Kind regards, Anders
@@andersjensenorg I so appreciate your giving me feedback. So with GetText you have to Indicate on screen. If i don't, Get Text gives me an error when i run it. How do get the text when i move to the next cell below the current number? There could be N number of rows. What i was trying to do was tie it to the row count and use arrow keys. But if i copy and paste, i don't know how to get the copy into a variable. Thanks so much.
I subscribed to your channel thanks! Ok, i got GET FROM CLIPBOARD ACTIVITY!!!
Is there any easy way using the DataTable.Rows assign that you used, to instead of just filling one row with DataTable.Row(0), to fill all all of the rows in that column with the same string?
Hey Jesse. You can make a 'For Each Row' of your DataTable and simply just use an assign, where row.item("NameOfYourColumn") = "SameString". Does that make sense? Kind regards, Anders
@@andersjensenorg Thanks that's great. Question, if I have a column that is dates but showing up as numbers, is there an easy way to change the whole column to the date format?
Sure. In Excel or a Data Table in the memory of a UiPath process?
@@andersjensenorg Data Table in the memory of a UIPath process please!
Thanks for your videos! ❤️ Question: How can I detect cells that exceed the length limit (example 6 characters) and remove those rows? 🤔
Ex: ext.Length > 10
Hey Tana Storm
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
Nice video sir, I want ask something, how do I delete the value from specific cells and columns in excel? thanks in advance.
Hey Muhammad Zuhairi
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
How can I find a specific value in row and them delete the cell to shift the cell up?
Eg- I want to find text Zone in the row , once found I want to delete the cell and shift the remaining cells up.
Hey Prateek. 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 sir
You're very welcome, AKSHAY T - your support helps me a lot 😍