Skip to main content

Read Column Workbook

Reads the value of an Excel column and stores it in a variable

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
  • Starting Cell: Specifies the starting cell from which the column is read.
    • Type: System.String
    • Required

Options​

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

Output​

  • Result: Column result as IEnumerable
    • Type: System.Collections.Generic.IEnumerable<System.Object>

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.