XlCellRange Class

Defines a range of cells.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v18.1.Core.dll

Declaration

C#

public class XlCellRange :
    IXlFormulaParameter,
    IXlCellRange

VB.NET

Public Class XlCellRange
    Implements IXlFormulaParameter,
               IXlCellRange

Related API Members

The following members accept/return XlCellRange objects:

Show 20 links

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

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.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the XlCellRange class.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

excel-export-api-examples-t253492/CS/XLExportExamples/SpreadsheetActions/MiscellaneousActions.cs#L40

XlHyperlink hyperlink = new XlHyperlink();
hyperlink.Reference = new XlCellRange(new XlCellPosition(cell.ColumnIndex, cell.RowIndex));
hyperlink.TargetUri = "#Sheet1!C5";

how-to-use-the-excel-export-api-to-perform-a-sales-analysis-t252486/CS/XLExportExample/Form1.cs#L299

using (IXlCell cell = row.CreateCell()) {
    cell.SetFormula(XlFunc.Subtotal(XlCellRange.FromLTRB(1, firstDataRowIndex, 1, row.RowIndex - 1), XlSummary.Average, false));
    cell.ApplyFormatting(totalRowFormatting);

how-to-use-the-excel-export-api-to-generate-a-list-of-employees-t251723/CS/XLExportExample/Form1.cs#L307

XlDataValidation validation = new XlDataValidation();
validation.Ranges.Add(XlCellRange.FromLTRB(0, firstDataRowIndex, 0, sheet.CurrentRowIndex - 1));
validation.Type = XlDataValidationType.Custom;

how-to-customize-the-gridcontrols-data-aware-export-output-t247610/CS/GridDataAwareExportCustomization/Form1.cs#L63

if(e.DataSourceRowIndex < 0) {
    e.ExportContext.MergeCells(new XlCellRange(new XlCellPosition(0, e.DocumentRow - 1), new XlCellPosition(5, e.DocumentRow - 1)));
}

how-to-use-the-excel-export-api-to-generate-a-sales-report-t251810/CS/XLExportExampleSalesReport/Form1.cs#L327

using (IXlCell cell = row.CreateCell()) {
    cell.SetFormula(XlFunc.Sum(XlCellRange.FromLTRB(2, row.RowIndex, 5, row.RowIndex)));
    cell.ApplyFormatting(dataRowFormatting);

VB.NET

excel-export-api-examples-t253492/VB/XLExportExamples/SpreadsheetActions/MiscellaneousActions.vb#L43

Dim hyperlink As New XlHyperlink()
hyperlink.Reference = New XlCellRange(New XlCellPosition(cell.ColumnIndex, cell.RowIndex))
hyperlink.TargetUri = "#Sheet1!C5"

how-to-use-the-excel-export-api-to-perform-a-sales-analysis-t252486/VB/XLExportExample/Form1.vb#L313

Using cell As IXlCell = row.CreateCell()
    cell.SetFormula(XlFunc.Subtotal(XlCellRange.FromLTRB(1, firstDataRowIndex, 1, row.RowIndex - 1), XlSummary.Average, False))
    cell.ApplyFormatting(totalRowFormatting)

how-to-use-the-excel-export-api-to-generate-a-list-of-employees-t251723/VB/XLExportExample/Form1.vb#L323

Dim validation As New XlDataValidation()
validation.Ranges.Add(XlCellRange.FromLTRB(0, firstDataRowIndex, 0, sheet.CurrentRowIndex - 1))
validation.Type = XlDataValidationType.Custom

how-to-customize-the-gridcontrols-data-aware-export-output-t247610/VB/GridDataAwareExportCustomization/Form1.vb#L66

If e.DataSourceRowIndex < 0 Then
    e.ExportContext.MergeCells(New XlCellRange(New XlCellPosition(0, e.DocumentRow - 1), New XlCellPosition(5, e.DocumentRow - 1)))
End If

how-to-use-the-excel-export-api-to-generate-a-sales-report-t251810/VB/XLExportExampleSalesReport/Form1.vb#L340

Using cell As IXlCell = row.CreateCell()
    cell.SetFormula(XlFunc.Sum(XlCellRange.FromLTRB(2, row.RowIndex, 5, row.RowIndex)))
    cell.ApplyFormatting(dataRowFormatting)

Implements

IXlFormulaParameter

Inheritance

Object

XlCellRange