The Characters Object (ICharacters)
* The Characters object is not available in ExcelWriterSE, ExcelWriterLE,
or ExcelWriterFree.
The Characters object represents a range of characters within a cell. The
object is accessible through the property Cell.Characters.
Characters Methods and Properties
*This feature is not available in
ExcelWriterSE, ExcelWriterLE, or ExcelWriterFree.
| Characters Methods and Properties |
| Font * |
Sets or returns the Font
object used to format text within the specified Characters object.
Signature:
[VBScript]
Property Font As SAFont (read/write)
Examples:
[VBScript]
Set xlw = Server.CreateObject("Softartisans.excelwriter")
...
set ws = xlw.worksheets(1)
strHeader = "Rich Character Formatting Sample"
ws.Cells(3,3).Value = strHeader
set oCharacters = ws.Cells(3,3).Characters(1,Len(strHeader))
oCharacters.Font.Bold = True
oCharacters.Font.Size = 14
...
Top |
| Index * |
Returns the start index (the position of the first
character) of the specified Characters object.
Signature:
[VBScript]
Property Index As Long (read-only)
Top |
| Length * |
Returns the length (number of characters and spaces) in
the specified Characters object.
Signature:
[VBScript]
Property Length As Long (read-only)
Top |
| *This feature is not available in
ExcelWriterSE, ExcelWriterLE, or ExcelWriterFree.
|
Copyright © 2005, SoftArtisans, Inc.