'Declaration Public Property SecondRowStripSize As System.Integer
'Usage Dim instance As TableStyle Dim value As System.Integer instance.SecondRowStripSize = value value = instance.SecondRowStripSize
public System.int SecondRowStripSize {get; set;}
'Declaration Public Property SecondRowStripSize As System.Integer
'Usage Dim instance As TableStyle Dim value As System.Integer instance.SecondRowStripSize = value value = instance.SecondRowStripSize
public System.int SecondRowStripSize {get; set;}
//Add data for (var col = 1; col < 6; col++) { for (var row = 2; row < 11; row++) { GcSpreadSheet1.Sheets[0].SetValue(row, col, row + col); } } GrapeCity.Windows.SpreadSheet.Data.TableStyleInfo tablestyle = new GrapeCity.Windows.SpreadSheet.Data.TableStyleInfo(); tablestyle.Background = new SolidColorBrush(Colors.Azure); tablestyle.BorderBottom = new GrapeCity.Windows.SpreadSheet.Data.BorderLine(System.Windows.Media.Colors.DarkOrchid); tablestyle.BorderTop = new GrapeCity.Windows.SpreadSheet.Data.BorderLine(System.Windows.Media.Colors.DarkSlateBlue); tablestyle.BorderLeft = new GrapeCity.Windows.SpreadSheet.Data.BorderLine(System.Windows.Media.Colors.Crimson, GrapeCity.Windows.SpreadSheet.Data.BorderLineStyle.Thick); tablestyle.BorderRight = new GrapeCity.Windows.SpreadSheet.Data.BorderLine(System.Windows.Media.Colors.Crimson, GrapeCity.Windows.SpreadSheet.Data.BorderLineStyle.Thick); GrapeCity.Windows.SpreadSheet.Data.TableStyleInfo tablestylerow = new GrapeCity.Windows.SpreadSheet.Data.TableStyleInfo(); tablestylerow.BorderBottom = new GrapeCity.Windows.SpreadSheet.Data.BorderLine(System.Windows.Media.Colors.Crimson, GrapeCity.Windows.SpreadSheet.Data.BorderLineStyle.Thick); tablestylerow.Background = new SolidColorBrush(Colors.Green); GrapeCity.Windows.SpreadSheet.Data.TableStyle testtable = new GrapeCity.Windows.SpreadSheet.Data.TableStyle(); testtable.WholeTableStyle = tablestyle; testtable.SecondRowStripStyle = tablestylerow; testtable.SecondRowStripSize = 2; var sTable = GcSpreadSheet1.Sheets[0].AddTable("table1", 1, 1, 10, 5, testtable);
'Add data For col As Integer = 1 To 5 For row As Integer = 2 To 10 GcSpreadSheet1.Sheets(0).SetValue(row, col, row + col) Next Next Dim tablestyle As New GrapeCity.Windows.SpreadSheet.Data.TableStyleInfo() tablestyle.Background = New SolidColorBrush(Colors.Azure) tablestyle.BorderBottom = New GrapeCity.Windows.SpreadSheet.Data.BorderLine(System.Windows.Media.Colors.DarkOrchid) tablestyle.BorderTop = New GrapeCity.Windows.SpreadSheet.Data.BorderLine(System.Windows.Media.Colors.DarkSlateBlue) tablestyle.BorderLeft = New GrapeCity.Windows.SpreadSheet.Data.BorderLine(System.Windows.Media.Colors.Crimson, GrapeCity.Windows.SpreadSheet.Data.BorderLineStyle.Thick) tablestyle.BorderRight = New GrapeCity.Windows.SpreadSheet.Data.BorderLine(System.Windows.Media.Colors.Crimson, GrapeCity.Windows.SpreadSheet.Data.BorderLineStyle.Thick) Dim tablestylerow As New GrapeCity.Windows.SpreadSheet.Data.TableStyleInfo() tablestylerow.BorderBottom = New GrapeCity.Windows.SpreadSheet.Data.BorderLine(System.Windows.Media.Colors.Crimson, GrapeCity.Windows.SpreadSheet.Data.BorderLineStyle.Thick) tablestylerow.Background = New SolidColorBrush(Colors.Green) Dim testtable As New GrapeCity.Windows.SpreadSheet.Data.TableStyle() testtable.WholeTableStyle = tablestyle testtable.SecondRowStripStyle = tablestylerow testtable.SecondRowStripSize = 2 Dim sTable = GcSpreadSheet1.Sheets(0).AddTable("table1", 1, 1, 10, 5, testtable)