PivotTableHtmlWriter Properties

Allow HTML in dimension labels/headers/formatted values (false by default).

Enables ability to collapse groups and applies specified expand/collapse state.

Gets or sets CSS class for table column header cells ('pvtColumn' by default).

Gets or sets custom formatting handler for dimension labels.

Gets or sets custom formatting handler for table row/column labels (key,dimension)->(label).

Gets or sets custom formatting handler for measure headers (applicable only if several measures are used)

Gets or sets custom formatting handler for table cell values (measure,measure index)->(value)

Include grand totals value into resulting pivot table (true by default).

Gets or sets CSS class for measure header cells ('pvtMeasure' by default).

Get or sets dimension label rendering option (by default both column and row dimension labels are rendered).

Gets or sets flag which indicates whether writer should render "data-sort-index" attributes.

Gets or sets flag which indicates whether writer should render "data-sort-index" attributes.

Get or sets flag which indicates whether writer should render headers in THEAD/TBODY section.

Gets or sets flag which indicates whether writer should render "data-value-index" attributes.

Repeat duplicate keys across dimensions in one group (repeat for both rows and columns by default).

Repeat keys in group of the same dimension (no repeat by default).

Gets or sets CSS class for table row header cells ('pvtRow' by default).

Include subtotal columns into resulting pivot table (false by default).

Explicit list of dimensions with subtotals (null = generate subtotals for all groups).

Suffix added to subtotal keys (" Total" by default).

Include subtotal rows into resulting pivot table (false by default).

Gets or sets CSS class for HTML table ('pvtTable' by default).

Include totals column into resulting pivot table (true by default).

Gets or sets title text for totals column header (Totals by default).

Determins totals column position (first column or last column).

Include totals row into resulting pivot table (true by default).

Gets or sets title text for totals row header (Totals by default).

Determins totals row position (first row or last row).