Skip to main content

SpreadsheetCsvImportOptions.AutoDetectDelimiter Property

Gets or sets a value indicating whether to automatically detect a character separating values in the CSV file. This is a dependency property.

Namespace: DevExpress.Xpf.Spreadsheet

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

NuGet Package: DevExpress.Wpf.Spreadsheet

Declaration

public bool AutoDetectDelimiter { get; set; }

Property Value

Type Description
Boolean

true, to autodetect a delimiter; otherwise, false.

Property Paths

You can access this nested property as listed below:

Object Type Path to AutoDetectDelimiter
SpreadsheetImportOptions
.Csv .AutoDetectDelimiter

Remarks

Use the SpreadsheetCsvImportOptions.MaxRowCountToAutoDetectDelimiter property to specify the number of rows that should be analyzed to automatically detect a character separating values in the CSV file. The default value is 10.

To explicitly specify a character that separates values in the imported CSV document, use the SpreadsheetCsvImportOptions.Delimiter property.

If the AutoDetectDelimiter property is false and the SpreadsheetCsvImportOptions.Delimiter value is not specified, the importer uses a delimiter corresponding to the current culture.

See Also