Description
| Sets a value into the selected cell, using the current font settings from the XLS.Font object. Optionally applies some extra formatting to that cell.
The span for NewValue can hold multiple adjecent columns. This is done by placing a vertical bar ("|") between each value in the NewValue string. Each part of the string will then be placed in separate cells, starting at column Col.
Please take notice that the rows and colums are one-based arrays. Therefore, when referring to Excel cell "A1", row and column numbers are 1 and 1.
Parameter
| Description
| Row
| Long integer, required. The row in the active worksheet.
| Col
| Integer, required. The (first) column in the active worksheet.
| NewValue
| Variant, required. Can hold any numeric or string value.
When using multiple values to set a range of adjecent cells, use a string value with vertical bars ("|") to separate each value.
| UseBold
| Boolean, optional. If True, The new value(s) are formatted in bold text. Default value is False.
| ForceText
| Boolean, optional. When True, value(s) that are numeric will be treated as plain text. Default value is False.
| Alignment
| Enumerated, optional. Applies alignment using these values:
xlAlignCenter
xlAlignDistributed
xlAlignJustify
xlAlignLeft
xlAlignNotApplicable
xlAlignRight (this is the default value when omitted)
| Highlight
| Boolean, optional. When True, the selection will be highlighted using standard highlight color settings.
|
|