MindFusion.Spreadsheet.Worksheet.CellRanges Property

Introduction

General Information

What's New in this Release

Version History

Licensing

Programming Interface Overview

Reference

MindFusion.Drawing

MindFusion.Spreadsheet

AddItemCommand(T) Class

AdjustmentHandles Enumeration

Annotation Class

AutoFilter Class

AutoFilterOperator Enumeration

Cell Class

CellChangedEventArgs Class

CellCollection Class

CellData Class

CellEventArgs Class

CellIndex Class

CellMouseEventArgs Class

CellRange Class

CellRangeCollection Class

CellValidationEventArgs Class

ChangeWorksheetCommand Class

Column Class

ColumnChangedEventArgs Class

ColumnCollection Class

ColumnEventArgs Class

ColumnMouseEventArgs Class

ColumnRange Class

ColumnRangeEventArgs Class

ColumnRangeMovingEventArgs Class

ColumnRangeResizingEventArgs Class

Command Class

ComparisonOperator Enumeration

CompositeCommand Class

ConditionalFormatType Enumeration

Converter Class

CsvExporter Class

CsvImporter Class

CurrencyCodeInfo Class

CurrencyCodes Class

CursorHint Enumeration

DefaultNumericFormats Class

DisposableCommand Class

DrawColumnEventArgs Class

Drawing Class

DrawRowEventArgs Class

DynamicFilterType Enumeration

ExcelExporter Class

ExcelImporter Class

FillDate Enumeration

FillDirection Enumeration

FillType Enumeration

Filter Class

FindWithin Enumeration

FormattedText Class

HorizontalAlignment Enumeration

HtmlExporter Class

HtmlExporterBase Class

HtmlExporterBase.MetaTagNames Class

Hyperlink Class

HyperlinkType Enumeration

IColumnStyle Interface

IConditionalFormat Interface

IConditionalFormatCollection Interface

IHasName Interface

IInplaceEditable Interface

ImageExporter Class

INotifyPropertyValueChanged Interface

InplaceEditEventArgs Class

InplaceEditValidationEventArgs Class

InteractiveObject Class

IRowStyle Interface

IStyle Interface

IValidation Interface

LookIn Enumeration

Measure Class

MeasureUnit Class

MergedCellsCollection Class

MhtmlExporter Class

MoveItemCommand(T) Class

NamedCollection(T) Class

NamedRange Class

NamedRangeCollection Class

NumericFormatInfo Class

ObjectAnchor Enumeration

ObjectAnchorPosition Enumeration

ObjectEventArgs Class

ObjectInteractionEventArgs Class

ObjectInteractionValidationEventArgs Class

ObjectMouseEventArgs Class

ObjectValidationEventArgs Class

OutlineEventArgs Class

PageOrder Enumeration

PdfExporter Class

Picture Class

PropertyEventArgs Class

PushDirection Enumeration

RemoveItemCommand(T) Class

ReplaceItemCommand(T) Class

ResetCollectionCommand(T) Class

Row Class

RowChangedEventArgs Class

RowCollection Class

RowEventArgs Class

RowMouseEventArgs Class

RowRange Class

RowRangeEventArgs Class

RowRangeMovingEventArgs Class

RowRangeResizingEventArgs Class

Run Class

SearchDirection Enumeration

SearchOrder Enumeration

Selection Class

SerializeColumnTagEventArgs Class

SerializeDataEventArgs Class

SerializeRowTagEventArgs Class

SerializeTagEventArgs Class

ShiftDirection Enumeration

SortDirection Enumeration

SortKey Class

SortOptions Class

SortOrder Enumeration

StyleData Class

TabAlignment Enumeration

TrackChangesCommand Class

UndoableCollection(T) Class

UndoEventArgs Class

ValidationErrorAction Enumeration

ValidationFailedEventArgs Class

ValidationType Enumeration

VerticalAlignment Enumeration

Workbook Class

WorkbookPrinter Class

WorkbookView Class

Worksheet Class

WorksheetChangedEventArgs Class

WorksheetCollection Class

WorksheetEventArgs Class

WorksheetMouseEventArgs Class

WorksheetValidationEventArgs Class

WorksheetView Class

XmlContext Class

MindFusion.Spreadsheet.Charts

MindFusion.Spreadsheet.Expressions

MindFusion.Spreadsheet.WinForms

Gets an object that can be used to access and manipulate rectangular ranges of worksheet cells.

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

Syntax

C# Copy Code
public CellRangeCollection CellRanges { get; }

Visual Basic Copy Code
Public ReadOnly Property CellRanges As CellRangeCollection

Property Value

An instance of the CellRangeCollection class.

Example

The following example applies a new background to all cells in the range 'A1:C10', by using a CellRange object.

C# Copy Code
worksheet.CellRanges["A1:C10"].Style.Background = new MindFusion.Drawing.SolidBrush(Color.PaleGoldenrod);

Visual Basic Copy Code
worksheet.CellRanges("A1:C10").Style.Background = New MindFusion.Drawing.SolidBrush(Color.PaleGoldenrod)

Syntax

Property Value

Example

See Also