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.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.ToString()
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 class ExcelRange : ExcelRangeBase, IExcelCell, IEnumerable<ExcelRangeBase>, IEnumerable, IEnumerator<ExcelRangeBase>, IDisposable, IEnumerator

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.IDisposable
System.Collections.IEnumerator
Back to top Generated by DocFX