Copy Paste Range
Copy and paste the range of excel sheet.
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
The range is specified in A1:E10
or 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.
Options
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.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.
Last updated