createSheetWithProperties

Purpose: Create a formatted sheet of a specified Excel Spreadsheet.

function createSheetWithProperties (
   input pxls_no as integer,
   input psheet_no as integer,
   input psheet_name as character,
   input psheet_properties as character
)

Where:
pxls_no is an integer value of the spreadsheet the formatted cell is being created in.
psheet_no is an integer value of the worksheet the formatted cell is being created in.
psheet_name the alpha-numeric name of the sheet.
psheet_properties is a pipe-delimited string listing properties of the sheet (eg. "TEXT=TRUE|CENTER=TRUE").

Valid Properties:

Property Name LANDSCAPE: values TRUE or FALSE with default of FALSE (XML,XLS)

Property Name GRIDLINES: values TRUE or FALSE with default of FALSE (XML-only)

Property Name FITTOPAGE: values 1 or NULL with default of NULL (XLS-only)

Property Name PRINTAREA: value TRUE or FALSE with default of FALSE (XLS-only)

Property Name PAPER: values of LETTER, TABLOID, LEDGER, LEGAL, STATEMENT, EXECUTIVE, A3, A4, A5, B4, and B5 with default of LETTER (XLS-only)

Property Name LEFTHEADERPICTURE:
Property Name CENTERHEADERPICTURE:
Property Name RIGHTHEADERPICTURE: value of header picture pathname to insert into document with default of no header pictures (XLS-only)

Property Name PASSWORD: value of password to protect workbook with default of no password protection (XLS-only)