NamedStyles Property (Worksheet)

Gets or sets a collection of StyleInfo objects for this sheet.

Syntax

Visual Basic
C#

'Declaration
 
<System.ComponentModel.DefaultValueAttribute()>
Public Property NamedStyles As StyleInfoCollection

'Usage
 
Dim instance As Worksheet
Dim value As StyleInfoCollection
 
instance.NamedStyles = value
 
value = instance.NamedStyles

[System.ComponentModel.DefaultValue()]
public StyleInfoCollection NamedStyles {get; set;}

Property Value

The collection of StyleInfo objects for this sheet.

Example

This example uses the NamedStyles property.

gcSpreadSheet1.Sheets[0].NamedStyles.Add(new GrapeCity.Windows.SpreadSheet.Data.StyleInfo() { Background = new SolidColorBrush(Colors.Red), Name = "aaa", VerticalAlignment = GrapeCity.Windows.SpreadSheet.Data.CellVerticalAlignment.Center });
gcSpreadSheet1.Sheets[0].Cells[0, 0].StyleName = "aaa";

VB.NET

GcSpreadSheet1.Sheets(0).NamedStyles.Add(New GrapeCity.Windows.SpreadSheet.Data.StyleInfo() With {.Background = New SolidColorBrush(Colors.Red), .Name = "aaa", .VerticalAlignment = GrapeCity.Windows.SpreadSheet.Data.CellVerticalAlignment.Center})
GcSpreadSheet1.Sheets(0).Cells(0, 0).StyleName = "aaa"

Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)

Reference

Worksheet Class
Worksheet Members