Spread WPF Documentation
BandedColumns Property
Example 


GrapeCity.Windows.SpreadSheet.Data Namespace > SheetTable Class : BandedColumns Property
Gets or sets a value that indicates whether to display an alternating column style.
Syntax
'Declaration
 
<System.ComponentModel.DefaultValueAttribute()>
Public Property BandedColumns As System.Boolean
'Usage
 
Dim instance As SheetTable
Dim value As System.Boolean
 
instance.BandedColumns = value
 
value = instance.BandedColumns
[System.ComponentModel.DefaultValue()]
public System.bool BandedColumns {get; set;}
Example
This example creates a table.
//Add data
for (var col = 1; col < 6; col++) {
    for (var row = 2; row < 11; row++) {
        GcSpreadSheet1.Sheets[0].SetValue(row, col, row + col);
    }
}

var sTable = GcSpreadSheet1.Sheets[0].AddTable("table1", 1, 1, 10, 5, GrapeCity.Windows.SpreadSheet.Data.TableStyles.Medium2);
sTable.BandedColumns = true;
sTable.BandedRows=true;
'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 sTable = GcSpreadSheet1.Sheets(0).AddTable("table1", 1, 1, 10, 5, GrapeCity.Windows.SpreadSheet.Data.TableStyles.Medium2)
sTable.BandedColumns = True
sTable.BandedRows = True
See Also

Reference

SheetTable Class
SheetTable Members