TxtDocumentImporterOptions.AutoDetectDelimiter Property

Gets or sets a value indicating whether to automatically detect a character separating values in the text file.

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(true)]
public override bool AutoDetectDelimiter { get; set; }

VB.NET

<DefaultValue(True)>
Public Overrides Property AutoDetectDelimiter As Boolean

Property Value

Type	Default	Description
Boolean	**true**	true, to autodetect a delimiter; otherwise, false.

Property Paths

You can access this nested property as listed below:

Object Type	Path to AutoDetectDelimiter
WorkbookImportOptions	.Txt .AutoDetectDelimiter

Remarks

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

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

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