Class ExcelRange

Namespace

OfficeOpenXml

Assembly

Magicodes.EPPlus.dll

public class ExcelRange : ExcelRangeBase, IEnumerable<ExcelRangeBase>, IEnumerable, IEnumerator<ExcelRangeBase>, IDisposable, IEnumerator

Inheritance

object

ExcelCellBase

ExcelAddressBase

ExcelAddress

ExcelRangeBase

ExcelRange

Implements

IEnumerable<ExcelRangeBase>

IEnumerable

IEnumerator<ExcelRangeBase>

IDisposable

IEnumerator

Inherited Members

ExcelRangeBase._worksheet

ExcelRangeBase._rtc

ExcelRangeBase.ChangeAddress()

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._fromRow

ExcelAddressBase._toRow

ExcelAddressBase._fromCol

ExcelAddressBase._toCol

ExcelAddressBase._fromRowFixed

ExcelAddressBase._fromColFixed

ExcelAddressBase._toRowFixed

ExcelAddressBase._toColFixed

ExcelAddressBase._wb

ExcelAddressBase._ws

ExcelAddressBase._address

ExcelAddressBase._start

ExcelAddressBase._end

ExcelAddressBase._table

ExcelAddressBase._addresses

ExcelAddressBase.SetAddress(string)

ExcelAddressBase.ToString()

ExcelAddressBase.Validate()

ExcelAddressBase.Start

ExcelAddressBase.End

ExcelAddressBase.Table

ExcelAddressBase.IsName

ExcelAddressBase.Rows

ExcelAddressBase.Columns

ExcelCellBase.TranslateFromR1C1(string, int, int)

ExcelCellBase.TranslateToR1C1(string, int, int)

ExcelCellBase.GetColumnLetter(int)

ExcelCellBase.GetColumnLetter(int, bool)

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

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)

Properties

this[int, int]

public ExcelRange this[int Row, int Col] { get; }

Parameters

Row int

Col int

Property Value

ExcelRange

this[int, int, int, int]

public ExcelRange this[int FromRow, int FromCol, int ToRow, int ToCol] { get; }

Parameters

FromRow int

FromCol int

ToRow int

ToCol int

Property Value

ExcelRange

this[string]

public ExcelRange this[string Address] { get; }

Parameters

Address string

Property Value

ExcelRange