< All Bots

Excel Font Operations

The bot consists of different task bots that are capable of doing specific font operations in an Excel file. vPath=//specify the path of the input Excel file

Top Benefits

  • Can be used for highlighting specific Row or Header
  • can be used for Specific Column
  • Highlight the the entire row on a specific value
  • Error Free Operation
  • Easy to handle

Tasks

  • Excel Font Operation Depending on a Specific Value
  • Excel Font Operation For a Specific Row Depending on a Specific Value
  • Excel Font Operation For Entire Excel sheet
  • Excel Font Operation For Specific Column
  • Excel Font Operation For Specific Row

The bot contains multiple task bots which are capable of doing different excel font operations like changing font style, font size, Underline or Not, Bold or not to a specific column or row or some specific values or the entire sheet in the excel sheet depending on the operation done by the user. The User needs to specify the variables inside the task bot for the operation of the bot. The variables are
vPath=//Specify a path for the excel file
vSheetName=//Specify the sheet name of the excel file.
vFontBold=//Specify the text should be Bold or not in True or False format.
vFontColor=//Specify the color of the font.
vFontItalics=//Specify the text should be in Italics or not in True or False format.
vFontSize=//Specify the font size of the text.
vFontStyle=//Specify the font style.
vFontUnderline=//Specify the text should be Underlined or not in True or False format.
vColumnNo=//Specify the row Number and it should be an integer
vSpecificValue=//Specify the value to highlight the entire row.
vRow=//Specify the row Number and it should be an integer

Get Bot

Free

Applications
Business Process
Category
Security
Passed third-party anti-virus scan conducted by Automation Anywhere.
Downloads
42
Vendor
Automation Type
Bot
Last Updated
October 28, 2019
First Published
October 21, 2019
Enterprise Version
11.x
Community Version
-1
ReadMe
ReadMe
Support

See the Bot in Action

PREV NEXT
For a specific Row
For a specific Column
For a specific value
For a specific condition based value
For entire sheet

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 Anywhere v11 or Higher
  • Microsoft Excel