Skip to main content

Copy/Paste Range

Copies a range and optionally pastes it to another location.

Input​

  • Sheet Name: The Excel sheet to be processed
    • Type: System.String
  • Source Cells: The range from which the data will be copied
    • Type: System.String
    • Required
  • Destination Sheet Name: Destination sheet name.
    • Type: System.String
  • Destination Cells: The range where the copied data will be pasted
    • Type: System.String
    • Required
  • Exclude Source Headers: If marked, the headers are not copied when the data is copied, only the data itself is copied.
    • Type: System.Boolean
    • Required
  • Transpose: Insert columns as rows and rows as columns.
    • Type: System.Boolean
    • Required
  • What To Copy: The information about the type of data to be pasted.
    • Type: System.Int32
    • Required
    • Dropdown Options:
      • All
      • Values
      • Formulas
      • Formats

Details​

  • This activity can only be used within the Use Excel File activity. Excel application must be installed on the machine where the process will run.