Dokumentacija HotXLS

SummaryRow svojstvo

Vraća or sets the location of the summary rows in the outline. Read/write XlSummaryRow

Sintaksa

property SummaryRow: XlSummaryRow;

Opis

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

Primjer

This example sets SummaryRow property on sheet one to xlAbove

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