Gets or sets the location of the summary columns in the outline.

[Visual Basic]
Property SummaryColumn As XlSummaryColumn
[C#]
XlSummaryColumn SummaryColumn { get; set; }
[C++]
__property XlSummaryColumn get_SummaryColumn();
__property void set_SummaryColumn(XlSummaryColumn );
[JScript]
function get SummaryColumn() : XlSummaryColumn
function set SummaryColumn(XlSummaryColumn);

Property Value

SummaryColumn can be one of XlSummaryColumn values.

Example

This example sets SummaryColumn property on sheet one to xlSummaryOnLeft.

[C#]
book.Worksheets[1].Outline.SummaryColumn = XlSummaryColumn.xlSummaryOnLeft;

[Visual Basic]
book.Worksheets(1).Outline.SummaryColumn = XlSummaryColumn.xlSummaryOnLeft

[C++]
IWorksheet* sheet = book->Worksheets->Item[1];
sheet->Outline->SummaryColumn = XlSummaryColumn::xlSummaryOnLeft;

See Also

IOutline Interface | NativeExcel Namespace | IWorksheet.Outline Property | XlSummaryColumn Enumeration | IOutline.SummaryRow Property

---