ExcelSettingsBase Class

Serves as the base for classes containing settings used to import data from the Microsoft Excel workbook.

Namespace: DevExpress.DataAccess.Excel

Assembly: DevExpress.DataAccess.v23.2.dll

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

Declaration

C#

public abstract class ExcelSettingsBase :
    ICloneable

VB.NET

Public MustInherit Class ExcelSettingsBase
    Implements ICloneable

Related API Members

The following members return ExcelSettingsBase objects:

• ExcelSourceOptions.ImportSettings

Remarks

The ExcelSourceOptions.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.

Inheritance

Object

ExcelSettingsBase

ExcelDefinedNameSettings

ExcelTableSettings

ExcelWorksheetSettings