From the course: Complete Guide to UiPath RPA Development
Unlock this course with a free trial
Join today to access over 24,700 courses taught by industry experts.
Challenge: Read Excel config file - UiPath Tutorial
From the course: Complete Guide to UiPath RPA Development
Challenge: Read Excel config file
- [Instructor] Okay, I think it's time for a challenge. You may recall I said that dictionaries were going to make another appearance in the Excel section. Well, here we are in the Excel section and the technique we're about to work on is going to prepare you for more advanced topics in my UiPath Level 2 course. So, my challenge to you is to create a new process called ReadExcelConfig and store it wherever you want. I'll put it into C/development/UiPath and click on Create. And now, I want you to go into the Project tab and right-click in the white space here and add a folder called Data and hit Return. So now, we have a folder inside of our project and any files in that folder will get bundled up with our automation files and published into Orchestrator when we want to deploy it. So, right-click on the Data folder and select Open. So that opens it in the Windows File Explorer. Now right-click and select New Microsoft Excel worksheet and call that Config. Now double-click on Config…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
(Locked)
Overview2m 17s
-
Excel/worksheet activity overview7m 47s
-
(Locked)
Excel vs. workbook nuances6m 15s
-
(Locked)
Read Range - Workbook6m 35s
-
(Locked)
Read Range - Excel8m 14s
-
(Locked)
Write Range - Workbook & Excel8m 3s
-
(Locked)
Read range, modify data table, then write range16m 4s
-
(Locked)
Read and write cell data8m 30s
-
(Locked)
Challenge: Read Excel config file2m 39s
-
(Locked)
Solution: Read Excel config file7m 49s
-
(Locked)
-
-
-
-
-
-
-
-
-
-
-
-
-