//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)")