ExcelDataSource.SourceOptions Property

Gets or sets options used to extract data from Microsoft Excel workbooks (XLS, XLSX or XLSM files) or CSV files.

Namespace: DevExpress.DataAccess.Excel

Assembly: DevExpress.DataAccess.v23.2.dll

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

Declaration

C#

[DefaultValue(null)]
[LocalizableCategory(DataAccessStringId.PropertyGridDataCategoryName)]
public ExcelSourceOptionsBase SourceOptions { get; set; }

VB.NET

<DefaultValue(Nothing)>
<LocalizableCategory(DataAccessStringId.PropertyGridDataCategoryName)>
Public Property SourceOptions As ExcelSourceOptionsBase

Property Value

Type	Default	Description
ExcelSourceOptionsBase	null	A ExcelSourceOptionsBase descendant containing options used to extract data from Microsoft Excel workbooks (XLS, XLSX or XLSM files) or CSV files.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the SourceOptions 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#L23

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

winforms-grid-open-excel-files/CS/Form1.cs#L21

var worksheetSettings = new ExcelWorksheetSettings("Sheet1", "A1:B3");
source.SourceOptions = new ExcelSourceOptions(worksheetSettings);
source.Fill();

reporting-web-forms-report-designer-add-data-sources/CS/WebApplication1/Default.aspx.cs#L45

excelDS.SourceOptions = excelSourceOptions1;

asp-net-mvc-grid-upload-excel-file-using-upload-control-and-display-data-in-grid/CS/T449148/Models/Model.cs#L34

excelSourceOptions.UseFirstRowAsHeader = true;
excelDataSource.SourceOptions = excelSourceOptions;

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

};
excelDataSource.SourceOptions = csvSourceOptions;

VB.NET

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

    csvSourceOptions.DetectValueSeparator = True
    excelDataSource.SourceOptions = csvSourceOptions
End Sub

winforms-grid-open-excel-files/VB/Form1.vb#L16

Dim worksheetSettings = New ExcelWorksheetSettings("Sheet1", "A1:B3")
source.SourceOptions = New ExcelSourceOptions(worksheetSettings)
source.Fill()

reporting-web-forms-report-designer-add-data-sources/VB/WebApplication1/Default.aspx.vb#L44

excelDS.SourceOptions = excelSourceOptions1

asp-net-mvc-grid-upload-excel-file-using-upload-control-and-display-data-in-grid/VB/T449148_VB/Models/Model.vb#L19

excelSourceOptions.UseFirstRowAsHeader = True
excelDataSource.SourceOptions = excelSourceOptions
excelDataSource.Fill()

reporting-winforms-bind-excel-runtime/VB/BindingReportToExcelWorkbook/Form1.vb#L31

excelSourceOptions.SkipHiddenColumns = False
excelDataSource.SourceOptions = excelSourceOptions
' Create new fields and specify their settings.