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;