Append range

Element that writes data of cell range into Excel

Properties

- Range*: [String] Cells range (A1:D12)‌

- Sheet name: [String] Sheet name

- Sheet index: [Int32] Sheet index

- Overwrite: [Boolean] Flag of data overwrite

- Variable (текст): [List<List<string>>] Variable to store cell range text

- Variable (information): [List<List<LTools.Office.Model.ExcelCellInfo>>] Variable to store results of cell reading.

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 - Properties:‌

- 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