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.

Get Bot

Free

Bot Security Program
Level 1
Applications
Business Process
Category
Vendor
Automation Type
Bot
Last Updated
September 27, 2021
First Published
September 27, 2021
Platform
Automation 360
ReadMe
ReadMe
Support

See the Bot in Action

The Bot for Excel Collation
Prompt for input file path
Prompt for output file
PREV NEXT
The Bot for Excel Collation
Prompt for input file path
Prompt for output file

Setup Process

Install

Download the Bot and follow the instructions to install it in your AAE Control Room.

Configure

Open the Bot to configure your username and other settings the Bot will need (see the Installation Guide or ReadMe for details.)

Run

That's it - now the Bot is ready to get going!

Requirements and Inputs

  • Automation 360 installed
  • Only .xlsx files can be used
  • Python script for the process Libraries used: pandas, globe, XlsxWriter, openpyxl