HotXLS Docs

SummaryColumn property

Returns or sets the location of the summary columns in the outline. Read/write XlSummaryColumn.

Syntax

property SummaryColumn: XlSummaryColumn;

Description

SummaryColumn can be one of these XlSummaryColumn constants.
xlLeft The summary column will be positioned to the left of the detail columns in the outline.
xlRight The summary column will be positioned to the right of the detail columns in the outline.

Example

This example sets SummaryColumn property on sheet one to xlSummaryOnLeft.

book.Worksheets[1].Outline.SummaryColumn := xlLeft;