GetStyleInfo(Int32,Int32) Method

Visual Basic
C#

'Declaration
 
Public Overloads Overridable Function GetStyleInfo( _
   ByVal row As System.Integer, _
   ByVal column As System.Integer _
) As StyleInfo

'Usage
 
Dim instance As Worksheet
Dim row As System.Integer
Dim column As System.Integer
Dim value As StyleInfo
 
value = instance.GetStyleInfo(row, column)

public virtual StyleInfo GetStyleInfo( 
   System.int row,
   System.int column
)

Parameters

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

Return Value

The style information of the specified cell, row, or column.

This example uses the GetStyleInfo method.

C#

var style = new GrapeCity.Windows.SpreadSheet.Data.StyleInfo();
style.Background = new SolidColorBrush(Colors.Blue);
style.Name = "CellStyle";
gcSpreadSheet1.Sheets[0].NamedStyles.Add(style);
gcSpreadSheet1.Sheets[0].Cells[0, 0].StyleName = "CellStyle";
listBox1.Items.Add(gcSpreadSheet1.Sheets[0].GetStyleInfo(0, 0).Name.ToString());
listBox1.Items.Add(gcSpreadSheet1.Sheets[0].GetStyleInfo(0,0,GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells).Background.ToString());
listBox1.Items.Add(gcSpreadSheet1.Sheets[0].GetStyleName(0, 0).ToString());
listBox1.Items.Add(gcSpreadSheet1.Sheets[0].GetStyleName(0, 0, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells).ToString());

VB.NET

Dim style As New GrapeCity.Windows.SpreadSheet.Data.StyleInfo()
style.Background = New SolidColorBrush(Colors.Blue)
style.Name = "CellStyle"
GcSpreadSheet1.Sheets(0).NamedStyles.Add(style)
GcSpreadSheet1.Sheets(0).Cells(0, 0).StyleName = "CellStyle"
ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).GetStyleInfo(0, 0).Name.ToString())
ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).GetStyleInfo(0, 0, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells).Background.ToString())
ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).GetStyleName(0, 0).ToString())
ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).GetStyleName(0, 0, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells).ToString())

Reference

Worksheet Class
Worksheet Members
Overload List