Partager via

PivotTable.ConvertToFormulas Method

  • Article

The ConvertToFormulas(Boolean) method is new in 1st_Excel12 and is used for converting a PivotTable to cube formulas.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Sub ConvertToFormulas ( _
    ConvertFilters As Boolean _
)
'Usage
Dim instance As PivotTable
Dim ConvertFilters As Boolean

instance.ConvertToFormulas(ConvertFilters)

void ConvertToFormulas(
    bool ConvertFilters
)

Parameters

  • ConvertFilters
    Type: System.Boolean

    Required Boolean Contains True or False to indicate the state of the ReportFilter area.

Remarks

The argument controls whether or not to convert the ReportFilter area of the PivotTable.

See Also

Reference

PivotTable Interface

PivotTable Members

Microsoft.Office.Interop.Excel Namespace