ICustomPivotTable

Defines the public contract for the CustomPivotTable class. Manages pivot table creation on a dedicated worksheet during linelist building. Each call to Add creates a new PivotTable block (title + pivot) stacked vertically on the sheet.

Methods

Add #

Create a pivot table from a ListObject source and add a titled block

Signature:

Public Sub Add(ByVal title As String, _
               ByVal tableName As String, _
               Optional ByVal pivotName As String = "Pivot Table")

Pivot table creation and formatting. Creates a PivotTable using PivotTableWizard with the given table as data source. Writes a styled title above the pivot and stores the title cell address as a worksheet-level HiddenName (RNG_PivotTitle_). Successive calls stack blocks vertically on the sheet.

Parameters:

title: String. Display label for the pivot block (typically the sheet name).
tableName: String. Name of the source ListObject providing pivot data.
pivotName: String. Localised prefix for the title (e.g. "Pivot Table"). Defaults to "Pivot Table".

Format #

Apply design formatting to the pivot table worksheet

Signature:

Public Sub Format(ByVal design As ILLFormat)

Delegates to ILLFormat.ApplyFormat with the HListCustomPivotTables scope to style the entire pivot worksheet according to the linelist design.

Parameters:

design: ILLFormat. The format object providing style rules.