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, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

Worksheet Class
Worksheet Members
Overload List