From the course: Complete Guide to UiPath RPA Development

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Overview

Overview - UiPath Tutorial

From the course: Complete Guide to UiPath RPA Development

Start my 1-month free trial Buy for my team

Overview

“

- [Instructor] 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 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 1, 2, 3, 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 column plus 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…

Contents