NativeExcel2 for .Net Developer's Reference

IOutline.SummaryRow Property

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

[Visual Basic]
PropertySummaryRowAsXlSummaryRow
[C#]
XlSummaryRowSummaryRow{get;set;}
[C++]
__propertyXlSummaryRowget_SummaryRow();
__propertyvoidset_SummaryRow(XlSummaryRow);
[JScript]
functiongetSummaryRow():XlSummaryRow
functionsetSummaryRow(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;
[VisualBasic]
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