Designing modular task bots

For this chapter, we will take a fictitious scenario where you are a bot developer tasked with building a bot. The walk-throughs will guide you from initial design to modular design right through to actually building the bot. In a nutshell, the task for your bot is this:

Extracting all the tables and data from a specific SQLite database to a new Excel workbook. The workbook should consist of a worksheet for each table in the SQLite database.

The following additional details are also given:

• The local repository location is C:\Hands-On-RPA-with-AA-Sample-Data\.
• The Excel spreadsheet should be named Output.xlsx and saved in the local repository folder. If this file already exists, it should be deleted and a new one should be created.
• The SQLite database file is available in the GitHub repository; it is named Chapter15_SQLite.db.
• Only the system tables should be extracted – system tables are prefixed with sqlite_.
• A new worksheet...