CsvSourceOptions Class

Contains options used to extract data from the CSV file.

Namespace: DevExpress.DataAccess.Excel

Assembly: DevExpress.DataAccess.v18.1.dll

Declaration

C#

public class CsvSourceOptions :
    ExcelSourceOptionsBase

VB.NET

Public Class CsvSourceOptions
    Inherits ExcelSourceOptionsBase

Remarks

The ExcelDataSource class exposes the ExcelDataSource.SourceOptions property that accepts the ExcelSourceOptionsBase descendants (for instance, the CsvSourceOptions objects). The CsvSourceOptions class contains different options used to import data from the CSV file. For instance, the CsvSourceOptions.CellRange property allows you to specify the cell range from which data is imported.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the CsvSourceOptions class.

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#

Reporting_how-to-bind-a-report-to-a-csv-file-at-runtime-t311958/CS/BindingReportToCsvFile/Form1.cs#L32

// Specify import settings.
CsvSourceOptions csvSourceOptions = new CsvSourceOptions();
csvSourceOptions.DetectEncoding = true;

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

// Specify import settings.
CsvSourceOptions csvSourceOptions = new CsvSourceOptions();
csvSourceOptions.DetectEncoding = true;

snap-how-to-customize-the-data-explorer-panel-t535534/CS/CustomDataExplorer/Form1.cs#L58

// Specify import settings.
CsvSourceOptions csvSourceOptions = new CsvSourceOptions();
csvSourceOptions.DetectEncoding = true;

VB.NET

Reporting_how-to-bind-a-report-to-a-csv-file-at-runtime-t311958/VB/BindingReportToCsvFile/Form1.vb#L30

' Specify import settings.
Dim csvSourceOptions As New CsvSourceOptions()
csvSourceOptions.DetectEncoding = True

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

' Specify import settings.
Dim csvSourceOptions As New CsvSourceOptions()
csvSourceOptions.DetectEncoding = True

snap-how-to-customize-the-data-explorer-panel-t535534/VB/CustomDataExplorer/Form1.vb#L59

' Specify import settings.
Dim csvSourceOptions As New CsvSourceOptions()
csvSourceOptions.DetectEncoding = True

Inheritance

Object

ExcelSourceOptionsBase

CsvSourceOptions