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.

Read Range - Workbook

Read Range - Workbook - UiPath Tutorial

From the course: Complete Guide to UiPath RPA Development

Start my 1-month free trial Buy for my team

Read Range - Workbook

“

- [Instructor] Let's have a look at Read Range for both workbook and Excel. To get started, I'm going to click on this parallel and just delete that whole thing. Then I'll go into Activities and type in range. And from System, File, Workbook, I'm going to drag a Read Range workbook into my workflow. Using this is super easy. I can simply either provide a variable that holds my workbook path, or click on this folder and navigate to that customer's file I was telling you about earlier. So that lives on my C drive in this robot files directory. And again, this Excel file could be in our project folder as well. But usually when you're doing automated processes, you're going to be interacting with Excel files that live on shared folders in an external server or whatever. So I'll click on this and select Open. So now you can see my path. And then I need to click here under Sheet Name, and open double quotes, and type in whatever the name of that sheet is. In our case, it's Sheet 1, which I…

Contents