Show / Hide Table of Contents

Class ExcelNamedRange

A named range.

Inheritance
System.Object
ExcelCellBase
ExcelAddressBase
ExcelAddress
ExcelRangeBase
ExcelNamedRange
Implements
System.Collections.Generic.IEnumerable<ExcelRangeBase>
System.Collections.IEnumerable
System.Collections.Generic.IEnumerator<ExcelRangeBase>
System.IDisposable
System.Collections.IEnumerator
Inherited Members
ExcelRangeBase._worksheet
ExcelRangeBase.AutoFilter
ExcelRangeBase.Comment
ExcelRangeBase.ConditionalFormatting
ExcelRangeBase.Current
ExcelRangeBase.DataValidation
ExcelRangeBase.Formula
ExcelRangeBase.FormulaR1C1
ExcelRangeBase.FullAddress
ExcelRangeBase.FullAddressAbsolute
ExcelRangeBase.Hyperlink
ExcelRangeBase.IsArrayFormula
ExcelRangeBase.IsRichText
ExcelRangeBase.Merge
ExcelRangeBase.RichText
ExcelRangeBase.Style
ExcelRangeBase.StyleID
ExcelRangeBase.StyleName
ExcelRangeBase.Text
ExcelRangeBase.Value
ExcelRangeBase.Worksheet
ExcelRangeBase.IEnumerator.Current
ExcelRangeBase.AddComment(String, String)
ExcelRangeBase.AutoFitColumns()
ExcelRangeBase.AutoFitColumns(Double)
ExcelRangeBase.AutoFitColumns(Double, Double)
ExcelRangeBase.Clear()
ExcelRangeBase.Copy(ExcelRangeBase)
ExcelRangeBase.CreateArrayFormula(String)
ExcelRangeBase.Dispose()
ExcelRangeBase.GetEnumerator()
ExcelRangeBase.GetValue<T>()
ExcelRangeBase.IEnumerable.GetEnumerator()
ExcelRangeBase.LoadFromArrays(IEnumerable<Object[]>)
ExcelRangeBase.LoadFromCollection<T>(IEnumerable<T>)
ExcelRangeBase.LoadFromCollection<T>(IEnumerable<T>, Boolean)
ExcelRangeBase.LoadFromCollection<T>(IEnumerable<T>, Boolean, TableStyles)
ExcelRangeBase.LoadFromCollection<T>(IEnumerable<T>, Boolean, TableStyles, BindingFlags, MemberInfo[])
ExcelRangeBase.LoadFromDataTable(DataTable, Boolean, TableStyles)
ExcelRangeBase.LoadFromDataTable(DataTable, Boolean)
ExcelRangeBase.LoadFromText(String)
ExcelRangeBase.LoadFromText(String, ExcelTextFormat)
ExcelRangeBase.LoadFromText(String, ExcelTextFormat, TableStyles, Boolean)
ExcelRangeBase.LoadFromText(FileInfo)
ExcelRangeBase.LoadFromText(FileInfo, ExcelTextFormat)
ExcelRangeBase.LoadFromText(FileInfo, ExcelTextFormat, TableStyles, Boolean)
ExcelRangeBase.MoveNext()
ExcelRangeBase.Offset(Int32, Int32)
ExcelRangeBase.Offset(Int32, Int32, Int32, Int32)
ExcelRangeBase.Reset()
ExcelAddress.Address
ExcelAddressBase._address
ExcelAddressBase._fromRow
ExcelAddressBase._toRow
ExcelAddressBase._fromCol
ExcelAddressBase._toCol
ExcelAddressBase._wb
ExcelAddressBase._ws
ExcelAddressBase.AddressChange
ExcelAddressBase.End
ExcelAddressBase.IsName
ExcelAddressBase.Start
ExcelAddressBase.GetAddress(String, String, String)
ExcelAddressBase.SetAddress(String)
ExcelAddressBase.Validate()
ExcelCellBase.GetAddress(Int32, Int32)
ExcelCellBase.GetAddress(Int32, Boolean, Int32, Boolean)
ExcelCellBase.GetAddress(Int32, Int32, Boolean)
ExcelCellBase.GetAddress(Int32, Int32, Int32, Int32)
ExcelCellBase.GetAddress(Int32, Int32, Int32, Int32, Boolean)
ExcelCellBase.GetFullAddress(String, String)
ExcelCellBase.IsValidCellAddress(String)
ExcelCellBase.TranslateFromR1C1(String, Int32, Int32)
ExcelCellBase.TranslateToR1C1(String, Int32, Int32)
ExcelCellBase.GetColumnLetter(Int32)
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
Namespace: Experior.Core.Data.OfficeOpenXml
Assembly: Experior.Core.dll
Syntax
public sealed class ExcelNamedRange : ExcelRangeBase, IExcelCell, IEnumerable<ExcelRangeBase>, IEnumerable, IEnumerator<ExcelRangeBase>, IDisposable, IEnumerator

Constructors

ExcelNamedRange(String, ExcelWorksheet, ExcelWorksheet, String)

A named range

Declaration
public ExcelNamedRange(string name, ExcelWorksheet nameSheet, ExcelWorksheet sheet, string address)
Parameters
Type Name Description
System.String name

The name

ExcelWorksheet nameSheet

The sheet containing the name. null if its a global name

ExcelWorksheet sheet

Sheet where the address points

System.String address

The address

Properties

IsNameHidden

Is the name hidden

Declaration
public bool IsNameHidden { get; set; }
Property Value
Type Description
System.Boolean

LocalSheetId

Is the named range local for the sheet

Declaration
public int LocalSheetId { get; }
Property Value
Type Description
System.Int32

Name

Name of the range

Declaration
public string Name { get; }
Property Value
Type Description
System.String

NameComment

A comment for the Name

Declaration
public string NameComment { get; set; }
Property Value
Type Description
System.String

Methods

ToString()

Declaration
public override string ToString()
Returns
Type Description
System.String
Overrides
ExcelAddressBase.ToString()

Implements

System.Collections.Generic.IEnumerable<T>
System.Collections.IEnumerable
System.Collections.Generic.IEnumerator<T>
System.IDisposable
System.Collections.IEnumerator
Back to top Generated by DocFX