Excel Client:ElemChildName: Difference between revisions

From CoPlanner 10
Jump to navigationJump to search
No edit summary
No edit summary
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
==ElemChildName(Dimension, StartElement, Index) ==
==[[Excel_Client:Functions_(Formulas)|Function]]==
 
<span {{CoPFormel}}>ElemChildName(Dimension, StartElement, Index) </span>


This [[Excel_Client:Functions_(Formulas)|function]] returns the ChildElement of the element StartElement at the position Index. The value of -1 is returned if the element is not found, if the dimension does not contain the element StartElement, or if there is no element at the position Index.
This [[Excel_Client:Functions_(Formulas)|function]] returns the ChildElement of the element StartElement at the position Index. The value of -1 is returned if the element is not found, if the dimension does not contain the element StartElement, or if there is no element at the position Index.


===Parameter===
{| class="wikitable" width={{{breite|80%}}}
 
|- {{Tabellentitel}}
{| style=cellspacing="1" cellpadding="5" border="1" width={{{breite|50%}}}
| width="150px"|Parameter
| Description
|-
|-
|width="200pt" style=background-color:#f6f6f6 |'''Dimension''' 
|Dimension
|The dimension to which the operation applies.
|The dimension to which the operation applies.
|-
|-
|style=background-color:#f6f6f6 |'''StartElement '''
|StartElement
|The parent element of the required element.
|The parent element of the required element.
|-
|-
|style=background-color:#f6f6f6 |'''Index'''
|Index
|The position of the required element.  
|The position of the required element.  
|-
|-
|}
|}
   
   
 
==Example ==
===Example ===
<span {{CoPFormel}}>ElemChildName("Zeit";"2005",5) </span><br>
 
returns MAY 2005
{| style=cellspacing="1" cellpadding="5" border="1" width={{{breite|50%}}}
|-
|width="200pt" style=background-color:#f6f6f6 |'''Function'''
|style=background-color:#f6f6f6 |'''Result'''
|-
|ElemChildName(„Zeit“;“2005“,5)  
|MAY 2005
|}
 


__NOEDITSECTION__
__NOEDITSECTION__
[[Category:Excel_Client_Formulas|ElemChildName]]
[[Category:Excel_Client_Formulas|ElemChildName]]
[[de:Excel_Client:ElemChildName]]
[[de:Excel_Client:ElemChildName]]

Latest revision as of 16:47, 15 April 2014

Function

ElemChildName(Dimension, StartElement, Index)

This function returns the ChildElement of the element StartElement at the position Index. The value of -1 is returned if the element is not found, if the dimension does not contain the element StartElement, or if there is no element at the position Index.

Parameter Description
Dimension The dimension to which the operation applies.
StartElement The parent element of the required element.
Index The position of the required element.

Example

ElemChildName("Zeit";"2005",5)
returns MAY 2005