SpreadsheetTxtImportOptions.CellIndexOutOfRangeStrategy Property

Gets or sets the action performed when the spreadsheet cannot assign imported data to a cell. This is a dependency property.

Namespace: DevExpress.Xpf.Spreadsheet

Assembly: DevExpress.Xpf.Spreadsheet.v24.1.dll

NuGet Package: DevExpress.Wpf.Spreadsheet

Declaration

C#

public CsvImportCellIndexStrategy CellIndexOutOfRangeStrategy { get; set; }

VB.NET

Public Property CellIndexOutOfRangeStrategy As CsvImportCellIndexStrategy

Property Value

Type	Description
CsvImportCellIndexStrategy	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
SpreadsheetImportOptions	.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.