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. |
|
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