Excel Cloning

Clone the entire excel file with all sheets. \nClone the specific area in a given range. For eg., If the range specified is A10 TO P16 then it will copy all contents between that range \nClone the specific sheet. If the sheet is not present then the bot will add a sheet with the same name and copy the contents. If the sheet is present with the same name then it will add a sheet by naming it as Sheet1(2)

Top Benefits

Clone entire sheet. Clone specific area in a given range. Clone the specified sheet name provided.

The formula is used to count columns of a specific range VBscript is used to copy sheet, add a sheet, add a sheet with the same name

Get Bot

Free

Bot Security Program
Level 1
Applications
Business Process
Category
Downloads
138
Vendor
Automation Type
Bot
Last Updated
July 24, 2020
First Published
August 6, 2019
Enterprise Version
11.3
Support

See the Bot in Action

PREV NEXT

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

  • Notepad(VBscript), provided with one sample input file you can use any excel file and change the input file path in the config file and output file should be already created
  • Inputs: To clone the entire file : Input file Output path To clone a specific area: Input file Output file Sheet name Firstcellvalue Secondcellvalue To clone a specific sheet: Input file Output file Sheet name