Chapter 9: Learning the Uses of Data Tables and Exploring Excel Automation
We discussed different types of variables and arguments in the previous chapter. However, there is another very special type of variable, which we call data tables. We use data table variables to process more structured data that is organized in a tabular form. We use Microsoft Excel almost every day to perform different functions in an organization. For example, a finance department may use Excel regularly to generate reports, perform calculations, and reconcile financial data. As a result, many companies and/or departments have already started automating the actions performed manually in Excel.
This chapter focuses on learning how to automate Excel using UiPath and how data table variables can be used to support Excel automation.
The chapter consists of the following sections:
- Exploring data tables
- Creating and customizing data table variables
- Interacting with Excel files
- Practicing...
