Video není dostupné.
Omlouváme se.

UiPath | How to automate Excel and work with Data Tables | Tutorial

Sdílet
Vložit
  • čas přidán 30. 01. 2020
  • A guide that teaches you how to work with Excel data in UiPath. The guide will show you how to import the data from an Excel Sheet, then work with it in UiPath using Data Tables and finally print it out again to Excel.
    00:36 Get Data Sample
    02:11 Excel Application Scope
    03:49 Read Range (Excel)
    04:38 Create Data Table
    05:28 For Each Row
    06:21 Using a Write Line to print selected data
    09:44 Using an If to apply a condition on our data
    10:28 Converting a String to a Double
    12:33 Add Data Row
    13:21 Creating an Array of variables
    15:01 How to use a Write Range to print our selected data
    17:10 Add Headers
    17:38 Add Data Column
    18:35 Input Dialog
    19:21 Creating a dynamic array
    21:15 How to write cells in a new column
    🔔Subscribe if you enjoyed
    czcams.com/users/klogeande...
    🤖UiPath Video Tutorial
    • UiPath: How to get a D...
    #uipath #excel #datatable

Komentáře • 65

  • @tomcat9761
    @tomcat9761 Před 3 lety +2

    Man, this is better than UIPath Academy beginner wise

    • @andersjensenorg
      @andersjensenorg  Před 2 lety

      You're very welcome, Tom Cat - your support helps me a lot 😍

  • @anatolek7
    @anatolek7 Před 2 lety +2

    thanks! Now I figured out the Add Column! Keep up the great videos! They are really helpful!

    • @andersjensenorg
      @andersjensenorg  Před 2 lety

      Hey Tony, thanks a lot 🙂 I'm very glad reading your comments. Kind regards, Anders

  • @user-gx7ut4st9w
    @user-gx7ut4st9w Před 3 lety +3

    Thanks, Anders, a lot for your wonderful instructions. You make best videos!

    • @andersjensenorg
      @andersjensenorg  Před 3 lety +1

      Hey Анастасия. I really appreciate your support (it also help me to grow). Have a great day. Kind regards, Anders

  • @moneyboy194
    @moneyboy194 Před rokem +1

    Hi Anders, thank you for making so helpful videos!

    • @andersjensenorg
      @andersjensenorg  Před rokem

      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: czcams.com/video/xWFz-S96XGo/video.html

  • @dmuirheid8102
    @dmuirheid8102 Před 3 lety +1

    Wonderful instruction! Thank you for your video.

    • @andersjensenorg
      @andersjensenorg  Před 3 lety

      Hey D Muirheid. Thank you very much 😊 Let me know, if you have ideas and/or questions for videos. Kind regards, Anders

  • @shintaainal282
    @shintaainal282 Před 2 lety +1

    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!

    • @andersjensenorg
      @andersjensenorg  Před 2 lety

      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

  • @LUKSUSq
    @LUKSUSq Před 4 lety +2

    These elaborations are so transparent and clear in understanding that i want to see more and more :) you tell it clearly and
    understandable! Super!

  • @chrisv1830
    @chrisv1830 Před 9 měsíci

    Thanks for the help!

    • @andersjensenorg
      @andersjensenorg  Před 9 měsíci

      My pleasure, Chris V 😊 Have a great weekend! Kind regards, Anders

  • @lionelblak
    @lionelblak Před 3 lety +4

    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!

    • @andersjensenorg
      @andersjensenorg  Před 3 lety

      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

  • @mehmetmustali3698
    @mehmetmustali3698 Před 3 lety

    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?

    • @andersjensenorg
      @andersjensenorg  Před 3 lety

      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: czcams.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

  • @nayannimisha
    @nayannimisha Před 2 lety +1

    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

    • @andersjensenorg
      @andersjensenorg  Před 2 lety

      Thanks a lot, Nimisha! I'm so happy that you took your time to reply. Kind regards, Anders

  • @wonsikchoi6968
    @wonsikchoi6968 Před 3 lety

    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?

    • @andersjensenorg
      @andersjensenorg  Před 2 lety

      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: czcams.com/video/C6xmGfEL07I/video.html
      Have a great day.
      Kind regards,
      Anders

  • @MovieTheatrebyDR.
    @MovieTheatrebyDR. Před 2 lety +1

    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.

    • @andersjensenorg
      @andersjensenorg  Před 2 lety

      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: czcams.com/video/C6xmGfEL07I/video.html
      Have a great day.
      Kind regards,
      Anders

  • @777Donaldtrump
    @777Donaldtrump Před 3 lety +2

    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..."

    • @andersjensenorg
      @andersjensenorg  Před 3 lety +2

      Hey Leung. Sure. Use a Output DataTable, create output as string and then use a Write Line with the string. Kind regards, Anders

    • @777Donaldtrump
      @777Donaldtrump Před 3 lety

      @@andersjensenorg Thx so much man.

  • @mrsjaya73
    @mrsjaya73 Před 3 lety

    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?

    • @andersjensenorg
      @andersjensenorg  Před 3 lety

      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: czcams.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

  • @manuelcaballero5827
    @manuelcaballero5827 Před 3 lety +1

    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.

    • @andersjensenorg
      @andersjensenorg  Před 3 lety +1

      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

    • @manuelcaballero5827
      @manuelcaballero5827 Před 3 lety

      @@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.

    • @cedricpendji4972
      @cedricpendji4972 Před 3 lety +3

      @@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.

    • @manuelcaballero5827
      @manuelcaballero5827 Před 3 lety

      @@cedricpendji4972 Thank you!!

    • @yannademcissoko5048
      @yannademcissoko5048 Před 2 lety

      @@cedricpendji4972 and if i just want to do not ecrase my data , i just want to add a new row everyday

  • @mohamedshehata3979
    @mohamedshehata3979 Před 3 lety +1

    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.

    • @andersjensenorg
      @andersjensenorg  Před 3 lety

      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: czcams.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

  • @domsfsf761
    @domsfsf761 Před 4 lety

    Hello, can you show me how to use auto increments in add data column.

  • @herpderp9430
    @herpderp9430 Před rokem

    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)?

    • @andersjensenorg
      @andersjensenorg  Před rokem

      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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders

  • @drsrmahale
    @drsrmahale Před 2 lety

    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

    • @andersjensenorg
      @andersjensenorg  Před rokem

      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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders

  • @athenaellis7556
    @athenaellis7556 Před 2 lety

    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.

    • @andersjensenorg
      @andersjensenorg  Před 2 lety

      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: czcams.com/video/C6xmGfEL07I/video.html Have a great day. Kind regards, Anders

  • @yannademcissoko5048
    @yannademcissoko5048 Před 2 lety +1

    thx ; but iwant to know how to ad a new column to the excel sheet when we add a new name

    • @yannademcissoko5048
      @yannademcissoko5048 Před 2 lety

      a new row

    • @andersjensenorg
      @andersjensenorg  Před 2 lety

      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: czcams.com/video/C6xmGfEL07I/video.html
      Have a great day.
      Kind regards,
      Anders

  • @MsJsmith99
    @MsJsmith99 Před rokem

    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

    • @andersjensenorg
      @andersjensenorg  Před rokem

      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): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders

  • @itsmechethan6105
    @itsmechethan6105 Před 2 lety

    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

    • @andersjensenorg
      @andersjensenorg  Před 2 lety

      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: czcams.com/video/C6xmGfEL07I/video.html
      Have a great day.
      Kind regards,
      Anders

  • @sernchiewhan2105
    @sernchiewhan2105 Před 2 lety

    could we delete the column we do not want?

    • @andersjensenorg
      @andersjensenorg  Před 2 lety

      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: czcams.com/video/C6xmGfEL07I/video.html
      Have a great day.
      Kind regards,
      Anders

  • @rohantammewar6337
    @rohantammewar6337 Před 4 lety

    why to use row.Item("column_name")
    If row("column_name") works

    • @andersjensenorg
      @andersjensenorg  Před 4 lety +3

      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

    • @rohantammewar6337
      @rohantammewar6337 Před 4 lety

      @@andersjensenorg Great! Thanks!

  • @nikosthe15
    @nikosthe15 Před 2 lety

    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?

    • @andersjensenorg
      @andersjensenorg  Před 2 lety

      Hey nikos, check this: studio.czcams.com/users/postUgkxD9AC7X3GLmEloN5J6iAdTEM1fXwXZ_sj/edit Kind regards, Anders

    • @nikosthe15
      @nikosthe15 Před 2 lety

      @@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

    • @andersjensenorg
      @andersjensenorg  Před 2 lety

      Sorry, check this: czcams.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgkxD9AC7X3GLmEloN5J6iAdTEM1fXwXZ_sj