< All Bots

Excel Cloning

Clone the entire excel file with all sheets. Clone 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 Clone 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

  • In a specific area, it will count the column in between the range. For example, if the range is specified as B3 to F7 then in output file it will start from B3 and end at F10 In specific sheet, it will add a sheet if that particular sheet is not present and if the sheet is present with the same name then it will add a sheet by naming the sheet as Sheet1(2)

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

Applications
Business Process
Category
Security
Passed third-party anti-virus scan conducted by Automation Anywhere.
Downloads
58
Vendor
Automation Type
Bot
Last Updated
August 6, 2019
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