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

• 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.

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.

• 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.