HotXLS-dokumentation

SummaryRow egenskap

Returnerar or sets the location of the summary rows in the outline. Read/write XlSummaryRow

Syntax

property SummaryRow: XlSummaryRow;

Beskrivning

SummaryRow can be one of these XlSummaryRow constants
xlAbove Microsoft Word-style outlines, where category headers are above the detailed information
xlBelow Accounting-style outlines, where summations are below the detailed information

Exempel

This example sets SummaryRow property on sheet one to xlAbove

book.Worksheets[1].Outline.SummaryRow := xlAbove;