Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases now! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Robotic Process Automation Projects

You're reading from   Robotic Process Automation Projects Build real-world RPA solutions using UiPath and Automation Anywhere

Arrow left icon
Product type Paperback
Published in May 2020
Publisher Packt
ISBN-13 9781839217357
Length 388 pages
Edition 1st Edition
Arrow right icon
Authors (3):
Arrow left icon
Ivan Loncar Ivan Loncar
Author Profile Icon Ivan Loncar
Ivan Loncar
Arun Kumar Asokan Arun Kumar Asokan
Author Profile Icon Arun Kumar Asokan
Arun Kumar Asokan
Nandan Mullakara Nandan Mullakara
Author Profile Icon Nandan Mullakara
Nandan Mullakara
Arrow right icon
View More author details
Toc

Table of Contents (14) Chapters Close

Preface 1. Getting Started with Robotic Process Automation 2. Help Desk Ticket Generation FREE CHAPTER 3. CRM Automation 4. Moderating Social Media Using AI 5. Purchase Order Processing with UiPath ReFramework 6. Completing an RPA Challenge 7. Sales Order Processing 8. ERP User Administration 9. Employee Emergency Notifications 10. Using AI and RPA for Invoice Processing 11. Other Books You May Enjoy Appendix A and B for UiPath 1. Appendix: Looking Forward and Next Steps

Reading the RPA challenge Excel data

We will use the Read Range activity to read the Excel content. Here are the steps for creating the UiPath automation:

  1. In the Try block, add a new sequence called Main Sequence.
  2. We will now read the input Excel file data into the dataTable variable that we just created. Add the Read Range activity and update the properties of the activity:
    1. Click and point on the RPA challenge Excel workbook location.
    2. Add the range to read on the workbook.
    3. Make sure AddHeaders is checked. 
    4. Set Output to a new dataTable variable.

Here is what our workflow looks like so far:

We now have the Excel data stored in the dataTable variable. Let's now iterate on each row and input the data into the forms on the website. 

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime