Copy Paste Sheet
Copies and pastes the contents of an excel sheet to another excel sheet.
Last updated
Copies and pastes the contents of an excel sheet to another excel sheet.
Last updated
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 : 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.
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.