Share via

2.2.42 CT_RowAxisItem

  • Article

Referenced by: CT_Table

Represents a single row or multiple contiguous hidden rows, from the range defined in the parent CT_Table element.

Child Elements:

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

Attributes:

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

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

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

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

adjacentOutlineLevel: The outline level (1) of outlining at an adjacent row (2) to the row (2) represented by the current element. This attribute (2) MUST be present and set to the outline level (1) of outlining of the previous row (2) if all of the following conditions are met:

  • The current element is the first CT_RowAxisItem element in the parent CT_Table element.

  • The row (2) is not the first row (2) in the worksheet.

  • The Hidden attribute (2) is false and the row (2) is part of a group.

This attribute (2) MUST be present and set to the outlining level of outlining of the next row (2) if all of the following conditions are met:

  • The current element is the last CT_RowAxisItem element in the parent CT_Table element.

  • The row (2) is not the last row (2) in the worksheet.

  • The Hidden attribute (2) is false 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 (2) MUST NOT be present for the first CT_RowAxisItem element in the parent CT_Table element. If it is not the first CT_RowAxisItem element, it MUST be present if the previous CT_RowAxisItem element has a Hidden attribute (2) set to true. It MUST NOT be present otherwise.

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

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

 <xs:complexType name="CT_RowAxisItem">
   <xs:sequence>
     <xs:element name="Cell" minOccurs="0" maxOccurs="16384" type="CT_Cell"/>
   </xs:sequence>
   <xs:attribute name="Span" use="optional" default="0" type="ST_excelRowNumber"/>
   <xs:attribute name="Hidden" type="xs:boolean" use="optional" default="false"/>
   <xs:attribute name="collapsed" type="xs:boolean" default="false" use="optional"/>
   <xs:attribute name="outlineLevel" type="ST_excelOutlineLevels" use="optional" default="0"/>
   <xs:attribute name="adjacentOutlineLevel" type="ST_excelOutlineLevels" use="optional" default="0"/>
   <xs:attribute name="Index" type="ST_excelRowNumber1Based" use="optional"/>
   <xs:attribute name="Height" type="ST_rowHeight" use="optional"/>
 </xs:complexType>

See section 5.1 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).