切换为汇总模式代码是:
Dim t As Table = Tables("表A")Dim g As SubtotalGroupt.SubtotalGroups.Clear()t.GroupAboveData = Falset.TreeVisible = Falset.SpillNode = False
g = New SubtotalGroupg.Aggregate = AggregateEnum.Sumg.GroupOn = "*"g.TotalOn = "第二列,第四列,第三列"g.Caption = "总计"t.SubtotalGroups.Add(g)
t.Subtotal()
要退出汇总模式,请问代码如何设置?