Excel Client:DrillElement

DrillElement(DimensionName, ElementName, OnAxe, Open)

This function allows the dimension to be opened or closed by double-clicking on the cell.

Parameter

DimensionName	The name of the dimension.
ElementName	The element that must be opened or closed.
OnAxe	The axis on which the element is located (distinction between open/close, down/up, left/right).
Open	Indicates whether the element is opened or closed.

OnAxe can contain only two text values:

RowDim	Open/close is executed downward/upward (on the line level).
ColDim	Open/close is executed to the left/right (on the column level).

Open can contain only two text values:

Open	The element is opened and will be closed at the next double-click.
Close	The element is closed and will be opened at the next double-click.

Example

Function

DrillElement(„Produkte“;“Rennräder“;“RowDim“;“Close“)