SetStyleName(Int32,Int32,SheetArea,String) Method

Sets the style for the specified cell, column, row, or default model to the specified style name.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Sub SetStyleName( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal sheetArea As SheetArea, _
   ByVal value As String _
)

'Usage
 
Dim instance As Worksheet
Dim row As Integer
Dim column As Integer
Dim sheetArea As SheetArea
Dim value As String
 
instance.SetStyleName(row, column, sheetArea, value)

public void SetStyleName( 
   int row,
   int column,
   SheetArea sheetArea,
   string value
)

Parameters

row: The row index of the cell in the model, or -1 to specify a column or default model.
column: The column index of the cell in the model, or -1 to specify a row or default model.
sheetArea: The sheet area.
value: The name of the style to set.

Example

This example uses the SetStyleName method.

C#
VB.NET

GrapeCity.Xaml.SpreadSheet.Data.StyleInfo aaa = new GrapeCity.Xaml.SpreadSheet.Data.StyleInfo();
aaa.Background = new SolidColorBrush(Windows.UI.Colors.Green);
aaa.Name = "aaa";
gcSpreadSheet1.Sheets[0].NamedStyles.Add(aaa);
gcSpreadSheet1.Sheets[0].SetStyleName(0, 0, "aaa");
//gcSpreadSheet1.Sheets[0].SetStyleName(0, 0, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells, "aaa");

Dim aaa As New GrapeCity.Xaml.SpreadSheet.Data.StyleInfo()
aaa.Background = New SolidColorBrush(Windows.UI.Colors.Green)
aaa.Name = "aaa"
GcSpreadSheet1.Sheets(0).NamedStyles.Add(aaa)
GcSpreadSheet1.Sheets(0).SetStyleName(0, 0, "aaa")
'GcSpreadSheet1.Sheets(0).SetStyleName(0, 0, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells, "aaa")

Requirements

Target Platforms: Windows Server 2012, Windows RT

Reference

Worksheet Class
Worksheet Members
Overload List