skip navigation
  • Product Bundles

    DevCraft

    All Telerik .NET tools and Kendo UI JavaScript components in one package. Now enhanced with:

    • NEW: Design Kits for Figma
    • Online Training
    • Document Processing Library
    • Embedded Reporting for web and desktop

    Web

    Kendo UI UI for jQuery UI for Angular UI for React UI for Vue UI for Blazor UI for ASP.NET Core UI for ASP.NET MVC UI for ASP.NET AJAX

    Mobile

    UI for .NET MAUI

    Document Management

    Telerik Document Processing

    Desktop

    UI for .NET MAUI UI for WinUI UI for WinForms UI for WPF

    Reporting

    Telerik Reporting Telerik Report Server

    Testing & Mocking

    Test Studio Test Studio Dev Edition Telerik JustMock

    CMS

    Sitefinity

    UI/UX Tools

    ThemeBuilder Design System Kit Templates and Building Blocks

    Debugging

    Fiddler Fiddler Everywhere Fiddler Classic Fiddler Everywhere Reporter FiddlerCore

    Free Tools

    VB.NET to C# Converter Testing Framework
    View all products
  • Overview
  • Demos
  • Docs & Support
  • Pricing
  • Shopping cart
    • Account Overview
    • Your Licenses
    • Downloads
    • Support Center
    • Forum Profile
    • Payment Methods
    • Edit Profile
    • Log out
  • Login
  • Contact Us
  • Try now

Class CellStyleCollection

Represents cell style collection.

Inheritance
System.Object
CellStyleCollection
Inherited Members
System.Object.ToString()
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
Namespace: Telerik.Windows.Documents.Spreadsheet.PropertySystem
Assembly: Telerik.Windows.Documents.Spreadsheet.dll

Syntax

public class CellStyleCollection : IEnumerable<CellStyle>, IEnumerable

Properties

Count

Gets the count of the styles.

Declaration
public int Count { get; }
Property Value
System.Int32

The count of the styles.

Item[String]

Gets the CellStyle with the specified style name.

Declaration
public CellStyle this[string styleName] { get; }
Parameters
System.String styleName

The name of the desired style.

Property Value
CellStyle

The style.

Workbook

Gets the workbook.

Declaration
public Workbook Workbook { get; }
Property Value
Workbook

The workbook.

Methods

Add(String, CellStyleCategory, Boolean)

Adds the specified style.

Declaration
public CellStyle Add(string styleName, CellStyleCategory category = CellStyleCategory.Custom, bool isRemovable = true)
Parameters
System.String styleName

Name of the style.

CellStyleCategory category

The category.

System.Boolean isRemovable

A value indicating if the style can be removed later.

Returns
CellStyle

The style.

Contains(String)

Determines whether the style with the specified name is contained.

Declaration
public bool Contains(string styleName)
Parameters
System.String styleName

Name of the style.

Returns
System.Boolean

True if is contained.

Contains(CellStyle)

Determines whether the specified style is contained.

Declaration
public bool Contains(CellStyle style)
Parameters
CellStyle style

The style.

Returns
System.Boolean

True if is contained.

GetByName(String)

Gets the style by name.

Declaration
public CellStyle GetByName(string styleName)
Parameters
System.String styleName

Name of the style.

Returns
CellStyle

The style.

GetEnumerator()

Returns an enumerator that iterates through the collection.

Declaration
public IEnumerator<CellStyle> GetEnumerator()
Returns
System.Collections.Generic.IEnumerator<CellStyle>

A System.Collections.Generic.IEnumerator<T> that can be used to iterate through the collection.

Implements
System.Collections.Generic.IEnumerable<T>.GetEnumerator()

OnChanged()

Called when the collection is changed.

Declaration
protected virtual void OnChanged()

Remove(String)

Removes the specified style by name.

Declaration
public bool Remove(string styleName)
Parameters
System.String styleName

Name of the style.

Returns
System.Boolean

True if succeed.

Remove(CellStyle)

Removes the specified style.

Declaration
public bool Remove(CellStyle style)
Parameters
CellStyle style

The style.

Returns
System.Boolean

True if succeed.

Events

Changed

Occurs when the collection is changed.

Declaration
public event EventHandler Changed
Event Type
System.EventHandler

Explicit Interface Implementations

IEnumerable.GetEnumerator()

Returns an enumerator that iterates through a collection.

Declaration
IEnumerator IEnumerable.GetEnumerator()
Returns
System.Collections.IEnumerator

An System.Collections.IEnumerator object that can be used to iterate through the collection.

Implements
System.Collections.IEnumerable.GetEnumerator()
Getting Started
  • Getting Started
Support Resources
  • Documentation
Community
  • Forums
  • Blogs
  • Document Processing Feedback Portal

Copyright © 2018 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.

Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.