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