From the course: UiPath: Robotic Process Automation (RPA)

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Read worksheet into a data table

Read worksheet into a data table - UiPath Tutorial

From the course: UiPath: Robotic Process Automation (RPA)

Start my 1-month free trial Buy for my team

Read worksheet into a data table

“

- [Instructor] In this lecture, we'll talk about how to read a worksheet into a data table variable. I'll create a new blank project called Read Worksheet, save it in the usual spot, C:\development\uipath, click on Create and I'll jump into my Windows File System here and I've got a directory called robot-files in my C drive. You can put this anywhere you want. I'm going to right click and select New Microsoft Excel Worksheet. I'll just rename this UiPath demo data and double click to open it. I personally don't like having this ribbon staring me in the face so I'll double click on that to hide it and here are the rows and columns I was describing in the overview video. This cell would be E1, this cell would be F4, and so on. So to demonstrate reading data, in row number one here, I'm going to add a header and this will give us names for each of our columns. So I'll call this First Name, Last Name, Age, and Email Address. So you can see that this schema is similar to what we were…

Contents