Read range

Element getting data from the Excel cell range. The component works correctly only inside the Excel application container.

Properties

- Range: [String] Cell reader range (A1:D12)

- Sheet name: [String] Sheet name

- Sheet index: [Int32] Sheet index

- Variable (text): [List>] Variable for storing reading results

- Variable (info): [List>] Variable for storing reading results with cell info

LTools.Office.Model.ExcelCellInfo - Properties:

- Value: [LTools.Office.Model.CellValue] Cell value

- TextValue: [String] Cell text value

- BackroundColor: [System.Drawing.Color] Cell background color

LTools.Office.Model.CellValue - Свойства:

- DateTimeValue: [DateTime?] Data and time value

- BooleanValue: [bool?] Boolean value

- NumericValue: [double?] Numeric value

- TextValue: [string] Text value

- IsBoolean: [bool] boolean value‌ flag

- IsEmpty: [bool] Empty value‌ flag

- IsText: [bool] Text value‌ flag

- IsNumeric: [bool] Numeric value flag

- IsError: [bool] Error flag‌

- IsDateTime: [bool] Date-time value flag