XlCellRange Class

Defines a range of cells.

Namespace : DevExpress.Export.Xl

Assembly : DevExpress.Printing.v25.2.Core.dll

NuGet Package : DevExpress.Printing.Core

Declaration

• C#
• VB.NET

public class XlCellRange :
    IXlFormulaParameter,
    IXlCellRange

Public Class XlCellRange
    Implements IXlFormulaParameter,
               IXlCellRange

Related API Members

The following members return XlCellRange objects:

Show 21 links

• IXlMergedCells.Item[Int32]
• IXlSheet.AutoFilterRange
• IXlSheet.ColumnRange
• IXlSheet.DataRange
• IXlSheet.PrintArea
• XlCellRange.AsAbsolute()
• XlCellRange.AsRelative()
• XlCellRange.ColumnInterval(Int32, Int32, XlPositionType)
• XlCellRange.ColumnInterval(Int32, Int32)
• XlCellRange.FromLTRB(Int32, Int32, Int32, Int32)
• XlCellRange.Parse(String)
• XlCellRange.RowInterval(Int32, Int32, XlPositionType)
• XlCellRange.RowInterval(Int32, Int32)
• XlDataValidation.ListRange
• XlHyperlink.Reference
• XlPrintTitles.Columns
• XlPrintTitles.Rows
• XlSparkline.DataRange
• XlSparkline.Location
• XlSparklineGroup.DateRange
• XlValueObject.RangeValue

Remarks

The XlCellRange object is used to specify a worksheet cell range (IXlSheet.ColumnRange, IXlSheet.DataRange, IXlSheet.PrintArea properties), used in formulas (the IXlCell.SetSharedFormula method and methods of the XlFunc class), as a hyperlink target (the XlHyperlink.Reference property), referenced by conditional formatting and data validation rules.

To create an XlCellRange instance, use static methods XlCellRange.FromLTRB and XlCellRange.Parse.

Implements

IXlFormulaParameter

Inheritance

Object XlCellRange

See Also

XlCellRange Members

DevExpress.Export.Xl Namespace