CreateTableStyle Method

Creates a table style based on the table style contained in the table style collection or a built-in table style.

Syntax

Visual Basic
C#

'Declaration
 
Public Function CreateTableStyle( _
   ByVal styleName As String, _
   ByVal sourceStyleName As String _
) As TableStyle

'Usage
 
Dim instance As FpSpread
Dim styleName As String
Dim sourceStyleName As String
Dim value As TableStyle
 
value = instance.CreateTableStyle(styleName, sourceStyleName)

public TableStyle CreateTableStyle( 
   string styleName,
   string sourceStyleName
)

Parameters

styleName: Style name.
sourceStyleName: Source style name.

Return Value

A TableStyleThe object.

Example

This example creates and sets a table style.

FarPoint.Win.Spread.TableStyle tstyle = fpSpread1.CreateTableStyle("Style1", FarPoint.Win.Spread.TableStyle.TableStyleDark4);
fpSpread1.TableStyleCollection.Add(tstyle);
fpSpread1.Sheets[0].Cells[1, 1].Text = "Last Name";
fpSpread1.Sheets[0].Cells[1, 2].Text = "Value";
fpSpread1.Sheets[0].Cells[2, 1].Text = "Smith";
fpSpread1.Sheets[0].Cells[2, 2].Value = 50;
fpSpread1.Sheets[0].Cells[3, 1].Text = "Vil";
fpSpread1.Sheets[0].Cells[3, 2].Value = 10;
fpSpread1.Sheets[0].Cells[4, 1].Text = "Press";
fpSpread1.Sheets[0].Cells[4, 2].Value = 78;
FarPoint.Win.Spread.TableView table = fpSpread1.Sheets[0].AddTable("table", 1, 1, 5, 2, "Style1");

Visual Basic

Dim tstyle As FarPoint.Win.Spread.TableStyle = FpSpread1.CreateTableStyle("Style1", FarPoint.Win.Spread.TableStyle.TableStyleDark4)
FpSpread1.TableStyleCollection.Add(tstyle)
FpSpread1.Sheets(0).Cells(1, 1).Text = "Last Name"
FpSpread1.Sheets(0).Cells(1, 2).Text = "Value"
FpSpread1.Sheets(0).Cells(2, 1).Text = "Smith"
FpSpread1.Sheets(0).Cells(2, 2).Value = 50
FpSpread1.Sheets(0).Cells(3, 1).Text = "Vil"
FpSpread1.Sheets(0).Cells(3, 2).Value = 10
FpSpread1.Sheets(0).Cells(4, 1).Text = "Press"
FpSpread1.Sheets(0).Cells(4, 2).Value = 78
Dim table As FarPoint.Win.Spread.TableView = FpSpread1.Sheets(0).AddTable("table", 1, 1, 5, 2, "Style1")

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

FpSpread Class
FpSpread Members