Print element

Contains workbook and worksheet printing options.

Usage

      
<Print />

    

Element Information

Element type PrintType
Namespace urn:schemas-microsoft-com:office:excel
Schema name XML Spreadsheet 2000

Elements and Attributes

Parent Elements

Element Description
WorksheetOptions Contains information about options related to the worksheet.

Child Elements

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.

Attributes

None.

Definition

      
<xsd:element name="Print" type="PrintType" minOccurs="0" >
</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