SetStyleInfo(Int32,Int32,StyleInfo) Method

Sets the style for the specified cell, row, or column.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Sub SetStyleInfo( _
   ByVal row As System.Integer, _
   ByVal column As System.Integer, _
   ByVal style As StyleInfo _
)

'Usage
 
Dim instance As Worksheet
Dim row As System.Integer
Dim column As System.Integer
Dim style As StyleInfo
 
instance.SetStyleInfo(row, column, style)

public void SetStyleInfo( 
   System.int row,
   System.int column,
   StyleInfo style
)

Parameters

row: The row index.
column: The column index.
style: The style.

Example

This example uses the SetStyleInfo method.

GrapeCity.Windows.SpreadSheet.Data.StyleInfo aaa = new GrapeCity.Windows.SpreadSheet.Data.StyleInfo();
aaa.Background = new SolidColorBrush(Colors.Aquamarine);
aaa.Name = "aaa";
gcSpreadSheet1.Sheets[0].NamedStyles.Add(aaa);
gcSpreadSheet1.Sheets[0].SetStyleInfo(-1, -1, aaa);        
//or
//gcSpreadSheet1.Sheets[0].DefaultStyle = aaa;
gcSpreadSheet1.Invalidate();

VB.NET

Dim aaa As New GrapeCity.Windows.SpreadSheet.Data.StyleInfo()
aaa.Background = New SolidColorBrush(Colors.Aquamarine)
aaa.Name = "aaa"
GcSpreadSheet1.Sheets(0).NamedStyles.Add(aaa)
GcSpreadSheet1.Sheets(0).SetStyleInfo(-1, -1, aaa)
'or
'GcSpreadSheet1.Sheets(0).DefaultStyle = aaa
GcSpreadSheet1.Invalidate()

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
Overload List