NativeExcel for .Net Developer's Reference

IOutline.SummaryColumn Property

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

[Visual Basic]
PropertySummaryColumnAsXlSummaryColumn
[C#]
XlSummaryColumnSummaryColumn{get;set;}
[C++]
__propertyXlSummaryColumnget_SummaryColumn();
__propertyvoidset_SummaryColumn(XlSummaryColumn);
[JScript]
functiongetSummaryColumn():XlSummaryColumn
functionsetSummaryColumn(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;
[VisualBasic]
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