Creating Output Files with ODS for Use by Excel - Exchanging Data Between SAS and Microsoft Excel - page 137

Figure 8.36 has one of the columns with the filter applied highlighted by opening the Filter tab to show
some of the options available for selection in that column.

Figure 8.36: Excel Output Showing a Filtered Column Created by ExcelXP Directly.

Example 8.16.5 Using Multiple Options to Produce a “Ready-to-Print”
Spreadsheet
This example uses several features of the ExcelXP tagset to produce a customized output worksheet in the
Excel output workbook.

Table 8.12: Options Used in Example 8.16.5.

ExcelXP Option Setting in Example Result

ABSOLUTE_COLUMN_WIDTH '4,11,10.5,10,5,8,9,8' Set column widths for each

column.

FROZEN_HEADERS '1' Freeze the first row of the

spreadsheet when scrolling.

ORIENTATION 'Landscape' Pre-set the page output to landscape

for printing.

WRAPTEXT 'Yes' Allow text in an Excel cell to wrap

onto the next line.

ZOOM '50' Shrink the size of the displayed

spreadsheet to 50% of the original
size.