Removes Blank Rows From Excel Sheet

This Bot takes client data from a Excel file and removes all the blank rows present in Excel File.

Top Benefits

  • 100% accurate
  • Fast and Efficient
  • Bot can easily remove blank rows from a large amount of data
Product video fallback

Tasks

  • Takes the Excel file path and file name from the user
  • Performs remove blank rows operations
  • Stores the processed file in given Output folder
Inputs: Takes Excel file path, file name (including extension e.g. dummydata.xlsx), sheet name, and output folder path from the user during run time. Actions: Bot will remove the blank rows in the Excel file based on the first excel column. Outputs: A filtered output file will be generated with no blank rows. Use cases: This bot can be useful in the Accounts and Finance department for sorting a large amount of data.

Setup process

Install

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

Configure

Use the Bot in a bot, configure keys and other credentials the Bot will need (see the ReadMe for details.)

Run

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

Requirements and Inputs

  • Microsoft Excel
  • Automation Anywhere v11

Customer Reviews

0.0(0 reviews)

No reviews yet.