Copy Paste Sheet

Copies and pastes the contents of an excel sheet to another excel sheet.

This activity copies the content of an excel sheet and pastes it to a user-specified excel sheet of

the same or different file.

This activity can only be used after the Open Excel File activity

Input

• Input : ExcelHandle Variable A variable name that references the opened excel filehandle.

• Sheet Name: String Argument The name of the sheet in which the row of data is to be inserted.

Options

• Destination Cell : String Argument The name of the starting cell in which the sheet is to be pasted.

• Destination File Path : The File Path in which the sheet is to be pasted.IF you want to modify the same input file, the destination path is not required.

• Destination Sheet : String Argument The name of the sheet in which the sheet is to be pasted.

• Copy Method : The method that is used to copy-paste the excel sheet.

  • Cell Content: Copy-pastes the formula of the specified range

  • CellValue: Copy-pastes the value of the cell or value produced by the formula.