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
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.
Hey Lusanda – check this: https://www.youtube.com/channel/UCPdtz4gd_iYebJFYq9N8pWA/community?lb=UgkxD9AC7X3GLmEloN5J6iAdTEM1fXwXZ_sj
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.
I found the issue, a missing tick on the Save Changes checkbox. 🙂 Sorry to bother you for so little.
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
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.
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?
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
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
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
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
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
Hey Julian, thanks a lot for taking the time to help