Worksheet Options

WKS-NAME-ROW (Autosense/1st-row/No-name/Num)

Reading of worksheet variable names

 

WKS-DATA-RANGE   (autosense| a named range e.g A12:Z35)

Specifying a data range as input

 

WKS-READ-VAR-LABS (Y/N)

Read variable labels from second row of worksheets

 

WKS-WRITE-VAR-LABS (Y/N)

Write variable labels into worksheets second row

 

WKS-BLANK-ROWS   (Stop/Skip/Use)

Treatment of worksheet null rows

 

CONCATENATE-PAGES  (Y/N)

Concatenate worksheet pages into a single output file

WKS-NA-STRING     (none/string)

Indicate a string to be considered numeric missing when reading worksheets

 

WKS-RD-BLANK-COLS  (Y/N)

Transfer blank columns from worksheets

 

WKS-WRITE-VNAMES (Y/N)

Write a field name row in worksheet output

 

WKS-WRITE-VAR-LABS (Y/N)

Write variable labels in the second row of worksheets.

 

XLX-WRITE-VAL-LABS (Y/N)

Write value labels instead of numbers to Excel.

 

EXCEL-NEWLINE-STR [blanks | a string]

Replace Excel newlines with blanks or a string.