Contains workbook and worksheet print options.
Contained In
Subelements
BlackAndWhite, CommentsLayout, DraftQuality, FitHeight, FitWidth, Gridlines, LeftToRight, HorizontalResolution, NumberOfCopies, PaperSizeIndex, RowColHeadings, Scale, ValidPrinterInfo, VerticalResolution
Remarks
All subelements are optional.
This example fits the print area to 3 pages wide by 4 pages long on legal-sized paper. The worksheet is printed in black and white using draft quality. The row and column headings are printed, and comments are printed at the end of the worksheet. The horizontal and vertical resolution is set to 600 dots per inch.
<x:Print>
<x:FitWidth>3</x:FitWidth>
<x:FitHeight>4</x:FitHeight>
<x:ValidPrinterInfo/>
<x:BlackAndWhite/>
<x:CommentsLayout>SheetEnd</x:CommentsLayout>
<x:RowColHeadings/>
<x:DraftQuality/>
<x:PaperSizeIndex>5</x:PaperSizeIndex>
<x:HorizontalResolution>600</x:HorizontalResolution>
<x:VerticalResolution>600</x:VerticalResolution>
</x:Print>