CsvSourceOptions.DetectValueSeparator Property

Gets or sets whether a character used to separate values in a CSV document is determined automatically.

Namespace: DevExpress.DataAccess.Excel

Assembly: DevExpress.DataAccess.v18.2.dll

Declaration

C#

[DefaultValue(false)]
public bool DetectValueSeparator { get; set; }

VB.NET

<DefaultValue(False)>
Public Property DetectValueSeparator As Boolean

Property Value

Type	Default	Description
Boolean	**false**	true, to determine a character used to separate values automatically; otherwise, false.

Remarks

Use the CsvDocumentExporterOptions.ValueSeparator property to specify the character used to separate values in a CSV document.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the DetectValueSeparator property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

how-to-create-data-access-library-data-sources-at-runtime-t424210/CS/ExcelDataSourceSnippets/Code.cs#L22

csvSourceOptions.DetectNewlineType = true;
csvSourceOptions.DetectValueSeparator = true;
excelDataSource.SourceOptions = csvSourceOptions;

VB.NET

how-to-create-data-access-library-data-sources-at-runtime-t424210/VB/ExcelDataSourceSnippets/Code.vb#L20

csvSourceOptions.DetectNewlineType = True
csvSourceOptions.DetectValueSeparator = True
excelDataSource.SourceOptions = csvSourceOptions