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.Collections.IEnumerator
System.IDisposable
Inherited Members
ExcelRangeBase._worksheet
ExcelRangeBase.ChangeAddress()
ExcelRangeBase.Style
ExcelRangeBase.StyleName
ExcelRangeBase.StyleID
ExcelRangeBase.Value
ExcelRangeBase.Text
ExcelRangeBase.AutoFitColumns()
ExcelRangeBase.AutoFitColumns(Double)
ExcelRangeBase.AutoFitColumns(Double, Double)
ExcelRangeBase.Formula
ExcelRangeBase.FormulaR1C1
ExcelRangeBase.Hyperlink
ExcelRangeBase.Merge
ExcelRangeBase.AutoFilter
ExcelRangeBase.IsRichText
ExcelRangeBase.Insert(eShiftTypeInsert)
ExcelRangeBase.Delete(eShiftTypeDelete)
ExcelRangeBase.IsArrayFormula
ExcelRangeBase._rtc
ExcelRangeBase.RichText
ExcelRangeBase.Comment
ExcelRangeBase.Worksheet
ExcelRangeBase.FullAddress
ExcelRangeBase.FullAddressAbsolute
ExcelRangeBase.ConditionalFormatting
ExcelRangeBase.DataValidation
ExcelRangeBase.GetValue<T>()
ExcelRangeBase.Offset(Int32, Int32)
ExcelRangeBase.Offset(Int32, Int32, Int32, Int32)
ExcelRangeBase.AddComment(String, String)
ExcelRangeBase.Copy(ExcelRangeBase)
ExcelRangeBase.Copy(ExcelRangeBase, Nullable<ExcelRangeCopyOptionFlags>)
ExcelRangeBase.Clear()
ExcelRangeBase.CreateArrayFormula(String)
ExcelRangeBase.Dispose()
ExcelRangeBase.GetEnumerator()
ExcelRangeBase.IEnumerable.GetEnumerator()
ExcelRangeBase.Current
ExcelRangeBase.IEnumerator.Current
ExcelRangeBase.MoveNext()
ExcelRangeBase.Reset()
ExcelRangeBase.Sort()
ExcelRangeBase.Sort(Int32, Boolean)
ExcelRangeBase.Sort(Int32[], Boolean[], CultureInfo, CompareOptions)
ExcelRangeBase.LoadFromDataReader(IDataReader, Boolean, String, TableStyles)
ExcelRangeBase.LoadFromDataReader(IDataReader, Boolean)
ExcelRangeBase.LoadFromDataReaderAsync(DbDataReader, Boolean, String, TableStyles, Nullable<CancellationToken>)
ExcelRangeBase.LoadFromDataReaderAsync(DbDataReader, Boolean)
ExcelRangeBase.LoadFromDataReaderAsync(DbDataReader, Boolean, CancellationToken)
ExcelRangeBase.LoadFromDataTable(DataTable, Boolean, TableStyles)
ExcelRangeBase.LoadFromDataTable(DataTable, Boolean)
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.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.LoadFromTextAsync(FileInfo)
ExcelRangeBase.LoadFromTextAsync(FileInfo, ExcelTextFormat)
ExcelRangeBase.LoadFromTextAsync(FileInfo, ExcelTextFormat, TableStyles, Boolean)
ExcelRangeBase.ToText()
ExcelRangeBase.ToText(ExcelOutputTextFormat)
ExcelRangeBase.SaveToText(FileInfo, ExcelOutputTextFormat)
ExcelRangeBase.SaveToText(Stream, ExcelOutputTextFormat)
ExcelRangeBase.ToTextAsync()
ExcelRangeBase.ToTextAsync(ExcelOutputTextFormat)
ExcelRangeBase.SaveToTextAsync(FileInfo, ExcelOutputTextFormat)
ExcelRangeBase.SaveToTextAsync(Stream, ExcelOutputTextFormat)
ExcelAddress.Address
ExcelAddressBase.SetAddress(String)
ExcelAddressBase.Start
ExcelAddressBase.End
ExcelAddressBase.Table
ExcelAddressBase.IsName
ExcelAddressBase.Validate()
ExcelAddressBase.Rows
ExcelAddressBase.Columns
ExcelAddressBase.IsFullRow
ExcelAddressBase.IsFullColumn
ExcelCellBase.TranslateFromR1C1(String, Int32, Int32)
ExcelCellBase.TranslateToR1C1(String, Int32, Int32)
ExcelCellBase.GetColumnLetter(Int32)
ExcelCellBase.GetColumnLetter(Int32, Boolean)
ExcelCellBase.GetAddressRow(Int32, Boolean)
ExcelCellBase.GetAddressCol(Int32, Boolean)
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.GetAddress(Int32, Int32, Int32, Int32, Boolean, Boolean, Boolean, Boolean)
ExcelCellBase.GetFullAddress(String, String)
ExcelCellBase.GetFullAddress(String, String, String)
ExcelCellBase.IsValidAddress(String)
ExcelCellBase.IsValidCellAddress(String)
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
Namespace: OfficeOpenXml
Assembly: EPPlus.dll
Syntax
public sealed class ExcelNamedRange : ExcelRangeBase, IExcelCell, IEnumerable<ExcelRangeBase>, IEnumerable, IEnumerator<ExcelRangeBase>, IEnumerator, IDisposable

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()

Returns a string representation of the object

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

The name of the range

Overrides
ExcelAddressBase.ToString()

Implements

System.Collections.Generic.IEnumerable<T>
System.Collections.IEnumerable
System.Collections.Generic.IEnumerator<T>
System.Collections.IEnumerator
System.IDisposable

Extension Methods

CalculationExtension.Calculate(ExcelRangeBase)
CalculationExtension.Calculate(ExcelRangeBase, ExcelCalculationOption)
Back to top Generated by DocFX