1. Home
  2. Docs
  3. EXCEL Activities
  4. WorkSheet
  5. ReadRange

ReadRange

Aiwozo.Excelfile.Core.Activities.ReadRange

  • ReadRange activity is used to read the value of an excel range and stores it in a Datatable
  • If the range isnโ€™t specified, the whole spreadsheet is read.
  • If the range is specified as a cell, the whole spreadsheet starting from that cell is read.
  • This activity only works inside the excel application scope.

Properties

ย  ย  ย  Misc

  • CellRange (InArgument<String>) –Define the range that needs to be read.
  • DisplayName (String) โ€“ To set a meaningful name according to the user.
  • Output (OutArgument<DataTable>) – Stores the data extracted from the specified excel range in a DataTable
  • SheetName (InArgument<String>) โ€“ The name of the sheet whose range needs to be read.