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

ExcelXP Option Description

Options related to Workbook features
BLANK_SHEET Create a blank worksheet with the name given.
CONTENTS* Create a worksheet that will contain a table of contents.
CONTENTS_WORKBOOK Create a workbook table of contents and/or an index of workbooks
and/or an index of worksheets.
INDEX* Create a worksheet that will contain an index of worksheets.
MINIMIZE_STYLE Minimize styles written to stylesheets. (Caution: Can cause
unloadable XML files.)
SKIP_SPACE Multiplier for the space that follows the different types of output.
SUPPRESS_BYLINES Suppresses bylines in the worksheet.
SHEET_LABEL* Replace the prefix of the worksheet name with this value.
SHEET_NAME* Worksheet name to use for the next worksheet.
BLANK_SHEET Create a blank worksheet with the name given.
Options related to Tagset template documentation

Write user Help information about the tagset template options to the
system log.

DOC

8.15 Overview of EXCELXP Examples
Each of these examples writes an XML file that can be processed by Excel into a workbook.

Table 8.8: Brief Description of ExcelXP Examples.

Example
Number

General Description

8.16.1 Generating an XML Output File with No Options. This example shows a

simple ODS command and a PROC PRINT to output data into an XML file
that can be read by Microsoft Excel.

8.16.2 Adjusting Column Width Using Tagset Template Options. The

difference between this example and Example 8.16.1 is that the width of the
columns has been adjusted by the ABSOLUTE_COLUMN_WIDTH option.
This can aid in preparing a workbook for delivery. It is often time-
consuming to adjust more than a few columns.

8.16.3 Tagset Option to Hide Output Columns While Writing the File. The

added part of this example is the hidden columns. This is another task that
can become repetitive. I like to let the program do this work for me.

8.16.4 Apply an Excel “AUTOFILTER” to Selected Output Columns. This

example applies a filter to three Excel columns in the spreadsheet that is
generated. I have selected the filter in the Excel image to show the contents
of the filter.

8.16.5 Using Multiple Options to Produce a “Ready-to-Print” Spreadsheet. By

applying multiple options, you can enhance your printable output and make
your spreadsheets look better. This can help you get a spreadsheet ready to
print before you open the spreadsheet.

8.16.6 Creating a Table of Contents in an Excel Workbook. This example

produces a table of contents on a worksheet. You can use this table of
contents to jump to the worksheet page that contains the data described.