Τεκμηρίωση HotXLS

SummaryRow ιδιότητα

Επιστρέφει or sets the location of the summary rows in the outline. Read/write XlSummaryRow

Σύνταξη

property SummaryRow: XlSummaryRow;

Περιγραφή

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

Παράδειγμα

This example sets SummaryRow property on sheet one to xlAbove

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