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 8 Comments

  1. Lusanda

    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

    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

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

    1. Anders Jensen

      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

    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

    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

      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

Leave a Reply