SetStyleInfo(Int32,Int32,SheetArea,StyleInfo) Method

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

Syntax

Visual Basic
C#

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

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

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

Parameters

row: The row index.
column: The column index.
sheetArea: The sheet area.
style: The style.

Exceptions

Exception	Description
System.ArgumentException	The sheet area cannot be found.
System.IndexOutOfRangeException	The row index must be between 0 and the block row count.
System.IndexOutOfRangeException	The column index must be between 0 and the block column count .

Example

This example uses the SetStyleInfo method.

GrapeCity.Windows.SpreadSheet.Data.StyleInfo aaa = new GrapeCity.Windows.SpreadSheet.Data.StyleInfo();
aaa.Background = new SolidColorBrush(System.Windows.Media.Colors.Green);
aaa.Name = "aaa";
gcSpreadSheet1.Sheets[0].NamedStyles.Add(aaa);
gcSpreadSheet1.Sheets[0].SetStyleInfo(-1, -1, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells, aaa);

VB.NET

Dim aaa As New GrapeCity.Windows.SpreadSheet.Data.StyleInfo()
aaa.Background = New SolidColorBrush(System.Windows.Media.Colors.Green)
aaa.Name = "aaa"
GcSpreadSheet1.Sheets(0).NamedStyles.Add(aaa)
GcSpreadSheet1.Sheets(0).SetStyleInfo(-1, -1, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells, 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
Overload List