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)

Information Technology

Excel Cloning

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)

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…


Features

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

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)


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

Output

1) The bot will clone the entire file with all the sheets 2) The bot will clone a specific area provided 3) The bot will clone specific sheet provided


More Details

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

Owner Contact Info

Vendor image

Pre-install Checks

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


Install Related

Installation

  • Download the bot from Bot Store.
  • Double click on the .msi file.
  • On Welcome to Installation wizard, click Next to continue.
  • Click I agree to the terms in the license agreement radio button to accept the agreement.
  • Get/Copy the License key from Bot Store Downloads into License Key, click Next to continue.
  • Click Install to begin the installation.
  • Click Finish to complete the installation.
  • To view the installation go to 'My Tasks' folder on AAE Client to see bot files.

Uninstall

  • Open Add/Remove Programs -> Select the Bot/Digital Worker to be installed 
  • Click uninstall 

Reviews

There are no reviews yet.

Be the first to review “Excel Cloning”

Your email address will not be published. Required fields are marked *