PivotTable.CreateCubeFile(String, Object, Object, Object, Object) 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.

Creates a cube file from a PivotTable report connected to an Online Analytical Processing (OLAP) data source.

public string CreateCubeFile (string File, object Measures, object Levels, object Members, object Properties);

Public Function CreateCubeFile (File As String, Optional Measures As Object, Optional Levels As Object, Optional Members As Object, Optional Properties As Object) As String

Parameters

File: String

Required String. The name of the cube file to be created. It will overwrite the file if it already exists.

Measures: Object

Optional Object. An array of unique names of measures that are to be part of the slice.

Levels: Object

Optional 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: Object

Optional 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: Object

Optional Boolean. False results in no member properties being included in the slice. The default value is True.

Returns

String

Applies to