Copy Paste Range
Copy and paste the range of excel sheet.
Last updated
Copy and paste the range of excel sheet.
Last updated
Copies an entire range of excel sheet and paste it to a specified excel sheet.
This activity can only be used after the Open Excel File activity.
Input : ExcelHandle Argument
A variable name that references the opened excel file handle.
Sheet Name : String Argument
The name of the sheet in which the range to be copied.
Source Range : String Argument
The range of the excel sheet in which the value is to be copied.
The range is specified in A1:E10or A1 format. A1:E10 will select all cells of the first five columns from row 1 to 10. A1 will select first cell from first row.
Destination File Path : String Argument
The File Path in which the range to be pasted. IF you want to modify the same input file, the destination path not required.
Destination Sheet : String Argument
The name of the sheet in which the range to be pasted.
Destination Cell : String Argument
The name of the starting cell in which the range to be pasted.
Copy Method : The method that is used to copy paste the range of excel.
CellContent - copy paste the formula of the specified range.
CellValue - copy paste the value of the cell or value produced by the formula.
The destination cell is specified in A1 format. A1 will select first cell from first row.
