When grouping rows, SummaryRows determines where the summary rows for the groups are located. By default the summary rows are located below the groupings.

<table class="wysiwyg-macro" data-macro-name="unmigrated-wiki-markup" style="background-image: url(/plugins/servlet/confluence/placeholder/macro-heading?definition=e3VubWlncmF0ZWQtd2lraS1tYXJrdXB9&amp;locale=en_GB&amp;version=2); background-repeat: no-repeat;" data-macro-body-type="PLAIN_TEXT"><tr><td class="wysiwyg-macro-body"><pre>
 public SummaryRowsLocation SummaryRows{ get; set; }
</pre></td></tr></table>
<p>Public Property SummaryRows() As SummaryRowsLocation</p>

          //--- Get SummaryRows
          Worksheet.SummaryRowsLocation location = ws.SummaryRows;

          //--- Set SummaryRows
          ws.SummaryRows = Worksheet.SummaryLocation.Above;
        

          '--- Get SummaryRows
          Dim location As Worksheet.SummaryRowsLocation = ws.SummaryRows

          '--- Set SummaryRows
          ws.SummaryRows = Worksheet.SummaryLocation.Above