createCell

Purpose: Create a formatted cell by row and column within a specified worksheet of a specified Excel Spreadsheet.

function createCell (
   input pxls_no as integer,
   input psheet_no as integer,
   input prow_no as integer,
   input pcolumn_no as integer,
   input pcell_value as character,
   input pcell_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.
prow_no the formatted cell's row (as an integer starting at 1).
pcolumn_no the formatted cell's column (as an integer starting at 1).
pcell_value is the string value of the cell content. Basic inline formatting is allowed in the cell value (eg. "Hello World").
pcell_properties is a pipe-delimited string listing properties of the cell (eg. "TEXT=TRUE|CENTER=TRUE").

Valid Properties:

Property Name FONT: valued with valid font name with default of 'Calibri'

Property Name FONTSIZE: valued with integer font size with default of 11

Property Name TEXT: values TRUE or FALSE with default of FALSE

Property Name FORMAT: values Excel format string (eg. "FORMAT=$#,##0.00);($#,##0.00)") with default of <blank></blank>

Property Name BOLD: values TRUE or FALSE with default of FALSE

Property Name UNDERLINE: values TRUE or FALSE with default of FALSE

Property Name SUPERSCRIPT: values TRUE or FALSE with default of FALSE

Property Name SUBSCRIPT: values TRUE or FALSE with default of FALSE

Property Name CENTER: values TRUE or FALSE with default of ?

Property Name RIGHTALIGN: values TRUE of FALSE with default of ?

Property Name LEFTALIGN: values TRUE or FALSE with default of ?

Property Name BGCOLOR: values BLACK, GRAY, WHITE, RED, GREEN, LIGHTGREEN, BLUE, LIGHTBLUE, YELLOW, LIGHTYELLOW, MAGENTA, CYAN, ORANGE, or LIGHTORANGE with
default of ?

Property Name FGCOLOR: values BLACK, GRAY, WHITE, RED, GREEN, LIGHTGREEN, BLUE, LIGHTBLUE, YELLOW, LIGHTYELLOW, MAGENTA, CYAN, ORANGE, or LIGHTORANGE with default of ?

Property Name BOX: values TRUE or FALSE with default of FALSE

Property Name LIGHTBOX: values TRUE or FALSE with default of FALSE

Property Name HEAVYBOX: values TRUE or FALSE with default of FALSE