Contains information related to page setup.
Namespace | urn:schemas-microsoft-com:office:excel |
Schema name | XML Spreadsheet 2000 |
Element | Description |
---|---|
Layout | Contains information related to page layout. |
Header | Contains information related to headers. |
Footer | Contains information related to footers. |
PageMargins | Contains information related to page margins. |
Attribute | Type | Required | Description | Possible Values |
---|---|---|---|---|
Orientation | Anonymous | optional | Specifies whether the page orientation is portrait or landscape |
|
CenterHorizontal | OneZeroType | optional | Specifies whether the worksheet is centered horizontally on the page when it is printed. |
|
CenterVertical | OneZeroType | optional | Specifies whether the worksheet is centered vertically on the page when it is printed. |
|
StartPageNumber | xsd:string | optional | Specifies the first page number that will be used when the worksheet is printed. | See external namespace. |
Margin | xsd:double | optional | Specifies the distance in points from the top of the page to the header. | See external namespace. |
Data | xsd:string | optional | Contains the content for the header. | See external namespace. |
Margin | xsd:double | optional | Specifies the distance in points from the top of the page to the footer. | See external namespace. |
Data | xsd:string | optional | Contains the content for the footer. | See external namespace. |
Left | xsd:double | optional | Specifies the size in points of the left margin. | See external namespace. |
Right | xsd:double | optional | Specifies the size in points of the right margin. | See external namespace. |
Top | xsd:double | optional | Specifies the size in points of the top margin. | See external namespace. |
Bottom | xsd:double | optional | Specifies the size in points of the bottom margin. | See external namespace. |
<xsd:complexType name="PageSetupType" >
<xsd:sequence>
<xsd:element name="Layout" minOccurs="0">
<xsd:complexType>
<xsd:attribute name="Orientation" use="optional" default="Portrait" form="qualified">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="Landscape" />
<xsd:enumeration value="Portrait" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="CenterHorizontal" use="optional" type="OneZeroType" default="0" form="qualified">
</xsd:attribute>
<xsd:attribute name="CenterVertical" use="optional" type="OneZeroType" default="0" form="qualified">
</xsd:attribute>
<xsd:attribute name="StartPageNumber" type="xsd:string" use="optional" default="1" form="qualified">
</xsd:attribute>
</xsd:complexType>
</xsd:element>
<xsd:element name="Header" minOccurs="0">
<xsd:complexType>
<xsd:attribute name="Margin" type="xsd:double" use="optional" form="qualified">
</xsd:attribute>
<xsd:attribute name="Data" type="xsd:string" use="optional" form="qualified">
</xsd:attribute>
</xsd:complexType>
</xsd:element>
<xsd:element name="Footer" minOccurs="0">
<xsd:complexType>
<xsd:attribute name="Margin" type="xsd:double" use="optional" form="qualified">
</xsd:attribute>
<xsd:attribute name="Data" type="xsd:string" use="optional" form="qualified">
</xsd:attribute>
</xsd:complexType>
</xsd:element>
<xsd:element name="PageMargins" minOccurs="0">
<xsd:complexType>
<xsd:attribute name="Left" type="xsd:double" use="optional" form="qualified">
</xsd:attribute>
<xsd:attribute name="Right" type="xsd:double" use="optional" form="qualified">
</xsd:attribute>
<xsd:attribute name="Top" type="xsd:double" use="optional" form="qualified">
</xsd:attribute>
<xsd:attribute name="Bottom" type="xsd:double" use="optional" form="qualified">
</xsd:attribute>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>