ExcelDefinedNameSettings Class

Contains options used to select data from a range of cells specified using the defined name.

Namespace: DevExpress.DataAccess.Excel

Assembly: DevExpress.DataAccess.v24.1.dll

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

Declaration

C#

public sealed class ExcelDefinedNameSettings :
    ExcelSettingsBase

VB.NET

Public NotInheritable Class ExcelDefinedNameSettings
    Inherits ExcelSettingsBase

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 select a range of cells specified using the defined name, create the ExcelDefinedNameSettings object and specify the defined name using the ExcelDefinedNameSettings.DefinedName property. If applicable, specify a defined name scope using the ExcelDefinedNameSettings.Scope property.

Inheritance

Object

ExcelSettingsBase

ExcelDefinedNameSettings