Skip to main content

Write Range Workbook

Writes the data from a DataTable in a spreadsheet starting with the cell indicated in the StartingCell field.

Input​

  • Workbook Path: Contains the full path of the Excel workbook
    • Type: System.String
    • Required
  • DataTable: 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
  • Add Headers: When selected, column headers are also written to the specified range.
    • Type: System.Boolean

Destination​

  • Sheet Name: The name of the sheet from the workbook
    • Type: System.String
    • Required
  • Starting Cell: Specifies the starting cell(in range format) from which the input will be written
    • 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.