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.v20.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

NuGet Packages: DevExpress.Spreadsheet.Core, DevExpress.WindowsDesktop.Spreadsheet.Core

Declaration

C#

[DefaultValue(CsvImportCellIndexStrategy.Stop)]
public override CsvImportCellIndexStrategy CellIndexOutOfRangeStrategy { get; set; }

VB.NET

<DefaultValue(CsvImportCellIndexStrategy.Stop)>
Public Overrides Property CellIndexOutOfRangeStrategy As CsvImportCellIndexStrategy

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.