Returns or sets the location of the summary rows in the outline.

[Visual Basic]
Property SummaryRow As XlSummaryRow
[C#]
XlSummaryRow SummaryRow { get; set; }
[C++]
__property XlSummaryRow get_SummaryRow();
__property void set_SummaryRow(XlSummaryRow );
[JScript]
function get SummaryRow() : XlSummaryRow
function set SummaryRow(XlSummaryRow);

Property Value

SummaryRow can be one of XlSummaryRow values.

Example

This example sets SummaryRow property on sheet one to xlSummaryAbove.

[C#]
book.Worksheets[1].Outline.SummaryRow = XlSummaryRow.xlSummaryAbove;

[Visual Basic]
book.Worksheets(1).Outline.SummaryRow = XlSummaryRow.xlSummaryAbove

[C++]
IWorksheet* sheet = book->Worksheets->Item[1];
sheet->Outline->SummaryRow = XlSummaryRow::xlSummaryAbove;

See Also

IOutline Interface | NativeExcel Namespace | IWorksheet.Outline Property | XlSummaryRow Enumeration | IOutline.SummaryColumn Property

---