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 RangeWrite RangeAppend RangeSort TableRead Cell and Write Cell, as well as DataTable activities such as For Each RowOutput Data TableGet Row ItemAdd Data Row and Build Data Table.

For more tutorial videos click on continue reading

Please follow and like us:

Leave a Reply

Your email address will not be published. Required fields are marked *

Follow by Email