Working example walk-through

You will now start building the modular task bot as described in our scenario. We have got the main and sub-bot designs to guide us. We will build four bots in total – one main task bot and three sub-task bots. For this scenario, we will use the sample Chapter15_SQLite.db database and will limit the records for each table to 20. Firstly, let's give our bots some names; we will name them as follows:

• Chapter16_Sub_CreateNewExcel
• Chapter16_Sub_GetSqLiteTableNames
• Chapter16_Sub_CopySqLiteTableToExcel
• Chapter16_Main_SqLiteToExcel

It always makes sense to start with the sub-tasks first. This will enable us to build the main task quickly as we bolt the smaller sub-tasks together. We will start the walk-through with the first sub-task bot, Chapter16_Sub_CreateNewExcel.

Building a bot – Chapter16_Sub_CreateNewExcel

This bot takes an Excel file path input and checks whether it exists. If it does, then this file...