Class ExcelRange

Namespace

OfficeOpenXml

Assembly

EPPlus.dll

A range of cells.

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.SetErrorValue(eErrorType)

ExcelRangeBase.AutoFitColumns()

ExcelRangeBase.AutoFitColumns(double)

ExcelRangeBase.AutoFitColumns(double, double)

ExcelRangeBase.CreateHtmlExporter()

ExcelRangeBase.SetHyperlink(Uri)

ExcelRangeBase.SetHyperlink(ExcelHyperLink)

ExcelRangeBase.SetHyperlink(ExcelRange, string)

ExcelRangeBase.SetHyperlink(ExcelRange)

ExcelRangeBase.GetTable()

ExcelRangeBase.Insert(eShiftTypeInsert)

ExcelRangeBase.Delete(eShiftTypeDelete)

ExcelRangeBase.ClearFormulas()

ExcelRangeBase.ClearFormulaValues()

ExcelRangeBase.GetValue<T>()

ExcelRangeBase.Offset(int, int)

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

ExcelRangeBase.AddComment(string, string)

ExcelRangeBase.AddThreadedComment()

ExcelRangeBase.Copy(ExcelRangeBase)

ExcelRangeBase.Copy(ExcelRangeBase, ExcelRangeCopyOptionFlags?)

ExcelRangeBase.Copy(ExcelRangeBase, params ExcelRangeCopyOptionFlags[])

ExcelRangeBase.CopyStyles(ExcelRangeBase)

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.Sort(Action<RangeSortOptions>)

ExcelRangeBase.Sort(RangeSortOptions)

ExcelRangeBase.GetCellValue<T>()

ExcelRangeBase.GetCellValue<T>(int)

ExcelRangeBase.GetCellValue<T>(int, int)

ExcelRangeBase.SetCellValue(int, int, object)

ExcelRangeBase.FillNumber()

ExcelRangeBase.FillNumber(double?, double)

ExcelRangeBase.FillNumber(Action<FillNumberParams>)

ExcelRangeBase.FillDateTime()

ExcelRangeBase.FillDateTime(DateTime?, eDateTimeUnit, int)

ExcelRangeBase.FillDateTime(Action<FillDateParams>)

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

ExcelRangeBase.FillList<T>(IEnumerable<T>, Action<FillListParams>)

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

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

ExcelRangeBase.LoadFromDataReader(IDataReader, bool)

ExcelRangeBase.LoadFromDataReader(IDataReader, bool, bool)

ExcelRangeBase.LoadFromDataReaderAsync(DbDataReader, bool, string, TableStyles, CancellationToken?)

ExcelRangeBase.LoadFromDataReaderAsync(DbDataReader, bool, string, bool, TableStyles, CancellationToken?)

ExcelRangeBase.LoadFromDataReaderAsync(DbDataReader, bool)

ExcelRangeBase.LoadFromDataReaderAsync(DbDataReader, bool, bool)

ExcelRangeBase.LoadFromDataReaderAsync(DbDataReader, bool, CancellationToken)

ExcelRangeBase.LoadFromDataReaderAsync(DbDataReader, bool, CancellationToken, bool)

ExcelRangeBase.LoadFromDataTable(DataTable, bool, TableStyles?)

ExcelRangeBase.LoadFromDataTable(DataTable, bool, TableStyles?, bool)

ExcelRangeBase.LoadFromDataTable(DataTable, bool)

ExcelRangeBase.LoadFromDataTable(DataTable)

ExcelRangeBase.LoadFromDataTable(DataTable, Action<LoadFromDataTableParams>)

ExcelRangeBase.LoadFromArrays(IEnumerable<object[]>)

ExcelRangeBase.LoadFromArraysTransposed(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?, bool)

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

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

ExcelRangeBase.LoadFromCollection<T>(IEnumerable<T>, Action<LoadFromCollectionParams>)

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.LoadFromText(string, ExcelTextFormatFixedWidth)

ExcelRangeBase.LoadFromText(FileInfo, ExcelTextFormatFixedWidth)

ExcelRangeBase.LoadFromTextAsync(FileInfo)

ExcelRangeBase.LoadFromTextAsync(FileInfo, ExcelTextFormat)

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

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<dynamic>, bool, TableStyles?, IEnumerable<string>)

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

ExcelRangeBase.LoadFromDictionaries(IEnumerable<dynamic>, Action<LoadFromDictionariesParams>)

ExcelRangeBase.ToDataTable()

ExcelRangeBase.ToDataTable(Action<ToDataTableOptions>)

ExcelRangeBase.ToDataTable(ToDataTableOptions)

ExcelRangeBase.ToDataTable(Action<ToDataTableOptions>, DataTable)

ExcelRangeBase.ToDataTable(DataTable)

ExcelRangeBase.ToDataTable(ToDataTableOptions, DataTable)

ExcelRangeBase.ToText()

ExcelRangeBase.ToText(ExcelOutputTextFormat)

ExcelRangeBase.SaveToText(FileInfo, ExcelOutputTextFormat)

ExcelRangeBase.SaveToText(Stream, ExcelOutputTextFormat)

ExcelRangeBase.ToText(ExcelOutputTextFormatFixedWidth)

ExcelRangeBase.SaveToText(FileInfo, ExcelOutputTextFormatFixedWidth)

ExcelRangeBase.SaveToText(Stream, ExcelOutputTextFormatFixedWidth)

ExcelRangeBase.ToTextAsync()

ExcelRangeBase.ToTextAsync(ExcelOutputTextFormat)

ExcelRangeBase.SaveToTextAsync(FileInfo, ExcelOutputTextFormat)

ExcelRangeBase.SaveToTextAsync(Stream, ExcelOutputTextFormat)

ExcelRangeBase.ToTextAsync(ExcelOutputTextFormatFixedWidth)

ExcelRangeBase.SaveToTextAsync(FileInfo, ExcelOutputTextFormatFixedWidth)

ExcelRangeBase.SaveToTextAsync(Stream, ExcelOutputTextFormatFixedWidth)

ExcelRangeBase.ToJson()

ExcelRangeBase.ToJson(Action<JsonRangeExportSettings>)

ExcelRangeBase.SaveToJson(Stream)

ExcelRangeBase.SaveToJson(Stream, Action<JsonRangeExportSettings>)

ExcelRangeBase.SaveToJsonAsync(Stream)

ExcelRangeBase.SaveToJsonAsync(Stream, Action<JsonRangeExportSettings>)

ExcelRangeBase.ToCollectionWithMappings<T>(Func<ToCollectionRow, T>)

ExcelRangeBase.ToCollectionWithMappings<T>(Func<ToCollectionRow, T>, Action<ToCollectionRangeOptions>)

ExcelRangeBase.ToCollectionWithMappings<T>(Func<ToCollectionRow, T>, ToCollectionRangeOptions)

ExcelRangeBase.ToCollection<T>()

ExcelRangeBase.ToCollection<T>(Action<ToCollectionRangeOptions>)

ExcelRangeBase.ToCollection<T>(ToCollectionRangeOptions)

ExcelRangeBase.Style

ExcelRangeBase.StyleName

ExcelRangeBase.StyleID

ExcelRangeBase.Value

ExcelRangeBase.Text

ExcelRangeBase.Formula

ExcelRangeBase.FormulaR1C1

ExcelRangeBase.Hyperlink

ExcelRangeBase.Merge

ExcelRangeBase.AutoFilter

ExcelRangeBase.IsRichText

ExcelRangeBase.IsTable

ExcelRangeBase.IsArrayFormula

ExcelRangeBase.RichText

ExcelRangeBase.Comment

ExcelRangeBase.ThreadedComment

ExcelRangeBase.Worksheet

ExcelRangeBase.FullAddress

ExcelRangeBase.FullAddressAbsolute

ExcelRangeBase.ConditionalFormatting

ExcelRangeBase.DataValidation

ExcelRangeBase.FormulaRange

ExcelRangeBase.Current

ExcelRangeBase.EntireColumn

ExcelRangeBase.EntireRow

ExcelRangeBase.UseImplicitItersection

ExcelAddress.Address

ExcelAddressBase.SetAddress(string, ExcelWorkbook, string)

ExcelAddressBase.BeforeChangeAddress()

ExcelAddressBase.ToString()

ExcelAddressBase.GetHashCode()

ExcelAddressBase.Validate()

ExcelAddressBase.Equals(object)

ExcelAddressBase.Start

ExcelAddressBase.End

ExcelAddressBase.ExternalReferenceIndex

ExcelAddressBase.Table

ExcelAddressBase.AddressAbsolute

ExcelAddressBase.IsName

ExcelAddressBase.Rows

ExcelAddressBase.Columns

ExcelAddressBase.IsFullRow

ExcelAddressBase.IsFullColumn

ExcelAddressBase.LocalAddress

ExcelAddressBase.IsExternal

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.GetFullAddress(string, string, string)

ExcelCellBase.IsSimpleAddress(string)

ExcelCellBase.IsValidAddress(string)

ExcelCellBase.IsValidTableAddress(string)

ExcelCellBase.IsValidRangeAddress(string)

ExcelCellBase.IsValidCellAddress(string)

object.GetType()

object.MemberwiseClone()

object.Equals(object, object)

object.ReferenceEquals(object, object)

Extension Methods

CalculationExtension.Calculate(ExcelRangeBase)

CalculationExtension.Calculate(ExcelRangeBase, ExcelCalculationOption)

CalculationExtension.Calculate(ExcelRangeBase, Action<ExcelCalculationOption>)

RangeExtensions.SkipColumns(ExcelRangeBase, int)

RangeExtensions.SkipRows(ExcelRangeBase, int)

RangeExtensions.TakeColumns(ExcelRangeBase, int)

RangeExtensions.TakeColumnsBetween(ExcelRangeBase, int, int)

RangeExtensions.TakeRows(ExcelRangeBase, int)

RangeExtensions.TakeRowsBetween(ExcelRangeBase, int, int)

RangeExtensions.TakeSingleCell(ExcelRangeBase, int, int)

RangeExtensions.TakeSingleColumn(ExcelRangeBase, int)

RangeExtensions.TakeSingleRow(ExcelRangeBase, int)

Properties

this[int, int]

Access a single cell

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

Parameters

Row int

The row

Col int

The column

Property Value

ExcelRange

A range object

this[int, int, int, int]

Access a range of cells

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

Parameters

FromRow int

Start row

FromCol int

Start column

ToRow int

End Row

ToCol int

End Column

Property Value

ExcelRange

this[string]

Access the range using an address

public ExcelRange this[string Address] { get; }

Parameters

Address string

The address

Property Value

ExcelRange

A range object

Methods

SetFormula(string, bool)

Set the formula for the range.

public void SetFormula(string formula, bool asSharedFormula = true)

Parameters

formula string

The formula for the range.

asSharedFormula bool

If the formula should be created as a shared formula. If false each cell will be set individually. This can be useful if the formula returns a dynamic array result.