CubeFields.AddSet(String, String) 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.

Adds a new CubeField object to the CubeFields collection.

public:
 Microsoft::Office::Interop::Excel::CubeField ^ AddSet(System::String ^ Name, System::String ^ Caption);

public Microsoft.Office.Interop.Excel.CubeField AddSet (string Name, string Caption);

Public Function AddSet (Name As String, Caption As String) As CubeField

Parameters

Name: String

Required String. A valid name in the SETS schema rowset.

Caption: String

Required String. A string representing the field that will be displayed in the PivotTable view.

Returns

CubeField

Remarks

The CubeField object corresponds to a set defined on the Online Analytical Processing (OLAP) a provider for the cube.

If a set with the name given in the argument Name does not exist, the AddSet method will return a run-time error.

Applies to