API Reference
ExcelSubtotalOptions
Options for creating a reusable subtotal summary block from worksheet rows.
Inheritance
- Object
- ExcelSubtotalOptions
Usage
Explore 1 API references to this type
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Accepted by parameters 1
Constructors
public ExcelSubtotalOptions() #Inherited Methods
public virtual Boolean Equals(Object? obj) #BooleanParameters
- obj Object?
Properties
public Int32 HeaderRow { get; set; } #Header row that contains source labels.
public IReadOnlyList<Int32> ValueColumns { get; set; } #Columns to aggregate into subtotal formulas.
public Int32? SummaryStartRow { get; set; } #First row for the generated summary block. Defaults to two rows below ExcelSubtotalOptions.DataEndRow.
public ExcelSubtotalFunction Function { get; set; } #Function used by generated SUBTOTAL formulas.
public Boolean IncludeHeader { get; set; } #Whether to write a header row for the summary block.
public Boolean IncludeGrandTotal { get; set; } #Whether to add a grand total row after group subtotal rows.
public Boolean OutlineDetailRows { get; set; } #Whether to apply Excel row outline metadata to detail groups.
public Boolean HideDetailRows { get; set; } #Hide detail rows when applying outline metadata.
public Byte OutlineLevel { get; set; } #Outline level used for grouped detail rows.
public String LabelSuffix { get; set; } #Text appended to each group key in the subtotal label cell.
public String BlankGroupLabel { get; set; } #Label used when the group key cell is blank.
public String GrandTotalLabel { get; set; } #Label used for the optional grand total row.