ไม่สามารถเล่นวิดีโอนี้
ขออภัยในความไม่สะดวก
UiPath - How to Lookup Excel columns (/Data Tables) and update data
ฝัง
- เผยแพร่เมื่อ 3 ส.ค. 2024
- This video tutorial shows how to lookup Excel columns (Data Tables) and update data in another Excel column with UiPath.
🚀 Get 2 months FREE subscription (cancel anytime) to Skillshare and watch our UiPath Advanced REframework class - skl.sh/3eTWqSx
📚 The coding language of UiPath: Learning Visual Basic .NET (book) - geni.us/v6ffI
Connect with me:
💼 LinkedIn - / andersjensens
👥 Facebook - / andersjensenorg
💌 Email Newsletter - andersjensen.org/email-newsle...
You're the best!!!
You're very welcome, Srushti Kotangale - your support helps me a lot 😍
Great video, thank you. Can you tell me how to maintain leading zeros when you update the data. My excel and datatable has a column that has leading zero - 0000012365. But when I write the data back into my excel spreadsheet the leading zeros are dropped and I get 12365. The number will always be a ten digit number. Any suggestions on how to fix this?
Hey mrsjaya, thanks a lot :) Sure, just add a ' before the zero and it will stay as such. Kind regards, Anders
Hi Anders, I like all your videos. One doubt I need clarification on. Is there a way to know if given string is Date or not? Date can be in any possible format(22/09/2020, 22-08-1987, 9th Sept 2020, etc...)
Hey Sushil. We can do that. Either with RegEx or else we first need to have a list of all our possible formats (22/09/2020, 22-08-1987, 9th Sept 2020, etc.). Then we can try to parse our string into a date, which will give us a true/false (boolean). That will work, but the not so nice thing will be, that we need to list ALL our possible formats. Let me know, if you can't figure it out, I will make a short video for you 😊 Kind regards, Anders
Hi Anders. If you like, we can complicate a little bit this exercise by adding in Sheet2 another country on "country data" column. Let's say China. Obviously, China doesn't have a correspondent in Sheet1, so the workflow will throw an error ("Assign: There is no row at position -1." Someone even mention this error here in a comment). How do you suggest to handle this error? Try/Catch activity will work?
Thanks.
Hey Mihai. 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 tried working out the same method as you did for using it as a prototype in my other project. But I get Runtime execution error saying that there is no row in Position - 1.
So far I couldn't sort out the issue .
I gave a second sheet (Alternate one for dtsheet2), but instead of writing to the destination sheet, it is showing the above error.
How can I overcome this problem?
Same here.
Hi Anders, Any solution for this issue...
Same here , could you find the solution?
Hey Ravikiran Radhakrishnan
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
Hi, what if my output is string instead of integer, do I use cellvalue instead of rowindex? Then do I still need to do assign? In addition, I need to lookup from multiple excel files, how do I do that?
Hey Eileen
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
Is there some sort of Microsoft Automation license required to use Read and Write Range to Excel when using a RPA software?
Hey Tobie. Yes, you need to have Excel Installed to use the Excel Application Scope. However you can use the read/write range from the workbook activities instead. That will do the trick 🙂 Kind regards, Anders
@@andersjensenorg I was actually referring to something I read that Microsoft requires a certain license if a person does Unattended Automation on Office software. What is Unattended Automation and do need a special license for those activities? I don't want Office 365 subscription. download.microsoft.com/download/3/D/4/3D42BDC2-6725-4B29-B75A-A5B04179958B/M365_Unattended_Brief.pdf
Hey Tobie. An unattended robot runs without intervention of humans (in contrast to an attended robot). Usually we run our unattended robots on a server, where we need software licenses to the applications, that the robots operate in. Regarding Office, it is usually not a problem, since we can use the datatable/workbook activities instead. Kind regards, Anders
@@andersjensenorg Thank you for the reply and I like knowing that uipath has workbook activities instead of just scope. I watched your video on reading from a csv see that I can write to a csv as well which is also an option as it does not actually involve writing to Excel.
@@tobiewaldeck7105 Definately. You can also chose to automate in Google Sheets, however that is a bit more difficult to setup, th-cam.com/video/okrKQemOKN0/w-d-xo.html Let me add that your comments/questions are really valuable to me (both in terms of letting YT know, that my topics create interest, but also in terms of keeping me aware of things/topics I can improve or explain better). Keep it coming 😊 Kind regards, Anders
Hello Anders sir please help on one of my query the query is related to data scrap.
Eg : suppose I have one website in which the page show data by click on show more button if I scrap the data it show 10 items only that means after click show show more button that data not scrap.
Guide me sir how can I do.
Hey Neal. We need to click on 'more' untill it is no longer visible, then we can data scrape. Follow the guide in this video, th-cam.com/video/Dlkn5k8intk/w-d-xo.html for clicking more and when done, you just data scrape as normal. Let me know, if that make sense? Kind regards, Anders
@@andersjensenorg yes it's works for me thanks a lot sir, Regards Neil
Hey Neal. Happy to hear 😊 Kind regards, Anders