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

NuGet Package : DevExpress.DataAccess

Declaration

C#
VB.NET

csharp

public sealed class ExcelDefinedNameSettings :
    ExcelSettingsBase

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