FarPoint.Win.SpreadJ アセンブリ > FarPoint.Win.Spread 名前空間 > TableBorder クラス > TableBorder コンストラクタ : TableBorder コンストラクタ(ComplexBorderSide,ComplexBorderSide,ComplexBorderSide,ComplexBorderSide,ComplexBorderSide,ComplexBorderSide) |
'Declaration Public Function New( _ ByVal left As ComplexBorderSide, _ ByVal top As ComplexBorderSide, _ ByVal right As ComplexBorderSide, _ ByVal bottom As ComplexBorderSide, _ ByVal vertical As ComplexBorderSide, _ ByVal horizontal As ComplexBorderSide _ )
'使用法 Dim left As ComplexBorderSide Dim top As ComplexBorderSide Dim right As ComplexBorderSide Dim bottom As ComplexBorderSide Dim vertical As ComplexBorderSide Dim horizontal As ComplexBorderSide Dim instance As New TableBorder(left, top, right, bottom, vertical, horizontal)
public TableBorder( ComplexBorderSide left, ComplexBorderSide top, ComplexBorderSide right, ComplexBorderSide bottom, ComplexBorderSide vertical, ComplexBorderSide horizontal )
FarPoint.Win.ComplexBorderSide bside = new FarPoint.Win.ComplexBorderSide(Color.Yellow); FarPoint.Win.ComplexBorderSide bside1 = new FarPoint.Win.ComplexBorderSide(Color.Green); FarPoint.Win.ComplexBorderSide bside2 = new FarPoint.Win.ComplexBorderSide(Color.Red); FarPoint.Win.ComplexBorderSide bside3 = new FarPoint.Win.ComplexBorderSide(Color.Blue); FarPoint.Win.ComplexBorderSide bside4 = new FarPoint.Win.ComplexBorderSide(Color.Orange); FarPoint.Win.ComplexBorderSide bside5 = new FarPoint.Win.ComplexBorderSide(Color.Brown); FarPoint.Win.Spread.TableBorder tborder = new FarPoint.Win.Spread.TableBorder(bside, bside1, bside2, bside3, bside4, bside5); FarPoint.Win.Spread.TableElementStyle testyle = new FarPoint.Win.Spread.TableElementStyle(tborder, Color.White, Color.Black, FarPoint.Win.Spread.RegularBoldItalicFontStyle.Bold); FarPoint.Win.Spread.TableStyle tstyle = fpSpread1.CreateTableStyle("Style1", FarPoint.Win.Spread.TableStyle.TableStyleLight2); tstyle.FirstColumn = testyle; 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; fpSpread1.TableStyleCollection.Add(tstyle); FarPoint.Win.Spread.TableView table = fpSpread1.Sheets[0].AddTable("table", 1, 1, 5, 2, "Style1"); table.FirstColumn = true;
Dim bside As New FarPoint.Win.ComplexBorderSide(Color.Yellow) Dim bside1 As New FarPoint.Win.ComplexBorderSide(Color.Green) Dim bside2 As New FarPoint.Win.ComplexBorderSide(Color.Red) Dim bside3 As New FarPoint.Win.ComplexBorderSide(Color.Blue) Dim bside4 As New FarPoint.Win.ComplexBorderSide(Color.Orange) Dim bside5 As New FarPoint.Win.ComplexBorderSide(Color.Brown) Dim tborder As New FarPoint.Win.Spread.TableBorder(bside, bside1, bside2, bside3, bside4, bside5) Dim testyle As New FarPoint.Win.Spread.TableElementStyle(tborder, Color.White, Color.Black, FarPoint.Win.Spread.RegularBoldItalicFontStyle.Bold) Dim tstyle As FarPoint.Win.Spread.TableStyle tstyle = FpSpread1.CreateTableStyle("Style1", FarPoint.Win.Spread.TableStyle.TableStyleLight2) tstyle.FirstColumn = testyle 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 FpSpread1.TableStyleCollection.Add(tstyle) Dim table As FarPoint.Win.Spread.TableView = FpSpread1.Sheets(0).AddTable("table", 1, 1, 5, 2, "Style1") table.FirstColumn = True