Install
Download the Bot and follow the instructions to install it in your AAE Control Room.
Excel Collation Assistant
This bot collates multiple Excel sheets from different Excel files into a single output Excel file using Python script
Top Benefits
- Collates multiple Excel sheets from different Excel files into a single Excel file
- All the data can be assembled so that it can be more easily updated and aggregated
- Used as a summarized report
Tasks
- When Bot runs, the user prompt for the input folder path
- Prompt for the output file path
- A message box will display with the given input folder path and output file path
- The execution of the Python code will be done
- Response will be displayed in a message box
The Excel Collation Assistant bot is used for combining multiple Excel sheets from multiple Excel files into a single Excel file using Python script. Pandas, globe, XlsxWriter, and openpyxl. The files should be in .xlsx format.
The user can prompt for the desired input files and select the output files. It will execute the python code and output will be generated. A Response will be displayed in the message box.