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 Integer, _
   ByVal column As Integer, _
   ByVal style As StyleInfo _
)

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

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

Parameters

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

Example

This example uses the SetStyleInfo property.

C#
VB.NET

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

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

Reference

Worksheet Class
Worksheet Members
Overload List