CellRange Class

Identifies a range of cells in a Worksheet.

Namespace: MindFusion.Spreadsheet
Assembly: MindFusion.Spreadsheet.WinForms

 Syntax

C#

public class CellRange : IEnumerable<Cell>, IEnumerable

Visual Basic

Public Class CellRange
    Implements IEnumerable(Of Cell), IEnumerable

 Remarks

Instances of this class can be accessed through the CellRanges collection of the Worksheet class. The CellRange object can be used to customize the appearance of all cells in the range through its Style, to insert, delete, merge and unmerge cells.

 Example

The following example demonstrates how to merge the cells A1:C4 in a worksheet:

C#

worksheet.CellRanges["A1:C4"].Merge();

Visual Basic

worksheet.CellRanges("A1:C4").Merge()

 Inheritance Hierarchy

System.Object
    MindFusion.Spreadsheet.CellRange