2.2.4.24.36 RowAxisItem

A type for representing a single row (2) or multiple contiguous hidden rows, from the range defined in the parent Table element (section 2.2.4.24.35).

 <s:complexType name="RowAxisItem">
   <s:sequence>
     <s:element name="Cell" type="Cell" minOccurs="0" maxOccurs="16384" />
   </s:sequence>
   <s:attribute name="Span" use="optional" >
     <s:simpleType>
       <s:restriction base="s:int">
         <s:minInclusive value="1" />
         <s:maxInclusive value="1048575" />
       </s:restriction>
     </s:simpleType>
   </s:attribute>
   <s:attribute name="Hidden" type="s:boolean" use="optional" default="false" />
   <s:attribute name="collapsed" type="s:boolean" default="false" use="optional" />
   <s:attribute name="outlineLevel" type="excelOutlineLevels" use="optional" />
   <s:attribute name="Index" type="excelRowNumber1Based" use="optional" />
   <s:attribute name="Height" type="rowHeight" use="optional"/>
 </s:complexType>

Cell: A worksheet cell that has data or has formatting applied to it. This element MUST NOT be present if the Hidden attribute is true. If the Hidden attribute is not true, there MUST be an element for every worksheet cell in the row (2) that has data or has formatting applied to it.

Span: If the element represents more than one row (2), this attribute denotes the additional number of rows represented by the element. This attribute MUST be present if the Hidden attribute is true and there is more than one contiguous hidden row. It MUST NOT be present otherwise.

Hidden: Specifies whether the rows are hidden. This attribute MUST be present and set to true if the rows represented by the element are hidden.

collapsed: If the row (2) represented by this element is part of a group, this attribute denotes whether the outlining at the current outline level is collapsed. This attribute MUST be present and set to true if the Hidden attribute is not true and the row (2) is part of a group and outlining for the outline level of the row (2) is collapsed. It MUST NOT be present otherwise.

outlineLevel: The outline level of outlining at the row (2) represented by the current element. This attribute MUST be present if the Hidden attribute is not true and the row (2) is part of a group. It MUST NOT be present otherwise.

Index: Index of the row (2) represented by the element. This attribute MUST NOT be present for the first Row element in the parent Table element. If it is not the first Row element, it MUST be present if the previous Row element has a Hidden attribute set to true. It MUST NOT be present otherwise.

Height: Height of the row (2), in points. This attribute MUST be present if the Hidden attribute is not true. It MUST NOT be present otherwise.