Skip to main content

Append Range Workbook

Adds the information stored in a DataTable variable to the end of a specified Excel spreadsheet. If the sheet does not exist, a new one is created with the name indicated in the SheetName field.

Input​

  • Workbook Path: Full path of the workbook
    • Type: System.String
    • Required
  • Sheet Name: The name of the sheet from the workbook
    • Type: System.String
    • Required
  • Data Table: The DataTable object containing the input data
    • Type: System.Data.DataTable
    • Required

Options​

  • Password: The password of the Excel workbook, if necessary.
    • Type: System.String

Workbook​

  • Workbook: The existing workbook instance.
    • Type: DocumentFormat.OpenXml.Spreadsheet.Workbook
    • Required

Details​

  • This activity can be used even if Excel is not installed in the environment where the process runs.