Skip to main content

Clone Range

Copies a range of cells to a destination location, optionally in a different Excel file or sheet. Unlike Copy/Paste Range, this node performs the operation in one step.

Common Properties​

  • Name - The custom name of the node.
  • Color - The custom color of the node.
  • Delay Before (sec) - Waits in seconds before executing the node.
  • Delay After (sec) - Waits in seconds after executing the node.
  • Continue On Error - Automation will continue regardless of any error. The default value is false.
info

If ContinueOnError property is true, no error is caught when the project is executed even if the Catch node is used.

Input​

  • File Descriptor - File descriptor of the source Excel file. This is the identifier returned by the Open Excel node.
  • Source From Cell - Starting cell of the source range (e.g., A1). Required when Source Range is "Specific-Range".
  • Source To Cell - Ending cell of the source range (e.g., C10). Required when Source Range is "Specific-Range".
  • Destination Start Cell - Starting cell address in the destination where the range will be copied (e.g., A1, F5).

Output​

This node has no output.

Options​

  • Source Range - Whether to clone all used cells or a specific range:
    • Specific-Range - Clone a specific range (requires Source From Cell and Source To Cell)
    • All-Range - Clone all cells with data in the active sheet
  • Destination Excel Path - (Optional) Path to a different Excel file. Leave empty to copy within the same file.
  • Destination Sheet Index - (Optional) Sheet index in the destination file (1-based). Leave empty to use the active sheet.

Example​

Cloning within the same sheet:

// File Descriptor: message.excel_fd
// Source From Cell: "A1"
// Source To Cell: "D10"
// Source Range: Specific-Range
// Destination Start Cell: "F1"
// Copies A1:D10 to F1:I10

Cloning to a different sheet:

// Source From Cell: "A1"
// Source To Cell: "C5"
// Source Range: Specific-Range
// Destination Start Cell: "A1"
// Destination Sheet Index: 2
// Copies data to sheet 2

Cloning to a different Excel file:

// Source Range: All-Range
// Destination Start Cell: "A1"
// Destination Excel Path: "C:\\Reports\\destination.xlsx"
// Destination Sheet Index: 1
// Copies all data to a different file

Cloning entire sheet content:

// Source Range: All-Range
// Destination Start Cell: "A1"
// Destination Sheet Index: 3
// Copies all used cells to sheet 3

Tips​

  • This node combines copy and paste in a single operation.
  • When Destination Excel Path is provided, the destination file is opened, modified, and saved automatically.
  • Both values and formatting (colors, borders, fonts) are cloned.
  • If cloning to a different file, the destination file is saved and closed after the operation.
  • Sheet indices are 1-based (first sheet is 1, second is 2, etc.).

Common Errors​

ErrorSolution
Source From Cell cannot be empty when Source Range is Specific-RangeProvide a starting source cell address
Source To Cell cannot be empty when Source Range is Specific-RangeProvide an ending source cell address
Destination Start Cell cannot be emptyProvide a destination starting cell
Sheet Index is not validEnsure the index is a valid integer
Sheet Index must be equal or greater than 1Use 1-based indexing
Destination file not foundVerify the destination Excel path is correct
Invalid File DescriptorEnsure the Open Excel node was executed first