Excel Client:DrillElement

Function

DrillElement(DimensionName, ElementName, OnAxe, Open)

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

Parameter	Description
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). 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	Indicates whether the element is opened or closed. 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

DrillElement("Produkte";"Rennräder";"RowDim";"Close")