在你的总计前面,再加一个小计,即可
If EndRow >= Count Then
'在这里写代码 .Body.AddRow("总计","","","",qty,amt).Attribute = "style='background-color:#98FB98'" End If