Excel Operation

This package is a package that streamlines processing related to Excel.

Top Benefits

  • Able to manipulate specified cells
  • Can create Excel graphs.
  • Can set the display format of cells.
  • Filtering of Excel data.

Tasks

  • Merge specified cells.
  • Change the background color of the specified cell.
  • Change the font of the specified cell.
  • Add a border to the specified cell.
  • Read the display format of the specified cell.
  • Change the display format of the specified cell.
  • Create a graph.
  • Change the source range of a graph.
  • Change the graph type.
  • Set multiple filters for specified columns.

This package is a package that streamlines processing related to Excel.

Use cases
The main use cases are as follows.
•Clear multiple columns from table variables or extract multiple columns.
•Delete lines that don't meet the criteria.
•The value of the first row of the table variable is the header. If the header is already set, overwrite it.
•Specify and sort multiple items (up to 3 items). Sort according to the type of column subtype. Use the data table package Change column type action to change the subtype of a column.

Success!

The download of Excel Operation will begin shortly.

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

Access Now

Free

Applications
Business Process
Category
Vendor
Automation Type
Bot
Last Updated
January 31, 2025
First Published
October 4, 2024
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

Change the background color of the specified cell
Set multiple filters for specified columns
Create a graph
PREV NEXT
Change the background color of the specified cell
Set multiple filters for specified columns
Create a graph

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

  • All instructions updated on readme file