Resources

Video Tutorials

Excel and DataTables Automation

Workbooks are references to Excel files, regardless of the data, format and layout they contain. 

Data tables are the simplest types of spreadsheet data with rows and columns, with or without headers. 

Excel Application Scope is a container that enables you to work with all the other Excel activities. This activity is where you specify the .xlsx file you want to work with.

Additionally, you can work with this container even if you do not have MS Office Excel installed on the machine, if the Visible property is cleared. 

Besides this, this video helps you understand, through practical exercises, how to use the most popular Excel activities such as Read Range, Write Range, Append RangeSort Table, Read Cell and Write Cell, as well as DataTable activities such as For Each Row, Output Data Table, Get Row Item, Add Data Row and Build Data Table.