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.

Success!

The download of Excel Collation Assistant will begin shortly.

In your Control Room, use the ‘Import’ button to load the downloaded file into your Automations.

Access Now

Free

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

Bot Security

Level 1
  • All bots on Bot Store have passed a malware scan.

Bot Security Program

Automation Anywhere Bot Security is the RPA industry’s first of its kind bot security framework. In partnership with cyber security experts, Bot Security encompasses four (4) progressive levels of security designation. All bots including those built in-house or procured from Bot Store, can now be deployed reliably with secure bot development practices in alignment with prevailing Confidentiality, Integrity, and Availability (CIA) cybersecurity principles and best practices. View full Bot Security details.

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

About Bot Store

Automation Anywhere's Bot Store accelerates your robotic process automation initiatives by offering pre-built automations and plug-and-play integrations, so that complex business processes can be automated in days.

Bot Store