Free tutorial
A fruit company wants your help with the orders.
Anders Jensen Automation & AI Instructor
Before you start working for our clients, you need to install UiPath and connect it to Orchestrator.
Read more →Additional lessons and discussions with more than 5000 UiPath Developers: Join the Facebook Group -- Follow me on:
Read more →EA Sports called your office. They want you to design their next game.
Read more →These comments were migrated from the previous version of this site. Commenting is closed.
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
Hey, I am new to UiPath, so I was following your course for beginners (so far I am really enjoying it) and I then arrived this module. However, because of the updates it seems that the activity Excel Application Scope is not available, which activity from the newest package can I use instead?
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 14,000+ RPA Developers helping each other with solutions and our careers. It’s free, and you can find it here: https://discord.gg/iloveautomation Kind regards, Anders
Here's how I did it; Excel Process Scope > Use Excel File > Read Range > For Each Excel Row