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.