Delete Blank Rows in Excel

This bot will remove all the blank rows that are in the wrong place, whether at the beginning or in the middle of Excel sheets in a workbook

Top Benefits

  • Speeds up work with Excel sheets
  • Easy to report in the log file
  • Manageable code with the help of the config file
  • Handles most of the code from config file

Tasks

  • Excel macro will do this task for you
  • Can send multiple Excel sheets to remove all the blank rows from the sheet
  • Mail will be sent after task finished

Blank rows aren't bad, but in most sheets, they're definitely undesirable. Excel uses blanks to determine data ranges, and a blank row in the wrong place will inhibit many built-in features. Fortunately, there's an easy way to remove blank rows from a data range, but this easy technique has the potential to destroy data, so you must be careful. This bot will do this for you.

Success!

The download of Delete Blank Rows in Excel will begin shortly.

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

Buy Now

$90 USD per bot
Annual Subscription

Free 30-Day Trial

Request quote for more purchase options

Bot Security Program
Level 1
Applications
Business Process
Category
Vendor
Automation Type
Bot
Last Updated
December 10, 2020
First Published
April 13, 2020
Platform
11.3.3
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

Output data will be show in such way
Macro will easily handle this scenario
Macro will be placed into Input folder
PREV NEXT
Output data will be show in such way
Macro will easily handle this scenario
Macro will be placed into Input folder

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

  • Input Folder
  • Config Folder
  • Macro should be placed in Input folder
  • Config file should be placed in config folder

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