Lesson 5 – Excel & Data Tables

Intro:
A fruit company wants your help with the orders.

What you will learn:

  • Primarily
    • Excel
    • Data Tables
  • Secondarily:
    • Condition in an If
    • Variables

Client name:
Green Fruit

Process Name:
Fruit Orders

Description:
Green Fruit wants to have a robot, that automatically can calculate orders:

  • Read the Excel sheet
  • Calculate the Totals column (that is quantity multiplied with price)
  • Place a “Yes” in the “Big Order” column, if the Total is bigger than 10

This Post Has 13 Comments

  1. Lusanda 17 Nov 2021 Reply

    Hi there,

    I need a bit of help with this lesson.

    Firstly, my UiPath application doesn’t have the activity Excel Application Scope, instead the only option that comes up is Use Excel File. This forced me to select the file as a template file.

    Then in my Write Range function, I have extra text boxes and the one keeps giving me an error. It says I must enter a DriveItem which doesn’t accept any variable names assigned throughout the sequence.

  2. Claudiu 21 Dec 2021 Reply

    Hi Anders,
    Thank you for all your efforts to teach us. I’m using the modern design, just because 🙂 So instead of Write Range I have something called Write Data Table to Excel. It works fine, I can see the Totals being calculated and typed into the file (using a delay just before the file closes), but when I reopen the file, the Totals are still missing, so the file doesn’t get saved. What could be the issue ? Thanks.

  3. Claudiu 21 Dec 2021 Reply

    I found the issue, a missing tick on the Save Changes checkbox. 🙂 Sorry to bother you for so little.

    1. Anders Jensen 22 Dec 2021 Reply

      Haha, you’re not bothering me at all – thanks a lot for getting back (and I wasn’t answering). Anyway, you’re very welcome on my Discord: https://discord.gg/d8KQpTUvFD, where we live solve problems and talk about our careers

  4. Daniel 4 Jan 2022 Reply

    Hi, Anders.
    I had a problem here. The robot didn’t work and i think it’s because i don’t have Excel installed in this machine. I tried instead the Workbook versions of “Read Range” and “Write Range”, but they didn’t work either. I always have a message telling me to repair Excel.
    Is there anything i can do?
    Thanks in advance.

  5. Darren 27 Apr 2022 Reply

    Hi Anders,
    My UiPath application doesn’t have the activity Excel Application Scope, instead the only option that comes up is Use Excel File. This forced me to select the file as a template file.
    I modified the settings as shown in your link, but the Excel Application Scope isn’t available.
    I deleted the sequence, and started again, but it is still not showing.
    Any suggestions?

    1. Anders Jensen 28 Apr 2022 Reply

      Hey Darren. Did you sort it? Else you can toggle between Classic and Modern design, see how it’s done: https://youtu.be/OVXf1zXUSvY. This course is using the Classic and you most likely have the Modern enabled. Have a great day. Kind regards, Anders

  6. Raj 24 May 2022 Reply

    Hi Anders,

    Below is the code I wrote in the value field in order to multiple the values of Price and Quantity fields but I am getting an error

    (convert.ToDouble(row.item(“Quantity”))*convert.ToDouble(row.item(“Price”)))

    Below is the error I am getting

    which says Argument ‘Value’: Compiler error(s) encountered processing expression “(convert.ToDouble(row.item(“Quantity”))*convert.ToDouble(row.item(“Price”)))”, ‘row’ is not declared. It may be in accessible due to its protection level.
    Argument ‘To’: Compiler error(s) encountered processing expression “row.item(“Total”)”, ‘row’ is not declared. It may be in accessible due to its protection level.

    Please help

  7. Ken 14 Jul 2022 Reply

    Hi Anders Jensen,
    Can you help me try replicating EXCEL & DATA TABLES in the new UIPath version but encountering this error can you help me how to solve this error.

    under For Each Row in Data Table
    error encountered Value for a required activity argument ‘Values’ was not supplied

    1. Anders Jensen 15 Jul 2022 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 3,200+ RPA Developers helping each other with solutions and our careers. You’re very welcome: https://discord.gg/d8KQpTUvFD Kind regards, Anders

  8. Julian 15 Nov 2022 Reply

    Hey, I had this problem. All I did was in the “for each” box I changed it from “current row” to “Row”. Hope this helps

    1. Anders Jensen 15 Nov 2022 Reply

      Hey Julian, thanks a lot for taking the time to help

Leave a Reply