Excel Reader and Consolidator

Tasks

• The bot will open base Excel and reads the multiple Excel files in the specified folder
• Consolidates multiple Excel files into base Excel
• Saves the consolidated Excel file

This bot automatically reads all Excel files in a folder and consolidates them into a single Excel file.

Steps of automatic consolidation:
• The bot will open base Excel, reads multiple Excel files in a specified folder
• Consolidates multiple Excel files into base Excel.
• Saves the consolidated Excel file.

Detailed Steps are as follows:
The bot will open base Excel and read the multiple Excel files in the specified folder, eg: The folder with multiple files could look like eg:- "base excel.xlsx, file_1.xlsx, file_2.xlsx, File_3.xlsx, etc. The bot will then proceed to be consolidating multiple files into a single Excel file.

The Condition Required to inputs from the user are:
Folder Path: Folder containing multiple Excel files that need to be consolidated.
Base Excel: Base Excel is the core Excel file that is used as a reference for the final output Excel file. It will be the 1st Excel file appended to the output Excel file

Input and Output Examples:
Go to the Input Excel and enter the following paths to the specific locations.
• Enter the Folder Containing Excel path: cell= ‘B4’
• Enter the Base Excel file path: cell =‘B5’
• Enter the Output Excel Name: cell =‘B6’
• Enter the Error log folder path: cell =‘B9’ :

The use-cases are primarily focused on automating the consolidation and collation of multiple Excel files into a single Excel file.