Spread Windows Forms 9.0 Product Documentation
CreateTableStyle Method
Example 


Style name.
Source style name.
Creates a table style based on the table style contained in the table style collection or a built-in table style.
Syntax
'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");
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

See Also

Reference

FpSpread Class
FpSpread Members

 

 


Copyright © GrapeCity, inc. All rights reserved.