Class ExcelNamedRange

Namespace

OfficeOpenXml

Assembly

Magicodes.EPPlus.dll

public sealed class ExcelNamedRange : ExcelRangeBase, IEnumerable<ExcelRangeBase>, IEnumerable, IEnumerator<ExcelRangeBase>, IDisposable, IEnumerator

Inheritance

object

ExcelCellBase

ExcelAddressBase

ExcelAddress

ExcelRangeBase

ExcelNamedRange

Implements

IEnumerable<ExcelRangeBase>

IEnumerable

IEnumerator<ExcelRangeBase>

IDisposable

IEnumerator

Inherited Members

ExcelRangeBase.AutoFitColumns()

ExcelRangeBase.AutoFitColumns(double)

ExcelRangeBase.AutoFitColumns(double, double)

ExcelRangeBase.LoadFromDataReader(IDataReader, bool, string, TableStyles)

ExcelRangeBase.LoadFromDataReader(IDataReader, bool)

ExcelRangeBase.LoadFromDataTable(DataTable, bool, TableStyles)

ExcelRangeBase.LoadFromDataTable(DataTable, bool)

ExcelRangeBase.LoadFromArrays(IEnumerable<object[]>)

ExcelRangeBase.LoadFromCollection<T>(IEnumerable<T>)

ExcelRangeBase.LoadFromCollection<T>(IEnumerable<T>, bool)

ExcelRangeBase.LoadFromCollection<T>(IEnumerable<T>, bool, TableStyles)

ExcelRangeBase.LoadFromCollection<T>(IEnumerable<T>, bool, TableStyles, BindingFlags, MemberInfo[])

ExcelRangeBase.LoadFromText(string)

ExcelRangeBase.LoadFromText(string, ExcelTextFormat)

ExcelRangeBase.LoadFromText(string, ExcelTextFormat, TableStyles, bool)

ExcelRangeBase.LoadFromText(FileInfo)

ExcelRangeBase.LoadFromText(FileInfo, ExcelTextFormat)

ExcelRangeBase.LoadFromText(FileInfo, ExcelTextFormat, TableStyles, bool)

ExcelRangeBase.GetValue<T>()

ExcelRangeBase.Offset(int, int)

ExcelRangeBase.Offset(int, int, int, int)

ExcelRangeBase.AddComment(string, string)

ExcelRangeBase.Copy(ExcelRangeBase)

ExcelRangeBase.Copy(ExcelRangeBase, ExcelRangeCopyOptionFlags?)

ExcelRangeBase.Clear()

ExcelRangeBase.CreateArrayFormula(string)

ExcelRangeBase.Dispose()

ExcelRangeBase.GetEnumerator()

ExcelRangeBase.MoveNext()

ExcelRangeBase.Reset()

ExcelRangeBase.Sort()

ExcelRangeBase.Sort(int, bool)

ExcelRangeBase.Sort(int[], bool[], CultureInfo, CompareOptions)

ExcelRangeBase.LoadFromDictionaries(IEnumerable<IDictionary<string, object>>)

ExcelRangeBase.LoadFromDictionaries(IEnumerable<IDictionary<string, object>>, bool)

ExcelRangeBase.LoadFromDictionaries(IEnumerable<IDictionary<string, object>>, bool, TableStyles)

ExcelRangeBase.LoadFromDictionaries(IEnumerable<IDictionary<string, object>>, bool, TableStyles, IEnumerable<string>)

ExcelRangeBase.LoadFromDictionaries(IEnumerable<IDictionary<string, object>>, Action<LoadFromDictionariesParams>)

ExcelRangeBase.Style

ExcelRangeBase.StyleName

ExcelRangeBase.StyleID

ExcelRangeBase.Value

ExcelRangeBase.Text

ExcelRangeBase.Formula

ExcelRangeBase.FormulaR1C1

ExcelRangeBase.Hyperlink

ExcelRangeBase.Merge

ExcelRangeBase.AutoFilter

ExcelRangeBase.IsRichText

ExcelRangeBase.IsArrayFormula

ExcelRangeBase.RichText

ExcelRangeBase.Comment

ExcelRangeBase.Worksheet

ExcelRangeBase.FullAddress

ExcelRangeBase.FullAddressAbsolute

ExcelRangeBase.ConditionalFormatting

ExcelRangeBase.DataValidation

ExcelRangeBase.Current

ExcelAddress.Address

ExcelAddressBase.Start

ExcelAddressBase.End

ExcelAddressBase.Table

ExcelAddressBase.IsName

ExcelAddressBase.Rows

ExcelAddressBase.Columns

ExcelCellBase.TranslateFromR1C1(string, int, int)

ExcelCellBase.TranslateToR1C1(string, int, int)

ExcelCellBase.GetAddressRow(int, bool)

ExcelCellBase.GetAddressCol(int, bool)

ExcelCellBase.GetAddress(int, int)

ExcelCellBase.GetAddress(int, bool, int, bool)

ExcelCellBase.GetAddress(int, int, bool)

ExcelCellBase.GetAddress(int, int, int, int)

ExcelCellBase.GetAddress(int, int, int, int, bool)

ExcelCellBase.GetAddress(int, int, int, int, bool, bool, bool, bool)

ExcelCellBase.GetFullAddress(string, string)

ExcelCellBase.IsValidAddress(string)

ExcelCellBase.IsValidCellAddress(string)

object.GetType()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Extension Methods

CalculationExtension.Calculate(ExcelRangeBase)

CalculationExtension.Calculate(ExcelRangeBase, ExcelCalculationOption)

ExtensionMethods.IsNumeric(object)

Constructors

ExcelNamedRange(string, ExcelWorksheet, ExcelWorksheet, string, int)

public ExcelNamedRange(string name, ExcelWorksheet nameSheet, ExcelWorksheet sheet, string address, int index)

Parameters

name string

nameSheet ExcelWorksheet

sheet ExcelWorksheet

address string

index int

Properties

IsNameHidden

public bool IsNameHidden { get; set; }

Property Value

bool

LocalSheetId

public int LocalSheetId { get; }

Property Value

int

Name

public string Name { get; }

Property Value

string

NameComment

public string NameComment { get; set; }

Property Value

string

Methods

ToString()

public override string ToString()

Returns

string