TxtDocumentImporterOptions.CellIndexOutOfRangeStrategy Property
Gets or sets the action performed when the spreadsheet cannot assign imported data to a cell.
Namespace: DevExpress.XtraSpreadsheet.Import
Assembly: DevExpress.Spreadsheet.v24.1.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
Declaration
[DefaultValue(CsvImportCellIndexStrategy.Stop)]
public override CsvImportCellIndexStrategy CellIndexOutOfRangeStrategy { get; set; }Property Value
| Type | Default | Description |
|---|---|---|
| CsvImportCellIndexStrategy | Stop | A CsvImportCellIndexStrategy enumeration value. |
Available values:
| Name | Description |
|---|---|
| Stop | Stop import. |
| Throw | Throws InvalidOperationException. |
Property Paths
You can access this nested property as listed below:
| Object Type | Path to CellIndexOutOfRangeStrategy |
|---|---|
| WorkbookImportOptions |
|
Remarks
The CellIndexOutOfRangeStrategy option allows you to throw an exception when imported data cannot be assigned to a spreadsheet cell due to an incorrect column or row index.
See Also