PivotTable.ConvertToFormulas(Boolean) Method

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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

public:
 void ConvertToFormulas(bool ConvertFilters);

public void ConvertToFormulas (bool ConvertFilters);

Public Sub ConvertToFormulas (ConvertFilters As Boolean)

Parameters

ConvertFilters: 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.

Applies to