Skip to main content

Read Range Workbook

Reads the value of an Excel range and stores it in a DataTable variable.

Input​

  • Workbook Path: The full path of the Excel spreadsheet that you want to use.
    • Type: System.String
    • Required
  • Sheet Name: The name of the sheet in which the range that you want to read is
    • Type: System.String
    • Required
  • Range: Specifies the range of cells to be read
    • Type: System.String

Options​

  • Password: The password of the Excel workbook, if necessary.
    • Type: System.String
  • Has Headers: When selected, the column headers from the specified spreadsheet range are also extracted. By default, this check box is not selected.
    • Type: System.Boolean

Output​

  • Data Table: Stores the data extracted from the specified Excel range in a data table variable. Only data table variables are supported.
    • Type: System.Data.DataTable

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.