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.v23.2.dll

NuGet Packages: DevExpress.DataAccess, DevExpress.Win.PivotGrid, DevExpress.Win.TreeMap

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 snippets (auto-collected from DevExpress Examples) contain references 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;

reporting-winforms-bind-to-csv-file/CS/BindingReportToCsvFile/Form1.cs#L35

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

reporting-winforms-bind-to-csv-file/VB/BindingReportToCsvFile/Form1.vb#L28

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