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

Declaration

C#

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

VB.NET

<DefaultValue(Nothing)>
<LocalizableCategory(DataAccessStringId.PropertyGridDataCategoryName)>
<TypeConverter(GetType(ExcelDataSource.ExcelObscuredTypeConverter))>
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_how-to-provide-aspxreportdesigner-with-the-sqldatasource-objectdatasource-t271722/CS/WebApplication1/Default.aspx.cs#L47

exds.SourceOptions = excelSourceOptions1;

how-to-bind-a-snap-document-to-multiple-data-sources-in-code-e4784/CS/MultipleDataSources/Form1.cs#L39

ExcelWorksheetSettings worksheetSettings = new ExcelWorksheetSettings("Sales report", "B2:H18");
myExcelSource.SourceOptions = new ExcelSourceOptions(worksheetSettings);
myExcelSource.SourceOptions.UseFirstRowAsHeader = true;

gridview-how-to-upload-an-excel-file-via-uploadcontrol-and-display-its-data-in-a-grid-t449148/CS/T449148/Models/Model.cs#L34

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

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_how-to-provide-aspxreportdesigner-with-the-sqldatasource-objectdatasource-t271722/VB/WebApplication1/Default.aspx.vb#L45

exds.SourceOptions = excelSourceOptions1

gridview-how-to-upload-an-excel-file-via-uploadcontrol-and-display-its-data-in-a-grid-t449148/VB/T449148_VB/Models/Model.vb#L19

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

winforms-designer-how-to-create-the-grids-hyperlink-column-in-code-t568804/VB/Dashboard_GridHyperlinkColumn/Form1.vb#L16

excelDataSource.FileName = "..\..\Data\GDPByCountry.xlsx"
excelDataSource.SourceOptions = New ExcelSourceOptions(New ExcelWorksheetSettings("Sheet1"))
dashboard.DataSources.Add(excelDataSource)