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

About worksheets - UiPath Tutorial

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

Start my 1-month free trial Buy for my team

About worksheets

“

- [Bryan] Now that we've discussed the data table variable which is an in memory data structure capable of holding rows and columns, I'd like to talk about how we can read and write Excel spreadsheets or workbooks with the help of a data table variable. Excel spreadsheets or workbooks are also data structures similar to the data table, but they are a physical file again, holding structured data. And again structured data just means a predictable, repeating data format representing items of a similar type. Maybe it's users or customers or orders. We'll be dealing with rows which have indexes like one, two, three. And by default, columns are labeled using alphabetical letters like A, B, C and we reference the data in any given cell using a combination of the column plus the row. So A23 would be the data in column A row 23 and so on. Your spreadsheet can have a header row right before where the data starts and that would simply provide our column names like first name, last name, customer ID, and so on. Not every worksheet will have a header row that illustrates what's in each column. In this section, we'll learn some basic skills for Excel and workbooks, we'll have an overview of the available activities and specifically we'll talk about the differences between Excel activities and the more generic worksheet activities. We'll take a look at how to read a worksheet into a data table variable. Then we'll talk about writing a data table variable into a worksheet. We'll have a look at appending to an existing worksheet from a data table variable and finally we'll look at how to read or write specific cell data. Excel and Workbooks are a very important aspect of RPA so let's jump into it and take a look.

Contents