Skip to main content

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.v23.2.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
.Txt .CellIndexOutOfRangeStrategy

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