PivotTable.CreateCubeFile Method
Creates a cube file from a PivotTable report connected to an Online Analytical Processing (OLAP) data source.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Function CreateCubeFile ( _
File As String, _
Measures As Object, _
Levels As Object, _
Members As Object, _
Properties As Object _
) As String
'Usage
Dim instance As PivotTable
Dim File As String
Dim Measures As Object
Dim Levels As Object
Dim Members As Object
Dim Properties As Object
Dim returnValue As String
returnValue = instance.CreateCubeFile(File, _
Measures, Levels, Members, Properties)
string CreateCubeFile(
string File,
Object Measures,
Object Levels,
Object Members,
Object Properties
)
Parameters
File
Type: System.StringRequired String. The name of the cube file to be created. It will overwrite the file if it already exists.
Measures
Type: System.ObjectOptional Object. An array of unique names of measures that are to be part of the slice.
Levels
Type: System.ObjectOptional Object. An array of strings. Each array item is a unique level name. It represents the lowest level of a hierarchy that is in the slice.
Members
Type: System.ObjectOptional Object. An array of string arrays. The elements correspond, in order, to the hierarchies represented in the Levels array. Each element is an array of string arrays that consists of the unique names of the top level members in the dimension that are to be included in the slice.
Properties
Type: System.ObjectOptional Boolean. False results in no member properties being included in the slice. The default value is True.
Return Value
Type: System.String