PPT Subcommand (OUTPUT EXPORT Command)
The PPT
subcommand exports output in PowerPoint
format. This is available only on Windows operating systems and requires
an installed version of PowerPoint 97 or later.
- Pivot tables are exported as Word tables, and each table is a separate slide in the PowerPoint file. All formatting attributes of the pivot table are retained--for example, cell borders, font styles, and background colors.
- Graphics are exported in TIFF format, and each graphic is separate slide in the PowerPoint file. (Note: Graphics includes charts, tree diagrams, and any Model Viewer items, including Model Viewer tables.)
- Text output is not included.
DOCUMENTFILE Keyword
The required DOCUMENTFILE
keyword specifies the
name of the PowerPoint document. The keyword is followed by an equals
sign and a quoted file specification, as in:
OUTPUT EXPORT
/PPT DOCUMENTFILE='/mydocs/myresults.ppt'.
SLIDESIZE Keyword
The SLIDESIZE
keyword controls the slide dimensions
of the exported file. The keyword is followed by an equals sign and
one of the following alternatives:
INCHES(width, height). Height and width specified in inches. Both values are required and both must be positive numbers.
MM(width, height). Height and width specified in millimeters. Both values are required and must be positive numbers.
TOPMARGIN, BOTTOMMARGIN, LEFTMARGIN, and RIGHTMARGIN Keywords
These keywords control the margins for the exported document. Each keyword is followed by an equals sign and one of the following alternatives:
INCHES(n). Margin specified in inches. The value must be a positive number.
MM(n). Margin specified in millimeters. The value must be a positive number.
NOTESCAPTIONS Keyword
The NOTESCAPTIONS
keyword controls the inclusion
of pivot table footnotes and captions in the exported document. The
keyword is followed by an equals sign and one of the following alternatives:
YES. Include footnotes and captions. This is the default.
NO. Do not include footnotes and captions.
SLIDETITLES Keyword
The SLIDETITLES
keyword controls the inclusion
slide titles of the exported file. The title is formed from the outline
entry for the item in the outline pane of the Viewer. The keyword
is followed by an equals sign and one of the following alternatives:
YES. Include slide titles. This is the default.
NO. Do not include slide titles.
WIDETABLES Keyword
The WIDETABLES
keyword controls
the treatment of pivot tables that are too wide for the document width
(the specified page width minus the left and right margins). The keyword
is followed by an equals sign and one of the following alternatives:
WRAP. Wrap wide tables. The table is divided into sections that will fit within the defined document width. Row labels are repeated for each section of the table. This is the default. If the row labels are too wide for the defined document width, the table is exported without wrapping and will appear truncated in the document.
SHRINK. Shrink wide tables to fit within the document width. Font size and column width are reduced so that the table fits within the document width.
ASIS. Do not shrink or wrap wide tables. The document width expands to accommodate the widest table.
Example
OUTPUT EXPORT
/PPT DOCUMENTFILE='/mydocs/myresults.ppt'
SLIDESIZE=INCHES(10, 7.5)
SLIDETITLES=NO
WIDETABLES=ASIS.