Row element

Defines the formatting and properties for one or more adjacent rows.

Usage

      
<Row
	AutoFitHeight="TrueFalseType"
	Height="xsd:double"
	Index="xsd:positiveInteger"
	Span="xsd:nonNegativeInteger"
	StyleID="xsd:IDREF"
	Hidden="See attribute definition.	c:caption="[external type]"
/>

    

Element Information

Element type Anonymous
Namespace urn:schemas-microsoft-com:office:spreadsheet
Schema name XML Spreadsheet 2002

Elements and Attributes

Parent Elements

Element Description
Table Defines the table to contain the cells of the current worksheet. Only one instance of a Table element is valid for a single worksheet.

Child Elements

Element Description
Cell Defines the properties of a cell in a worksheet.

Attributes

Attribute Type Required Description Possible Values
AutoFitHeight TrueFalseType optional Specifies whether the height of a row is automatically resized to fit the contents of cells.
  • 0
  • 1
Height Anonymous optional Specifies the height of a row in points. This value must be greater than or equal to zero.

minInclusive = 0

Index xsd:positiveInteger optional Specifies the position of a row within a table. See external namespace.
Span xsd:nonNegativeInteger optional Specifies the number of adjacent rows with the same formatting as the defined row. See external namespace.
StyleID xsd:IDREF optional Contains a reference to an ID attribute previously defined in a Style element. Used to apply that defined style to a row. See external namespace.
Hidden None optional Specifies whether an element is visible. The Hidden attribute can be applied to the NamedRange, Column, and Row elements. n/a
c:caption external ref optional See external namespace. See external namespace.

Definition

      
<xsd:element name="Row" minOccurs="0" maxOccurs="unbounded" >
  <xsd:complexType>
    <xsd:sequence>
      <xsd:element ref="Cell" minOccurs="0" maxOccurs="unbounded" />
    </xsd:sequence>
    <xsd:attribute form="qualified" name="AutoFitHeight" type="TrueFalseType" use="optional" default="1">
    </xsd:attribute>
    <xsd:attribute form="qualified" name="Height" use="optional">
      <xsd:simpleType>
        <xsd:restriction base="xsd:double">
          <xsd:minInclusive value="0" />
        </xsd:restriction>
      </xsd:simpleType>
    </xsd:attribute>
    <xsd:attribute ref="Hidden" default="0">
    </xsd:attribute>
    <xsd:attribute form="qualified" name="Index" type="xsd:positiveInteger" use="optional">
    </xsd:attribute>
    <xsd:attribute form="qualified" name="Span" type="xsd:nonNegativeInteger" use="optional" default="0">
    </xsd:attribute>
    <xsd:attribute form="qualified" name="StyleID" type="xsd:IDREF" use="optional">
    </xsd:attribute>
    <xsd:attribute ref="c:caption" use="optional" />
  </xsd:complexType>
</xsd:element>


    
©2003-2004 Microsoft Corporation. All rights reserved. Permission to copy, display and distribute this document is available at: http://msdn.microsoft.com/library/en-us/odcXMLRef/html/odcXMLRefLegalNotice.asp