Working with data in Excel
In the previous section, we looked at the basics of Excel automation, such as opening, reading, writing, saving, and closing Excel workbooks. In this section, we will explore the Automation Anywhere Excel advanced package. The walk-through will involve building a bot that performs a specific role. The bot will replace a manual task that involves updating an Excel spreadsheet. The file used is available as part of the GitHub repository Chapter11_SampleData.xlsm
:
This file contains a data table of sales achieved by a fictitious organization. In order to automate the file, we perform the following steps: