Show / Hide Table of Contents

Class ExcelRange

A range of cells.

Inheritance
System.Object
ExcelCellBase
ExcelAddressBase
ExcelAddress
ExcelRangeBase
ExcelRange
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.ToString()
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 class ExcelRange : ExcelRangeBase, IExcelCell, IEnumerable<ExcelRangeBase>, IEnumerable, IEnumerator<ExcelRangeBase>, IEnumerator, IDisposable

Properties

Item[Int32, Int32]

Access a single cell

Declaration
public ExcelRange this[int Row, int Col] { get; }
Parameters
Type Name Description
System.Int32 Row

The row

System.Int32 Col

The column

Property Value
Type Description
ExcelRange

A range object

Item[Int32, Int32, Int32, Int32]

Access a range of cells

Declaration
public ExcelRange this[int FromRow, int FromCol, int ToRow, int ToCol] { get; }
Parameters
Type Name Description
System.Int32 FromRow

Start row

System.Int32 FromCol

Start column

System.Int32 ToRow

End Row

System.Int32 ToCol

End Column

Property Value
Type Description
ExcelRange

Item[String]

Access the range using an address

Declaration
public ExcelRange this[string Address] { get; }
Parameters
Type Name Description
System.String Address

The address

Property Value
Type Description
ExcelRange

A range object

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