The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
Row

Worksheet.Range Property

Provides access to the range of cells in the worksheet.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v19.2.Core.dll

Declaration

IRangeProvider Range { get; }
ReadOnly Property Range As IRangeProvider
IRangeProvider Range { get; }
ReadOnly Property Range As IRangeProvider
IRangeProvider Range { get; }
ReadOnly Property Range As IRangeProvider

Property Value

Type Description
IRangeProvider

An object implementing the IRangeProvider interface.

Property Value

Type Description
IRangeProvider

An object implementing the IRangeProvider interface.

Property Value

Type Description
IRangeProvider

An object implementing the IRangeProvider interface.

Remarks

A cell range is a rectangular block of cells that is specified by the CellRange object. You can manipulate cell ranges when you format cells or process data.

The Range property returns the IRangeProvider object. Use the one of the following members to obtain a cell range.

CreateRange_3

Use the following properties and methods to work with cell ranges.

Operation

Members

Read More...

Get Cell Reference

CellRange.GetReferenceA1

CellRange.GetReferenceR1C1

Cell Referencing

Format Cell Ranges

CellRange.Style

CellRange.BeginUpdateFormatting - CellRange.EndUpdateFormatting

CellRange.FillColor, Formatting.Fill

Formatting.Font

Formatting.NumberFormat

Formatting.Alignment

Formatting.Borders, CellRange.SetInsideBorders

How to: Format Cells

Set Values or Formulas to Cells

CellRange.Value

CellRange.Formula, CellRange.ArrayFormula, CellRange.HasArrayFormula

Cell Data Types

Spreadsheet Formulas

How to: Change a Cell or Cell Range Value

How to: Add Formulas to Cells

Add Hyperlinks to Cells

Worksheet.Hyperlinks

HyperlinkCollection.Add

HyperlinkCollection.GetHyperlinks

How to: Add a Hyperlink to a Cell

Add Comments to Cells

Worksheet.Comments

CommentCollection.Add

CommentCollection.GetComments

Comments

Name Cells

CellRange.Name

Worksheet.DefinedNames, DefinedNameCollection.Add

Defined Names

How to: Create a Named Range of Cells

Merge Cells

Worksheet.MergeCells, Worksheet.UnMergeCells

How to: Merge Cells or Split Merged Cells

Copy Cells

CellRange.CopyFrom

How to: Copy Cell Data Only, Cell Style Only, or Cell Data with Style

Clear Cells

Worksheet.Clear

Worksheet.ClearContents

Worksheet.ClearFormats

Worksheet.ClearComments

Worksheet.ClearHyperlinks

How to: Clear Cells of Content, Formatting, Hyperlinks and Comments

Insert Cells

Worksheet.InsertCells

How to: Insert a Cell or Cell Range

Delete Cells

Worksheet.DeleteCells

How to: Delete a Cell or Range of Cells

Obtain Intersection of Cell Ranges

CellRange.IsIntersecting

CellRange.Intersect

Create a Complex Range

CellRange.Union

Examples

This example demonstrates how to access ranges of cells in a worksheet. There are several ways to accomplish this.

// A range that includes cells from the top left cell (A1) to the bottom right cell (B5).
CellRange rangeA1B5 = worksheet["A1:B5"];

// A rectangular range that includes cells from the top left cell (C5) to the bottom right cell (E7).
CellRange rangeC5E7 = worksheet["C5:E7"];

// The C4:E7 cell range located in the "Sheet3" worksheet.
CellRange rangeSheet3C4E7 = workbook.Range["Sheet3!C4:E7"];

// A range that contains a single cell (E7).
CellRange rangeE7 = worksheet["E7"];

// A range that includes the entire column A.
CellRange rangeColumnA = worksheet["A:A"];

// A range that includes the entire row 5.
CellRange rangeRow5 = worksheet["5:5"];

// A minimal rectangular range that includes all listed cells: C6, D9 and E7.
CellRange rangeC6D9E7 = worksheet.Range.Parse("C6:D9:E7");

// A rectangular range whose left column index is 0, top row index is 0, 
// right column index is 3 and bottom row index is 2. This is the A1:D3 cell range.
CellRange rangeA1D3 = worksheet.Range.FromLTRB(0, 0, 3, 2);

// A range that includes the intersection of two ranges: C5:E10 and E9:G13. 
// This is the E9:E10 cell range.
CellRange rangeE9E10 = worksheet["C5:E10 E9:G13"];

// Create a defined name for the D20:G23 cell range.
worksheet.DefinedNames.Add("MyNamedRange", "Sheet1!$D$20:$G$23");
// Access a range by its defined name.
CellRange rangeD20G23 = worksheet["MyNamedRange"];
CellRange rangeA1D4 = worksheet["A1:D4"];
CellRange rangeD5E7 = worksheet["D5:E7"];
CellRange rangeRow11 = worksheet["11:11"];
CellRange rangeF7 = worksheet["F7"];

// Create a complex range using the Range.Union method.
CellRange complexRange1 = worksheet["A7:A9"].Union(rangeD5E7);

// Create a complex range using the IRangeProvider.Union method.
CellRange complexRange2 = worksheet.Range.Union(new CellRange[] { rangeRow11, rangeA1D4, rangeF7 });

// Fill the ranges with different colors.
complexRange1.FillColor = myColor1;
complexRange2.FillColor = myColor2;

// Use the Areas property to get access to a component of a complex range.
complexRange2.Areas[2].FillColor = Color.Beige;
See Also