Skip to main content

Read Range

Read desired range from given Excel file.

Input​

  • Range: The range to be read
    • Type: System.String
  • Sheet Name: It must be entered when you want to read a sheet other than the active sheet
    • Type: System.String

Options​

  • Has Headers: If checked, it reads from the second row onwards.
    • Type: System.Boolean
    • Required
  • Visible Rows Only: If checked, it does not read hidden rows.
    • Type: System.Boolean
    • Required
  • Read Formatting: Select what formatting should be applied to the values.
    • Type: System.Int32
    • Required
    • Dropdown Options:
      • (null)
      • Default
      • Raw Value
      • Display Value

Input/Output​

  • Save to: The area where the data read from Excel can be used as a data table. When a data table with defined columns is used as input, the data read from Excel is written to this data table according to the specified data types. Otherwise, the types of data read from Excel are determined automatically. For a more accurate data reading process, it is recommended to provide a data table.
    • Type: System.Data.DataTable

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.