ExcelSourceOptions.ImportSettings Property

Gets or sets settings used to import data from the Microsoft Excel workbook.

Namespace: DevExpress.DataAccess.Excel

Assembly: DevExpress.DataAccess.v20.1.dll

Declaration

[DefaultValue(null)]
[LocalizableCategory(DataAccessStringId.PropertyGridDataCategoryName)]
public ExcelSettingsBase ImportSettings { get; set; }
<DefaultValue(Nothing)>
<LocalizableCategory(DataAccessStringId.PropertyGridDataCategoryName)>
Public Property ImportSettings As ExcelSettingsBase

Property Value

Type Default Description
ExcelSettingsBase

null

A ExcelSettingsBase descendant containing settings used to import data from the Microsoft Excel workbook.

Remarks

The ImportSettings property exposed by the ExcelSourceOptions class allows you to specify the approach used to import data from a workbook. For instance, you can select all data from the specified worksheet or specify the required cell range. To import data from the workbook, create the required ExcelSettingsBase object descendant and specify its settings.

See Also