GrapeCity.Xaml.SpreadSheet.Data Namespace > SheetTable Class : SetColumnName Method |
'Declaration Public Sub SetColumnName( _ ByVal tableColumnIndex As Integer, _ ByVal name As String _ )
'Usage Dim instance As SheetTable Dim tableColumnIndex As Integer Dim name As String instance.SetColumnName(tableColumnIndex, name)
public void SetColumnName( int tableColumnIndex, string name )
//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.Xaml.SpreadSheet.Data.TableStyles.Medium2); sTable.ShowFooter = true; //set footer value sTable.SetColumnName(0, "Total"); //set footer formula sTable.SetColumnFormula(4, "SUM(F3:F11)");
'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.Xaml.SpreadSheet.Data.TableStyles.Medium2) sTable.ShowFooter = True 'set footer value sTable.SetColumnName(0, "Total") 'set footer formula sTable.SetColumnFormula(4, "SUM(F3:F11)")
Target Platforms: Windows Server 2012, Windows RT