Database Reference
In-Depth Information
ExcelXP Option
Description
HIDDEN_COLUMNS*
Range or list of column numbers to hide.
WIDTH_FUDGE
This value is used to calculate an approximate table column width.
WIDTH_POINTS
Override value for width calculations.
Options related to Row features
AUTOFIT_HEIGHT
If selected, no row heights will be specified.
ROW_HEIGHT_FUDGE
A fudge value to add to the row height for each row.
ROW_HEIGHTS
Positional list of point sizes to use for row heights.
ROW_REPEAT
Repeat rows across pages when printing.
ROWCOLHEADINGS
This value turns on row and column headings for printing.
Options related to Data features
ASCII_DOTS
Turn off and on leading dots in textual 'batch' output.
AUTO_SUBTOTALS
Add a subtotal function to the summary line of PROC PRINT.
AUTOFILTER*
Turn on auto filter for all columns or a range of columns.
AUTOFILTER_TABLE
Specify which table on the worksheet should get the filters.
CONVERT_PERCENTAGES
Remove percent sign, apply Excel percent format, and multiply by
100.
FORMULAS
Data values that start with an '=' will become formulas.
NUMERIC_TEST_FORMAT
Used for determining if a value is numeric or not.
THOUSANDS_SEPARATOR
The character used for indicating thousands in numeric values.
Options related to Printing features
BLACKANDWHITE
This value turns on black and white for printing.
CENTER_HORIZONTAL
This value controls horizontal centering for printing.
CENTER_VERTICAL
This value controls vertical centering for printing.
CURRENCY_FORMAT
The currency format specified for Excel to use.
CURRENCY_SYMBOL
Detection of currency formats and symbols so that Excel outputs
numbers.
DECIMAL_SEPARATOR
The character used for the decimal point.
DPI*
This value determines the dots per inch for printing.
DRAFTQUALITY
This value turns on draft quality for printing.
FITTOPAGE
Fit to page when printing.
GRIDLINES
This value turns on gridlines for printing.
PAGE_ORDER_ACROSS
If specified, the worksheet page order will be set to print across, and
then down.
PAGEBREAKS
Insert page break lines in the worksheet.
PAGES_FITHEIGHT
Determine number of pages down to fit the worksheet when
printing.
PAGES_FITWIDTH
Determine number of pages across to fit the worksheet when
printing.
SCALE
This value determines the scale level for printing.
SHEET_INTERVAL*
Interval to divide the output between worksheets.
Search WWH ::
Custom Search