Excel Drag Formula Utility

This bot will apply the given formula to the specified cell and drag it until the second-specified cell or end of the data in the previous column.

Top Benefits

  • Reduce development time
  • Appropriate logging
  • Reduced automation execution time

Tasks

  • Writes provided formula to the selected cells
  • Quick Applies formula to the selected cells
  • Applies formula to all the cells in column if to cell value is not provided
  • Saves the excel

This bot will apply the given formula to the specified cell and drag it until second-specified cell (To cell- vExcelCellTo in variables) in the same column. If a user wants to apply the formula till the end of the column, then the user can set “to cell” (variable-vExcelCellTo) value blank, the bot will drag the formula till the end of the column.

Get Bot

Free

Bot Security Program
Level 1
Applications
Business Process
Category
Downloads
766
Vendor
Automation Type
Bot
Last Updated
June 3, 2020
First Published
June 3, 2020
Enterprise Version
11.3
Community Version
11.3.1
ReadMe
ReadMe
Support

See the Bot in Action

Code snippet 1
Code snippet 2
Code snippet 3
PREV NEXT
Code snippet 1
Code snippet 2
Code snippet 3

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

  • This variable contains cell position upon which the given formula will be applied.
  • This variable contains input excel file path.
  • This is the folder path where process logs and snapshots stored.
  • This variable contains the cell position till user wants to drag formula. This can be provided blank.
  • This variable contains the formula that has to be applied.