XLS Object

SetValue

 
Syntax
 
XLS.SetValue Row, Col, NewValue[, UseBold][, ForceText][, Alignment][, Highlight]
 
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.
 
See Also
MergeCells, Font, SelectRange, Value
Example
 
Sub Main
 
Dim x As Integer
 
   If Not XLS.AppInit() Then Exit Sub
 
   XLS.AppVisible = True
 
   XLS.AddWorkBook
   XLS.AddWorkSheet "Test1"
 
   For x = 1 To 10
      XLS.SetValue x, 1 _
                  , "Cel 1|Dit is 2|En dat is 3|4|5|laatste cel" _
                  , HighLight:= True
   Next x
 
   XLS.AppClose
 
End Sub