Contains workbook and worksheet print options.
Namespace | urn:schemas-microsoft-com:office:excel |
Schema name | XML Spreadsheet 2000 |
Element | Description |
---|---|
LeftToRight | Specifies whether a sort is done left to right by column or top to bottom by row, or whether a workbook or worksheet is printed left to right. |
BlackAndWhite | Specifies whether a workbook, worksheet, or embedded chart is printed in black and white. |
NoPrinterInfo | This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. |
DraftQuality | Specifies whether a workbook or worksheet is printed in draft mode. |
FitToPage | Specifies that the spreadsheet should be fit to the printed page. |
Scale | Specifies the percentage of reduction or enlargement for a printed worksheet or workbook. |
FitWidth | Specifies the number of pages to spread the width of a print area across. |
FitHeight | Specifies the number of pages to spread the height of a print area across. |
CommentsLayout | Specifies whether comments are printed and where they are printed. |
PrintErrors | Specifies what to print in cells with errors. |
ValidPrinterInfo | Specifies whether printer properties are valid for the active printer. |
HorizontalResolution | Specifies the horizontal resolution of a printer. |
VerticalResolution | Specifies the vertical resolution of a printer. |
Gridlines | Specifies whether gridlines are printed. |
PaperSizeIndex | Contains an index to a paper size used by a printer. |
NumberOfCopies | Specifies the number of copies to print. |
RowColHeadings | Specifies whether row and column headings are printed. |
None.
<xsd:complexType name="PrintType" >
<xsd:sequence>
<xsd:element name="LeftToRight" minOccurs="0">
</xsd:element>
<xsd:element name="BlackAndWhite" minOccurs="0">
</xsd:element>
<xsd:element name="NoPrinterInfo" minOccurs="0">
</xsd:element>
<xsd:element name="DraftQuality" minOccurs="0">
</xsd:element>
<xsd:element name="FitToPage" minOccurs="0">
</xsd:element>
<xsd:element name="Scale" minOccurs="0">
<xsd:simpleType>
<xsd:restriction base="xsd:int">
<xsd:minExclusive value="10" />
<xsd:maxExclusive value="400" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="FitWidth" type="xsd:int" minOccurs="0">
</xsd:element>
<xsd:element name="FitHeight" type="xsd:int" minOccurs="0">
</xsd:element>
<xsd:element name="CommentsLayout" minOccurs="0">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="InPlace" />
<xsd:enumeration value="PrintNone" />
<xsd:enumeration value="SheetEnd" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="PrintErrors" type="xsd:string" minOccurs="0" maxOccurs="1">
</xsd:element>
<xsd:element name="ValidPrinterInfo" minOccurs="0" maxOccurs="1">
</xsd:element>
<xsd:element name="HorizontalResolution" minOccurs="0" maxOccurs="1" type="xsd:integer">
</xsd:element>
<xsd:element name="VerticalResolution" minOccurs="0" maxOccurs="1" type="xsd:integer">
</xsd:element>
<xsd:element name="Gridlines" minOccurs="0">
</xsd:element>
<xsd:element name="PaperSizeIndex" type="xsd:integer" minOccurs="0">
</xsd:element>
<xsd:element name="NumberOfCopies" type="xsd:int" minOccurs="0">
</xsd:element>
<xsd:element name="RowColHeadings" minOccurs="0">
</xsd:element>
</xsd:sequence>
</xsd:complexType>