PivotTableExcelWriter Properties

Gets or sets custom formatting handler for dimension labels.

Gets or sets function for formatting dimension key values.

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).

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 pivot table starting cell column index (default is 1).

Gets or sets pivot table starting cell row index (default is 1).

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).

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).