GrapeCity.Windows.SpreadSheet.Data Namespace > SheetTable Class : BandedColumns Property |
'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;}
//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
Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6