Skip to main content

Copy Sheet

Copies and pastes the given sheet to target workbook.

Input

  • Sheet Name: Sheet name to copy. (Will copy active sheet if not given)
    • Type: System.String

Options

  • Copy To New Workbook: Copies the sheet to new workbook if true, to active workbook if false.
    • Type: System.Boolean
    • Required
  • New Worksheet Name: The name of the new worksheet
    • Type: System.String
  • Destination Workbook: If you want to copy sheet to an existing workbook, write full path here.
    • Type: System.String
  • New Workbook Name: If you want to create new workbook and name it, write workbook name here. (Must be given with full path and extension.)
    • Type: System.String

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.