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.
Write Range - Workbook & Excel - UiPath Tutorial
From the course: Complete Guide to UiPath RPA Development
Write Range - Workbook & Excel
- [Instructor] Okay, in this video, let's try to quickly examine the write range for both of these. So after we've listed all customers here, my desire is to write the rows in this data table to a different Excel file. So for workbook, I'll go into activities and type in write range, and that's this one right here. So I'll click and drag that under here. And again, we just need to choose our workbook path, which could be a variable. And actually let's do that right now because it's a best practice. I'll grab an assign up here and click in here and right click and create a variable called customers file and hit return. And I'll copy this path and paste it there. And now I can control + C and replace this path with that variable. And the reason why this is a good idea is because I can specify the value of that variable once and reuse that on both of these activities. So I'll paste it here as well. Now let's double check the scope of that variable. It's only in workbook, so let's raise…
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)
-
-
-
-
-
-
-
-
-
-
-
-
-